Sr. FP&A Analyst

Butcher Power Products•Rancho Cordova, CA

About The Position

The Financial Analytics Manager will own BPP's planning, forecasting, and financial analysis. This role involves building and maintaining the operating budget and rolling forecast, transforming manufacturing and project activity into cost and margin insights, and providing leadership with a forward-looking view of the business. The position acts as a finance and analytics partner to the CFO and reports organizationally to the Director of Data & Analytics within the DATA Department. The role utilizes Dynamics 365 Finance & Operations and enterprise reporting tools, leveraging data to drive business decisions. The individual will own the financial logic, models, and assumptions, pulling source data from the shared reporting platform to ensure consistency across budget, forecast, and actuals.

Requirements

5+ years in financial planning and analysis, financial analytics, corporate finance, or cost accounting.
2+ years owning a budget or forecast process and hands-on financial modeling.
Bachelor’s degree in Finance, Accounting, Economics, Business Administration, or a related field.
Demonstrated ability to build integrated three-statement financial models (Balance Sheet, P&L, and Cash Flow).
Ability to construct rolling forecasts from monthly trial balance data.
Proficiency in cash flow forecasting and liquidity planning.
Experience building driver-based revenue and expense forecasts.
Experience running scenario, sensitivity, and what-if analysis.
Experience modeling capital investment and ROI decisions.
Experience supporting long-range financial planning.
Advanced Excel and financial modeling skills, including three-statement modeling, scenario and sensitivity analysis, dynamic forecasting models, cash flow modeling, multi-driver financial models, Power Query, and pivot-based analysis.
Disciplined model structure, with strong model architecture, documentation, auditability, and version control practices.
Working proficiency in an ERP financial environment.
Ability to translate raw ERP data into financial forecasts and planning models, leveraging D365 and enterprise reporting to drive business decisions.

Nice To Haves

CPA, CMA, or MBA.
Power BI experience.
Comfort working from a governed data model rather than manual extracts.
Working knowledge of SQL or comparable query skills.
Standard costing, Bills of Materials (BOMs), production order variance, inventory valuation, absorption accounting, and percentage-of-completion or job-costed project revenue domain knowledge.

Responsibilities

Own the annual budget process end to end, including calendar and template creation, gathering departmental input, challenging assumptions, consolidating the plan, and presenting to executive leadership. Track and explain actual-to-budget variances.
Maintain a rolling forecast for revenue, cost of goods sold, operating expense, and headcount, updating based on booked orders, backlog, production schedule, and market conditions.
Forecast cash flow and working capital, modeling the impact of inventory, receivables, payables, and project milestones.
Build the capital expenditure plan for equipment, tooling, and facility projects, and evaluate investment requests based on payback, ROI, and financing impact.
Model the financial impact of pricing changes, material cost fluctuations, volume shifts, staffing changes, and new product or market initiatives to support executive decision-making.
Analyze product and manufacturing costs across material, labor, and overhead, including the impact of rate changes and cost rolls on inventory valuation and reported margin.
Analyze production order variances for purchase price, material usage, labor efficiency, and overhead absorption, collaborating with Operations to identify root causes and corrective actions.
Report and explain gross margin by product line, configuration, customer, and channel, identifying areas of profit and loss.
Track estimate-to-actual performance on project-based work, comparing costs against WBS budget and flagging margin erosion.
Analyze inventory levels, turns, obsolescence exposure, and purchase price trends, partnering with Supply Chain on sourcing and stocking decisions.
Produce the monthly management reporting package, including P&L, budget/forecast variance, KPI summaries, and written commentary.
Partner with Accounting during the monthly close for accruals, cost reclassifications, and variance explanations.
Collaborate with Finance on financial planning configuration within Dynamics 365 Finance & Operations, including budget entries, control, allocation rules, and Financial Reporter definitions.
Build and maintain core financial models with a high standard for structure, documentation, version control, and auditability.
Prepare financial packages, covenant calculations, and supporting schedules for lenders, ownership, and the board.
Serve as the finance and analytics partner to Operations, Supply Chain, Sales, Engineering, and Projects, attending meetings and providing financial context to operational decisions.
Work with Sales to translate pipeline, quoting activity, and backlog into a revenue forecast and evaluate margin on significant quotes and contract terms.
Present analysis and recommendations to the CFO and senior leadership in a clear, concise manner.