Data Analyst

Location:

Anywhere On Side has a branch

Employment Type:

Full-Time / Permanent
Posting Date:  June 12,

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, – $95, /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 work spaces 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…