Sr. Finance Operations Analyst

Come join our team!

$1,000 Retention Bonus (after 1 year)

Paid Time Off

11 Paid Holidays

401(k) Plan Eligibility

Competitive Benefits 

MPS, a division of Macmillan Publishers, a leading US publisher of Trade and Academic titles, has a job opening for a Sr. Finance Operations Analyst in our Gordonsville facility. MPS provides back office support, warehousing, and, fulfillment for Macmillan US, and is their primary distribution facility for North America. 

About the Role:

The Sr. Finance Operations Analyst is a highly visible, cross-functional role within MPS Finance Operations that drives business analytics, financial planning and analysis (FP&A), and Order-to-Cash (OTC) operational intelligence. Serving as a trusted analytical partner to Finance Operations leadership, this individual delivers timely, accurate, and insightful reporting across both FP&A and OTC functions to inform strategic decisions, improve performance, and support revenue growth.

The role blends deep financial acumen with advanced data and analytics capabilities, including the use of modern AI tools to automate processes and elevate reporting quality. Success in this position is demonstrated by reducing manual reporting burdens through AI and automation, increasing the speed and quality of financial insights, and fostering a data-driven culture. The position reports to the Manager Financial Operations and works in close partnership with FP&A, Accounts Receivable, Collections, Credit, Billing, and broader Finance stakeholders. 

What Success Looks Like:

In this role, success is measured by your ability to bridge the gap between complex financial data and strategic business action. You are successful when you: 

Automate and Optimize: Significantly reduce manual effort in reporting and data aggregation by leveraging AI and advanced automation tools, freeing up time for higher-value analysis. 

Drive Strategic Insights: Transform raw financial and operational data into clear, actionable narratives that directly inform decision-making for leadership. 

Champion Data-Driven Culture: Elevate the organization’s analytical capabilities by building scalable, self-service dashboards and fostering the adoption of AI-powered workflows across the Finance Operations team. 

Deliver Excellence: Consistently produce accurate, timely financial forecasts and operational metrics, effectively managing competing priorities to meet the evolving needs of FP&A and OTC stakeholders. 

Key Responsibilities:

Financial Planning & Analysis (FP&A) 

• 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.

Order-to-Cash (OTC) Analytics & Operations 

• 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.

Data, Reporting & Dashboard Development

• 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.

AI-Powered Automation & Process Improvement

• 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.

Qualifications & Requirements:

Required

• 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.

Preferred

• 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.

MPS is proud to be an equal opportunity employer, consistently striving to foster a culture where everyone belongs. We welcome applicants of all backgrounds and identities. Qualified applicants are evaluated without regard to race, color, religion, age, ethnicity, national origin, sex, sexual orientation, gender identity or expression, disability status, physical ability, neurodiversity, genetic information, protected veteran status, family and economic status, and background or any other characteristic protected by federal, state, or local law. We prohibit discrimination of any kind and will provide reasonable accommodations to qualified individuals with disabilities in accordance with applicable law.

Qualifications Behaviors Required Innovative: Consistently introduces new ideas and demonstrates original thinking Team Player: Works well as a member of a group Detail Oriented: Capable of carrying out a given task with all details necessary to get the task done well Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.