[Remote] Sr. Finance Operations Analyst

Note: The job is a remote job and is open to candidates in USA. Macmillan Learning is a leading US publisher of Trade and Academic titles, seeking a Sr. Finance Operations Analyst for their Gordonsville facility. This role involves driving business analytics, financial planning and analysis, and Order-to-Cash operational intelligence to inform strategic decisions and improve performance.

Responsibilities

• Support annual budgeting, forecasting, and long-range planning activities for MPS Finance Operations, partnering with FP&A leadership to deliver timely and accurate financial models
• Develop and maintain monthly/quarterly financial performance reporting, including variance analysis, trend identification, and forward-looking commentary for senior leadership
• Maintain rolling forecasts, scenario models, and what-if analyses to support business decisions
• Translate complex financial data into concise, actionable narratives and presentations for Finance and executive audiences
• Monitor financial KPIs and operational metrics, surfacing risks and opportunities proactively
• Liaise with New York Finance and Accounting teams to facilitate the formal allocation of capital project identifiers
• Oversee the Capital Schedule and Budget documentation, integrating revised cash flow projections and depreciation timelines to support accurate forecasting and long-range financial planning
• Accumulate, analyze, interpret, and report OTC operational performance data across the full revenue cycle—from order entry through cash application—for both functional teams and senior management
• Develop and implement KPIs, operational plans, dashboards, and reports aligned with OTC business objectives, including DSO, collection effectiveness, billing accuracy, and dispute resolution metrics
• Build complex dimensional data models derived from raw data pulled from multiple source systems (SAP, Ingenta Vista, Freshworks, and others)
• Maintain the integrity of OTC master data, ensuring consistency and reliability across all reporting outputs
• Collaborate with OTC Managers and Finance stakeholders to gather requirements and translate them into analytical and reporting deliverables
• Develop and maintain Power BI dashboards and reports with a focus on scalability, self-service access, and actionable insight
• Design and deliver automated reporting solutions that reduce manual effort, improve cycle time, and increase accuracy across Finance Operations
• Quickly gather data from multiple systems to provide timely analysis along with clear recommendations and action plans
• Apply structured development methodologies (e.g., Agile) to deliver solutions efficiently and iteratively
• Leverage AI tools—including Anthropic Claude and Google Gemini—to develop intelligent automation for financial reporting, data summarization, commentary generation, and exception analysis
• Design and deploy AI-assisted workflows that reduce manual, repetitive finance tasks, improving speed and accuracy of month-end close, reconciliations, and management reporting packages
• Build and refine prompt engineering frameworks and AI-assisted templates within Claude and Gemini to support FP&A narratives, OTC performance summaries, and operational insights
• Identify opportunities across Finance Operations where generative AI and machine learning can drive measurable efficiency gains, and develop proof-of-concept solutions in partnership with IT and Finance leadership
• Champion AI adoption within the Finance Operations team by documenting best practices, training peers, and maintaining governance around AI tool usage

Skills

• Bachelor's degree in Finance, Accounting, Business Systems, Statistics, or a related quantitative discipline
• Minimum 5–7 years of hands-on experience in a Finance Analytics, FP&A, Business Intelligence, or Data Analyst role, preferably within a Finance Operations or Shared Services environment
• Demonstrated experience supporting FP&A processes including budgeting, forecasting, and financial variance analysis
• Demonstrated experience with Order-to-Cash metrics and data, including Accounts Receivable, Collections, Billing, and Cash Application
• Strong knowledge of SAP (AR, GL modules preferred)
• Advanced proficiency in Microsoft Excel, including complex modeling, dynamic arrays, and Power Query
• Strong Microsoft Power BI knowledge and experience, including DAX, data modeling, and report development
• Hands-on experience using AI tools such as Anthropic Claude and/or Google Gemini for business process automation, reporting, or data analysis
• Excellent verbal and written communication skills, with the ability to present findings effectively at all levels of the organization
• Proven ability to work independently with minimal supervision and manage multiple competing priorities in a fast-paced environment
• Experience with Visual Basic for Applications (VBA) and/or SQL/database development
• Experience with IBM Cognos Analytics for enterprise reporting and data visualization
• Familiarity with Ingenta Vista ERP and fulfillment software, including its data structures and reporting capabilities
• Experience working with Freshworks applications (e.g., Freshdesk, Freshservice) and extracting/analyzing data from the platform
• Demonstrated experience developing AI-assisted automation using Claude (Anthropic) or Gemini (Google) API integrations, prompt engineering, or workflow automation platforms (e.g., Zapier, Make, or similar)
• Experience with Google Workspace productivity tools and Google Gemini for Workspace (Docs, Sheets, Slides AI features)
• Microsoft Access database design, queries, and reporting experience
• Six Sigma, Lean, or other process improvement certification/experience
• MBA or advanced degree in Finance, Data Analytics, or related field

Benefits

• $1,000 Retention Bonus (after 1 year)
• Paid Time Off
• 11 Paid Holidays
• 401(k) Plan Eligibility
• Competitive Benefits

Company Overview