Canadian Chartered Professional Accountant (CPA) designation or equivalent required.
Undergraduate Degree in Finance, Accounting, Economics, or related field.
At least 4 years of progressive experience in FP&A, financial analysis, or a related finance role.
Demonstrated experience in project, program, or contract profitability analysis.
Strong Power Query skills and advanced Excel proficiency.
Hands-on experience with Power BI, including data modeling and dashboard development.
Strong analytical and problem-solving abilities.
Responsibilities
Perform in-depth profitability analysis by project, program, contract, and business unit.
Analyze revenue, service volumes, and cost allocations to explain financial performance.
Develop recommendations with quantified financial impacts and track results with operational leaders.
Support business cases for new programs and operational initiatives.
Build and maintain driver-based financial models linking operational activity to profitability.
Design and maintain Power Query workflows to automate reporting processes.
Partner with stakeholders to validate assumptions and resolve reporting discrepancies.
Benefits
Opportunity to work with advanced AI-driven tools and automation.
Engagement in financial due diligence for potential M&A opportunities.
Collaborative environment with cross-functional teams.
Focus on continuous improvement in finance processes and systems.
Full Job Description
Spectrum Health Care is looking for a CPA-designated Senior FP&A Analyst with strong analytical judgment, advanced Power Query and Power BI skills and a proactive approach to problem-solving.
This successful candidate will provide in-depth analysis of project and program profitability, improve financial reporting through automation, and support budgeting and forecasting. This role requires candidate who can investigate complex financial and operational issues, identify underlying drivers, and translate findings into practical business recommendations.
Job Description
Project and Program Profitability
Perform in-depth profitability analysis by project, program, contract, and business unit, identifying margin trends, cost pressures, and improvement opportunities.
Analyze revenue, service volumes, labour utilization, staffing mix, overtime, travel, medical supplies, and overhead allocations to explain financial performance.
Develop recommendations with quantified financial impacts and track results with operational leaders.
Track key performance indicators (KPIs) and highlight trends impacting business performance
Financial Modelling and Reporting
Support business cases for new programs, investments, and operational initiatives.
Build and maintain driver-based financial models linking operational activity to revenue, costs, and profitability.
Design and maintain Power Query workflows to extract, combine, clean, and transform financial and operational data from multiple sources.
Develop reusable queries, parameters, and functions to automate recurring reporting and reduce manual work.
Build and maintain Power BI data models, DAX measures, and interactive dashboards.
Support the adoption and implementation of AI-driven tools and automation to optimize financial forecasting, data analysis, and reporting efficiency.
Develop reporting that provides clear visibility into project profitability, financial results, and operational performance indicators.
Business Partnering and Continuous Improvement
Partner with clinical operations, accounting, payroll, supply chain, and other stakeholders to validate assumptions and resolve reporting discrepancies.
Present clear, concise analysis and recommendations to finance and operational leaders.
Strengthen reporting controls, data quality, and documentation.
Support ad hoc analysis and improvements to finance processes and systems.
Participate in financial due diligence processes for potential M&A opportunities
Analyze financial statements of target companies and support integration planning and post-merger analysis
Qualifications
Canadian Chartered Professional Accountant (CPA) designation or equivalent required.
Undergraduate Degree in Finance, Accounting, Economics, or related field
At least 4 years of progressive experience in FP&A, financial analysis, or a related finance role.
Demonstrated experience performing in-depth project, program, or contract profitability analysis.
Strong Power Query skills, ability to use MS Office applications, advanced Excel skills, Word and PowerPoint.
Hands-on PowerBI experience, including data modelling, table relationships, and dashboard development.
Strong understanding of financial statements, cost allocation, budgeting, forecasting, and variance analysis.
Strong analytical and problem-solving abilities, with the capacity to investigate root cause, challenge assumptions, and develop actionable recommendations.
Ability to adapt to change and navigate through ambiguous situations
High level of integrity, professionalism, and attention to detail
Excellent oral and written communication skills
Adheres to confidentiality policy for sensitive financial data and information
Knowledge of Python, or SQL is an asset
Additional Information
This position is a current vacancy
We thank all applicants, however, only those individuals selected for interviews will be contacted.
About Spectrum Health
Spectrum Health is a not-for-profit, integrated health system based in West Michigan. Our organization includes a medical center, regional community hospitals, a dedicated children's hospital, a multispecialty medical group and a nationally recognized health plan, Priority Health. We invest in our people, technologies and facilities to create a high-quality, sustainable, service-oriented and cost-effective system of health care.
