Data Analyst

Farm Mutual Re is a mutual reinsurer that offers tailored reinsurance solutions for varied insurance lines and helps mutual insurers keep their promises by providing financial stability and insurance capacity. Recognized as Waterloo Area’s Top Employers 2026, Southwestern Ontario’s Top Employers 2026, and Canada’s Greenest Employer 2026, we remain committed to making a meaningful impact on our members, customers, employees, and business partners. Our values of care, trust, courage, and sustainability foster a sense of belonging and guide our decisions and actions. The Opportunity Reporting to the AVP, Data & Reporting, the Data Analyst is responsible for maintaining current dashboards and assisting the development of new dashboards, charts, and visual aids to analyze data and enable decision making. This includes data profiling and analysis, data cleansing and quality review, and the development of ETL packages for Data transformation, where required. This position offers a hybrid work environment, with a primary corporate office in Cambridge and access to a satellite office in Toronto. The Role As the successful candidate, you will: * Maintain and enhance existing dashboards, charts, and visualizations to support operational and strategic decision making * Assist in preparing and delivering recurring reports (monthly, quarterly, semi‑annual, and annual) for internal and external business partners * Analyze data to answer business questions and identify insights that support understanding of performance drivers * Support the design, development, and monitoring of data pipelines, transformations, and data models, including ETL packages for data integration * Contribute to data quality activities, including data profiling, cleansing, validation, and ongoing quality reviews * Develop and maintain documentation and templates such as data dictionaries, data catalogues, and report documentation * Support data literacy initiatives by working with team members and business users to improve understanding and use of data and reporting tools Your Skills and Qualifications * Bachelor’s degree in data analytics, information systems, computer science, statistics, or a related field—or equivalent practical experience * 1+ years experience working with data analysis, reporting, and visualization tools (e.g., Power BI, Tableau, or similar platforms) * Foundational knowledge of data modelling concepts, data transformations, and ETL processes * Experience analyzing datasets to identify trends, issues, and insights relevant to business performance * Strong attention to data quality, documentation, and adherence to data development standards * Ability to clearly communicate data findings and insights to technical and non‑technical audiences This posting represents a current, existing vacancy within our organization. Salary Range 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 How to Apply Select Apply now to submit your application. 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 [email protected]. 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.

The Data Analyst is responsible for maintaining and developing dashboards and visual aids to support strategic decision-making. This includes managing data pipelines, performing ETL transformations, and ensuring data quality through profiling and cleansing.

Candidates should hold a Bachelor's degree in a quantitative field and have at least one year of experience with visualization tools like Power BI or Tableau. Foundational knowledge of data modeling and the ability to communicate insights to diverse audiences are required.

• Flexible Hybrid Work Environment • Comprehensive Wellness Plan • Personalized Health Coaching • Fitness Classes • On-site Gym • Paid Education • Training • Certifications • Mentorship Programs • Personalized Career Development Plans • Paid Volunteer Day • Employer-paid Benefits • Defined Benefit Pension Plan

• Data analysisPreferred

Identified from the job description. Confirm important requirements above.

• Data Analysis
• Reporting
• Data Visualization
• Power BI
• Tableau
• Data Modelling
• ETL Processes
• Data Profiling
• Data Cleansing
• Data Validation
• Data Documentation
• Communication

• Data & Analytics
• Finance & Accounting
• Technology

Minimum education

Bachelor’s degree

Minimum experience

1+ years

Posting language

English

Working hours

40 hours per week