Data Analyst

Farm Mutual Reinsurance Plan Inc.; Cambridge; Hybrid; CAD 75,000 - 90,000; Full time

Benefits offered by this job

Wellness plan

Professional development

Volunteer day

Competitive benefits

Defined benefit pension

Job summary

Farm Mutual Reinsurance Plan Inc. in Cambridge, Ontario is seeking a Data Analyst to support the Ontario Mutuals Automobile Plan (OMAP) with data analysis, reporting, and data pipeline enhancements.

The role reports to the Manager, Ontario Auto Pricing Actuary and involves collaboration with internal and external partners to improve data-driven pricing and business processes. The position offers a hybrid work environment, with a primary office in Cambridge and a satellite in Toronto.

Qualifications

• Bachelor's degree in data analytics, information systems, computer science, statistics or a related field.
• 1+ year of experience with data analysis, reporting and visualization tools (Power BI, Tableau or similar).
• Strong analytical and problem-solving skills with data quality and integrity.

Responsibilities

• Prepare, integrate, validate, and analyze data from multiple sources to support ratemaking and strategic business initiatives.
• Coordinate testing, validation, and QA for vendor systems and changes; ensure data accuracy and alignment with requirements.
• Develop, automate, and optimize ETL processes, data pipelines, and data models; monitor data quality and performance.
• Deliver recurring and ad hoc reports to support internal and external business needs; maintain dashboards and visualizations for pricing decisions.

Skills

Analytical thinking

Communication

Education

Bachelor's degree in data analytics, information systems, computer science, statistics or related field

Tools

Power BI

Tableau

Job description

Description

We have an excellent opportunity to join Farm Mutual Re, one of Waterloo Region's top employers, as a Data Analyst with the Ontario Mutuals Automobile Plan (OMAP). OMAP provides product, underwriting, actuarial, regulatory, and systems support to 29 Ontario Mutual Insurance Association (OMIA) companies that participate in a common automobile insurance filing with the Financial Services Regulatory Authority of Ontario (FSRA). Collectively, these companies write approximately $400M in annual automobile insurance premium.

The Opportunity

Reporting to the Manager, Ontario Auto Pricing Actuary, the Data Analyst supports OMAP’s ratemaking and business needs through data analysis, reporting, system support, and process improvement. The role works with data and technology to support accurate, efficient, and reliable business processes. The role collaborates with internal and external business partners to support data and system solutions that meet evolving business needs.

This position offers a hybrid work environment, with a primary corporate office in Cambridge and access to a satellite office in Toronto.

As the successful candidate, you will:

• Prepare, integrate, validate, and analyze data from multiple sources to support ratemaking, predictive modeling, and strategic business initiatives.
• Coordinate and perform testing, validation, and quality assurance for vendor systems and related changes, ensuring data accuracy, functionality, and alignment with business requirements.
• Support vendor systems enhancements to meet evolving ratemaking and business needs
• Develop, automate, and optimize ETL processes, data pipelines, and data models; monitor pipeline performance, data quality, and reliability to ensure efficient, consistent, and scalable data flows.
• Support the implementation of innovative data solutions, particularly within modern data environments and evolving ratemaking systems and processes.
• Maintain data dictionaries, technical documentation, testing procedures, system documentation, and process guides to support consistency and knowledge transfer.
• Serve as a resource for data-related and system-process questions, share established practices, and supports continuity of key business processes through documentation, cross-training, and backup support for assigned business analysis responsibilities.
• Prepare and deliver recurring and ad hoc reports to support internal and external business needs.
• Maintain and update dashboards and data visualizations to support pricing and business decisions.

Your Skills and Qualifications

• Bachelors degree in data analytics, information systems, computer science, statistics or a related field
• Minimum 1 year of experience working with data analysis, reporting and visualization tools (i.e. Power BI, Tableau, or similar platforms)
• Strong analytical and problem-solving skills with experience ensuring data quality and integrity.
• Experience analyzing and integrating complex datasets to support business insights and decision-making.
• Excellent collaboration and communication skills with the ability to partner effectively with business stakeholders to develop data-driven solutions.

Compensation

The expected base salary range for this position is $75,000 - $90,000.

The actual salary will be determined based on factors including but not limited to, market conditions, relevant experience, job related knowledge, skills, abilities, qualifications, and education.

Employees may also have the opportunity to participate in incentive programs to earn additional compensation. Incentive compensation is tied to established business and individual performance targets.

What’s in it for you?

• Flexible hybrid work environment, which balances remote and in-office work
• A comprehensive wellness plan, including personalized health coaching, fitness classes, and access to an on-site gym
• Ongoing professional development opportunities, such as paid education, training, certifications, mentorship programs, and personalized career development plans
• Paid volunteer day to give back to your community
• In addition to our competitive salary, employees also receive exceptional employer-paid benefits, a defined benefit pension plan, and more to support their future

Farm Mutual Re is committed to creating an equitable, diverse, and inclusive work environment for all. We provide accommodations that help achieve a barrier-free workplace. If you require an accommodation to participate in the recruitment process, please contact [e-mail].

We may use artificial intelligence to support elements of the recruitment process. While these tools assist our teams, our use of AI does not replace human decision making.