Job Title

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 Ontarios Top Employers 2025, Waterloo Areas Top Employers 2025 and Canadas 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 OpportunityReporting 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 organizations 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 analyticsExtract, clean, transform, validate, and integrate data from multiple sources, including APIs, cloud platforms, and internal systems across different lines of businessCreate 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 TableauPerform SQL query optimization to improve performance, reduce latency, and enable faster reportingEnsure data accuracy and consistency by implementing automated testing, monitoring, and validation routinesSupport and maintain the current business data infrastructure while contributing to the transformation and scalability of new data architecture initiativesMaintain clear documentation of data processes, pipelines, and business logic to support knowledge sharing and ongoing team developmentYour Skills and QualificationsYou have a bachelors degree in Computer Science, Software Engineering, Math or a related fieldYou have a minimum of 5 years of experience in Analytics with a strong foundation in data modelling & SQLYou 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, JavaYou have experience with data visualization tools such as Qlik, Tableau and/or Power BIYou have experience with DevOps concepts and tools, such as building CI/CD pipelines along with an understanding of SDLC and Agile FrameworksYou have strong business partnering skills working with different teams and stakeholdersYou have excellent analytical skills, assessing factors and developing innovative and practical solutions to achieve department goalsWhats in it for you?Flexible hybrid work environment, which balances remote and in-office workA comprehensive wellness plan, including personalized health coaching, fitness classes, and access to an on-site gymOngoing professional development opportunities, such as paid education, training, certifications, mentorship programs, and personalized career development plansPaid volunteer day to give back to your communityIn addition to our competitive salary, employees also receive exceptional employer-paid benefits, a defined benefit pension plan, and more to support their futureHow to ApplyVisit 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 recruitment@farmmutualre.com.