Senior FP&A Analyst

Summary:

We are building a dedicated Financial Planning & Analysis (FP&A) function as we scale toward our $250M Core Target. This is a hands-on seat: we are looking for a builder who wants to be in the data, not someone who wants to delegate the work.

Reporting to the CFO, the Senior FP&A Analyst builds our budget and rolling forecast models, margin and job cost reporting, and the tools behind them, working side by side with Operations, Estimating, Purchasing, and Sales and performs detailed cost analysis. We expect this person to use AI tools to build models and do analysis faster and to make recommendations.

We are hiring a strong, experienced senior analyst who is ready to grow into an FP&A Manager role within 1-2 years as the function builds out.

Primary Responsibilities:* Build and maintain the annual budget and rolling forecast models (revenue, gross margin, operating expenses, headcount, and BS/CF impacts), with comparisons to actual costs, sitting with each department leader/manager to develop the drivers and analyze variances.

• Spend regular time with Operations on the floor and in Epicor to understand how jobs are quoted, built, and costed, then turn that into analysis and tools people use.
• Build reports, models, and dashboards from raw ERP data (Epicor, Spreadsheet Server, Excel, Power BI) rather than relying on others to prepare the data.
• Use AI tools (Claude, ChatGPT, Copilot, or similar) to develop models, analysis, and reporting automation, and check AI output against source data.
• Deliver the monthly consolidated reporting package to the CEO and CFO within an agreed number of business days after the Controller's close.
• Dig into gross margin and profitability by product line, facility, and job; work job cost variances line by line with Operations and Estimating until the cause is found and fixed.
• Work hands-on with the Controller’s team and Operations to build labor and overhead rates and average costs that feed quoting, inventory valuation, and margin reporting.
• Build cost-reduction, capital-investment, pricing, and capacity analyses (payback, ROI, NPV, sensitivities) together with the department leaders who will own them, and track realized results.
• Perform detailed cost analysis on expenses with significant variances from budget and/or forecast.
• Performs sales analysis, in coordination with the CRO. This could include analyzing bookings, change orders and cancellations, sales performance by rep, customer and market to support decisions.

Competencies:

• Analytical rigor: builds accurate, driver-based models and reaches clear conclusions from incomplete data.
• Business partnering: translates financial results into plain-language recommendations for non-finance leaders.
• Hands-on builder: does the analysis and works in the details of ERP data and job costs rather than handing work off.
• Ownership and integrity: owns the numbers, flags errors early, and closes the loop (TRIBE: Right Thing, Experience).
• Urgency and organization: manages competing deadlines across budget, forecast, and month-end cycles (TRIBE: Be Passionate).
• Continuous improvement: looks for ways to make reporting faster and more accurate, 1% better every day (TRIBE: Improve).
• AI-enabled analysis: uses AI tools to build faster and verify the output before it reaches a decision maker.
• Team player: goes to Operations, Estimating, and Sales to learn how the work is done, and builds tools with them (TRIBE: Team Player).

Required Qualifications:

• Bachelor's degree in Finance, Accounting, Economics, or a related field.
• Proven track record of personally building models, reports, and tools from raw data, working directly with operations or other departments on tools they use day to day.
• 5+ years of progressive FP&A or corporate finance experience, still doing hands-on modeling.
• Ready to take on more scope and grow into an FP&A Manager role within 1-2 years.
• Experience in manufacturing, custom fabrication, or another job/project-based environment.
• Hands-on budget and forecast model building; job costing, and gross margin analysis; advanced Excel and ERP reporting (Epicor and Spreadsheet Server preferred).
• Hands-on experience using AI tools (Claude, ChatGPT, Copilot, or similar) to build models, write formulas or scripts, or analyze data, with examples to share.
• Preferred: CPA, CMA, or MBA; Power BI or similar BI tool experience; experience building AI-assisted workflows or automation (e.g., Power Query, Python, AI agents); .
• Strong business acumen
• Strong accounting and cost accounting knowledge
• Strong ERP knowledge
• Understanding of cost drivers
• Solution/Recommendation driven

Special Position Requirements:

• Extended hours as needed during the annual budget cycle, quarter-end, and month-end reporting.
• Occasional travel to other TSS facilities and customer job sites.
• Successful completion of pre-employment screening per TSS policy.

Physical Requirements:

• Prolonged periods of sitting and working at a computer.
• Regular walking on the manufacturing floor to work with Operations and observe production and inventory processes.
• Ability to lift up to 15 pounds occasionally.

Work Environment:

• On-site, full-time office position at our Fowlerville, MI facility.
• Office setting within an active manufacturing facility; plant floor visits involve moderate noise and require standard PPE.

Total Security Solutions is an Equal Opportunity Employer with leadership and a culture that supports diversity and inclusion.

The above statements are intended to describe the general nature and level of work being performed by individuals assigned to this position. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required. All employees may be required to perform duties outside of their normal responsibilities from time to time, as needed.

Nothing in this job description restricts management’s right to assign or reassign duties and responsibilities to this job at any time. This job description is subject to change at any time.