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
Macmillan Learning improves lives through learning and offers content developed in partnership with the authors, educators, and developers. It is a sub-organization of Macmillan. It was founded in 1946, and is headquartered in New York, New York, USA, with a workforce of 501-1000 employees. Its website is http://www.macmillanlearning.com/.