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. 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. 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. 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 creative 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. Maintain and update dashboards and data visualizations to support pricing and business decisions. 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. Excellent collaboration and communication skills with the ability to partner effectively with business stakeholders to develop data-driven solutions. Incentive compensation is tied to established business and individual performance targets. 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 in office 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 We provide accommodations that help achieve a barrier-free workplace. 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. #

📌 Data Analyst (Cambridge)
🏢 Farm Mutual Reinsurance Plan
📍 Cambridge