Analytics Engineer

Farm Mutual Re; Cambridge; On-site; CAD 75,000 - 105,000; Full time

Job summary

A leading reinsurance company is seeking an Analytics Engineer in Cambridge to design and maintain data pipelines, ensuring data integrity and facilitating analytics. Candidates should have a background in data modeling, SQL, and experience in a cloud environment like Azure. This role offers a flexible hybrid work environment along with competitive benefits including professional development opportunities.

Benefits

Flexible hybrid work environment

Comprehensive wellness plan

Ongoing professional development opportunities

Paid volunteer day

Competitive salary and employer-paid benefits

Qualifications

• Minimum 5 years experience in Analytics.
• Strong foundation in data modeling & SQL.
• Experience with scripting languages like Python, Spark, Scala.

Responsibilities

• Build and monitor scalable data pipelines.
• Create and manage a centralized data warehouse.
• Optimize SQL queries for performance.

Skills

Data Modeling

SQL

Python

Azure

Data Visualization

Analytical Skills

Education

Bachelor's degree in Computer Science, Software Engineering, or related field

Tools

Power BI

Tableau

Snowflake

Databricks

SQL

Job description

Direct message the job poster from Farm Mutual Re

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 Southwestern Ontario’s Top Employers 2025, Waterloo Area’s Top Employers 2025 and Canada’s Greenest Employer 2024, 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 Analytics Engineer is an integral part of the Data and Reporting Team, responsible for building and maintaining data pipelines, supporting data modeling, and ensuring data integrity and validation. This work includes data profiling, extraction, cleansing, and transformation to support internal teams and external members.

This role supports the existing data infrastructure while contributing to the organization’s future data transformation efforts. The Analytics Engineer will help plan, create, and monitor scalable data pipelines focused on data acquisition, ingestion, cleansing, transformation, validation, and modeling to support multiple business areas. In addition, the role involves creating and managing a centralized data warehouse to serve as a single source of truth for reporting and analytics. The Analytics Engineer will also be responsible for optimizing SQL queries and data models to improve reporting and work closely with cross-functional teams to ensure data needs are met efficiently.

As the successful candidate, you will :

• Design, build, and monitor scalable data pipelines that support business intelligence and advanced analytics
• Extract, clean, transform, validate, and integrate data from multiple sources, including APIs, cloud platforms, and internal systems across different lines of business
• Create and manage a centralized data warehouse. This includes designing and implementing data models that support self-service analytics in tools such as Power BI or Tableau
• Perform SQL query optimization to improve performance, reduce latency, and enable faster reporting
• Ensure data accuracy and consistency by implementing automated testing, monitoring, and validation routines
• Support and maintain the current business data infrastructure while contributing to the transformation and scalability of new data architecture initiatives
• Maintain clear documentation of data processes, pipelines, and business logic to support knowledge sharing and ongoing team development

Your Skills and Qualifications

• You have a bachelor’s degree in Computer Science, Software Engineering, Math or a related field
• You have a minimum of 5 years of experience in Analytics with a strong foundation in data modelling & SQL
• You have Azure experience along with technologies such as Redshift, S2, Synapse, Fabric, Databricks, Snowflake, Hadoop etc.
• You have experience with scripting and data manipulation languages such as SQL, Python, Spark, Scala, R, Java
• You have experience with data visualization tools such as Qlik, Tableau and / or Power BI
• You have experience with DevOps concepts and tools, such as building CI / CD pipelines along with an understanding of SDLC and Agile Frameworks
• You have strong business partnering skills working with different teams and stakeholders
• You have excellent analytical skills, assessing factors and developing innovative and practical solutions to achieve department goals

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

Visit our website and complete our Employment Application found on our Careers page.

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 [emailprotected] .

Seniority level

Seniority level

Mid-Senior level

Employment type

Employment type

Full-time

Job function

Job function

Engineering and Information Technology

Insurance

Referrals increase your chances of interviewing at Farm Mutual Re by 2x

Get notified about new Data Engineer jobs in Cambridge, Ontario, Canada .

Python and Kubernetes Software Engineer - Data, AI / ML & Analytics

Software Engineer I (Consumer Servicing)

Software Engineer I (Consumer Servicing)

Milton, Ontario, Canada $65.00-$85.00 1 month ago

Graduate Software Engineer, Open Source and Linux, Canonical Ubuntu

Python and Kubernetes Software Engineer - Data, Workflows, AI / ML & Analytics

Software Developer Engineer in Test (SDET) – Core Protection Technology

Senior Data Scientist / Machine Learning Engineer - Search & Recommendation

Software Engineer – C++ - Realtime Technology - Kitchener, Ontario

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

J-18808-Ljbffr

Create a job alert for this search

Engineer • Cambridge, Region of Waterloo, Canada