Your happiness and well-being are top priorities at Spectrum! We offer competitive wages, paid sick days, RRSP matching and more!
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.
Our people are the cornerstone of our business. By joining Spectrum Health Care you will be part of one of Canada’s Best Managed companies and a committed member of a team of highly skilled healthcare professionals.
Job DescriptionProject 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
- 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
This position is a current vacancy
Spectrum Health Care is thrilled to be named one of Canada’s Best Managed Companies. This award recognizes top companies across Canada for overall performance, sustained growth, strategy, capabilities and innovation, culture and commitment, and leadership. Click here to learn more about this esteemed honour.
We thank all applicants, however, only those individuals selected for interviews will be contacted.
In accordance with the Accessibility for Ontarians with Disabilities Act 2005, upon request, support will be provided for accommodations throughout the recruitment process.
If you require accommodation because of disability through the recruitment process, please contact Human Resources at ([email protected]) for assistance.
Spectrum Health Care is committed to fostering, cultivating and building a culture of diversity, equity and inclusion within our organization. We strive to attract, engage and develop a workforce that reflects the diverse communities that we serve and we know a diverse workforce is key to the growth and success of our organization.
