Data Analyst (DataLab)

Position Summary

The Data Lab team is looking for a detail-oriented and highly analytical Data Analyst with FP&A expertise to support data-driven decision-making across the organization. In this role, you will combine financial planning & analysis capabilities with advanced data analytics to deliver actionable insights to senior leadership and cross-functional business partners. You will play a key role in shaping how the organization leverages data for budgeting, forecasting, performance measurement, and strategic planning within a dynamic insurance and restoration environment. Join us in a fast-paced world where your skills will turn numbers into narratives and make a direct impact on our company’s success.
 (This posting reflects an existing vacancy)

Compensation & Benefits

•  $80,000 – $95,000 /year (Salary based on skills, qualifications, and experience).
• Annual Performance Incentive Bonus – Percentage of base salary subject to personal and company performance.
•  Extended health coverage (medical, dental, vision, etc.) and Employee Assistance Program (EAP).
• Group RRSP, with company matching DPSP.

What You’ll Do

Financial Planning & Analysis

• Budgeting & Forecasting: Support the preparation of annual budgets, quarterly forecasts, and long-range financial plans by consolidating inputs from multiple business units and regional operations.
• Variance Analysis: Analyze monthly financial results against budget/forecast/prior year, identify variances, and prepare management commentary explaining key drivers and discrepancies.
• Financial Modeling: Develop, maintain, and enhance financial models (revenue, cost, profitability, scenario/sensitivity analyses) to support strategic initiatives and investment decisions.
• Management Reporting: Prepare accurate and timely month-end and quarter-end management reporting packages, scorecards, and presentations for senior leadership.

Data Analytics & Insights

• Data Collection & Analysis: Gather, cleanse, organize, and analyze large and complex datasets from multiple sources (ERP, CRM, claims systems, operational databases) to identify trends, patterns, and actionable insights.
• KPI Development & Monitoring: Establish, track, and report on KPIs including regional penetration rates, claims performance, and operational benchmarks to measure business effectiveness.
• Dashboard & Visualization: Design, build, and maintain interactive Power BI dashboards and data visualizations to provide real-time financial and operational insights to stakeholders across all regions (Atlantic, Ontario, Quebec, West).
• Ad Hoc Analysis: Deliver rapid-turnaround, ad hoc analyses and summary documents to support leadership with time-sensitive business questions and strategic projects.

Data Lab & Cross-Functional Collaboration

• Business Partnership: Partner with department leaders, operations, L&D, RVPs, and business units to understand data needs and provide financial and analytical guidance for key business decisions.
• Process Improvement & Automation: Identify opportunities to simplify, automate, and standardize recurring reporting, forecasting, and data workflows to improve accuracy, efficiency, and timeliness across the Data Lab’s portfolio.
• Data Integrity & Governance: Ensure the accuracy, consistency, and integrity of financial and operational data across systems, semantic models, and reports.
• Tool & Platform Support: Contribute to the deployment, maintenance, and troubleshooting of enterprise reporting tools and platforms, including Power BI workspaces and semantic models.

What You Bring

• Bachelor’s degree in Finance, Accounting, Economics, Data Science, Business, Mathematics, Statistics, or a related field.
• 2–5 years of experience in data analytics, FP&A, corporate finance, or a related analytical role.
• Proven experience with financial modeling, budgeting, forecasting, variance analysis, and working with large datasets in a corporate environment.
• High proficiency with pivot tables, VLOOKUP/XLOOKUP, Power Query, complex formulas, and macros.
• Proven proficiency in report development, semantic models, DAX, and workspace management.
• Working knowledge of SQL for data extraction and manipulation.
• Strong problem-solving skills, a systematic and logical approach, and excellent attention to detail.
• Combination of advanced technical and sound presentation skills to communicate insights effectively to cross-functional teams.

Of Note:
We’re proud to support a flexible hybrid approach which gives everyone the best of both worlds. While there are no minimum or maximum time requirements, each team’s need for in-person connections will be different and there will be times you’ll join your colleagues at the office.

Why You’ll Love Working Here

A workplace that values respect, integrity, generosity, excellence, and being customer-driven. We offer opportunities to grow your career and learn from the best in the industry within a culture that celebrates teamwork, inclusion, and customer-driven service.

At On Side, everything starts with people. Join a team that helps families, businesses, and communities rebuild when it matters most. You’ll contribute to a workplace where people come together to bring order to chaos. Make a real impact, do work that matters, and grow your career with us.

Your application is always reviewed by real people. We don’t use artificial intelligence to screen, assess, or select applicants for this role.