Data & Automation Engineer

The Opportunity

Are you looking for a caring collaborative values-driven workplace with inspiring teammates and leaders Do you have the ambition and desire to be the best and thrive at the most impactful global insurance provider in the world Look no further than Zurich Canada.

If you have experience withactuarial and insurance data while using modern tools such as Databricks Microsoft Azure Python SQL Power BI and AI tools and are looking for a new challenge we would love to hear from you.

Zurich Canada is currently looking for a Data and Automation Engineer to join the Actuarial Pricing team. This role will be responsible for creating data solutions that support actuarial analyses enable stronger business insights automate existing data ingestion and transformation processes and build reporting tools that help actuaries and business stakeholders detect trends and proactively monitor portfolio KPIs.

Reporting to the VP and Actuarial Director you will work closely with actuaries business stakeholders data platform teams and analytics partners to extract transform manipulate and curate data for use in pricing portfolio monitoring profitability analysis and management reporting.

The position provides strong hands-on exposure to actuarial and insurance data while using modern tools and a suite of AI tools within Zurichs governance security and risk standards. Reporting to the VP and Actuarial Director you will work closely with actuaries business stakeholders data platform teams and analytics partners to extract transform manipulate and curate data for use in pricing portfolio monitoring profitability analysis and management reporting. The position provides strong hands-on exposure to actuarial and insurance data while using modern tools such as Databricks Microsoft Azure Python SQL and Power BI within Zurichs governance security and risk standards.

This is a unique opportunity to help shape a newly created position within the Actuarial Pricing team and build your knowledge and experience for the future in a supportive environment where your voice matters. This posting is for a new vacancy.

Zurich Canada uses artificial intelligenceenabled tools to support certain aspects of the recruitment process including the initial review and screening of applications. Artificial intelligence is not the sole basis for candidate shortlisting or selection. All hiring decisions are reviewed and made by qualified hiring professionals.

Zurich follows a hybrid work model requiring three days per week of in-person presence which may include time in the office or market-facing engagements.

What you will do

Design build and maintain data pipelines using Databricks Microsoft Azure Python SQL and the latest AI tools to support actuarial pricing portfolio management and business reporting needs.
Automate existing data ingestion extraction transformation and loading processes to improve efficiency reliability and scalability across actuarial workflows.
Create analytics-ready datasets that support pricing analyses trend studies profitability reviews rate monitoring catastrophe load analysis and portfolio KPI reporting.
Build and maintain Power BI dashboards and automated reports that help actuaries underwriters finance partners and business leaders detect emerging trends and proactively manage portfolio performance.
Partner with actuaries and business stakeholders to understand analytical requirements and translate them into practical data solutions reporting tools and repeatable processes.
Streamline processes for extracting transforming reconciling and manipulating data used in actuarial models analyses and insights.
Identify document and track data quality issues including root cause analysis remediation status and opportunities to use AI-assisted techniques to improve issue detection triage and resolution.
Support production processes including monitoring automated jobs troubleshooting failures resolving data issues and implementing sustainable fixes.
Collaborate with data engineering analytics technology and governance teams to align actuarial data solutions with enterprise standards controls privacy requirements and security expectations.
Collaborate with analytics data science and AI teams to enable downstream reporting and Agentic AI / AI-assisted analytics use cases.
Contribute to technical documentation runbooks and knowledge sharing to improve continuity transparency and adoption of actuarial data solutions.

Job Qualifications - What you bring to the table

Required:

Bachelors degree in Computer Science Engineering Information Systems or a related discipline
36 years of experience in data quality data governance analytics or data management roles.
Hands-on experience with Python for data processing automation and workflow improvement.
Strong working knowledge of SQL for querying transforming reconciling and validating large datasets.
Experience with Databricks Delta Lake concepts or similar cloud data platforms used to build scalable data pipelines and analytics-ready datasets.
Familiarity with Microsoft Azure services and modern cloud data architecture concepts.
Experience developing dashboards reports or business intelligence solutions using Power BI or similar visualization tools.
Hands-on experience using AI tools (e.g. Gemini Claude ChatGPT) in data-related projects.
Understanding of data engineering fundamentals including ETL / ELT data modeling schema design data quality controls and performance optimization.
Ability to translate business and analytical requirements into practical data solutions that are reliable reusable and easy to understand.
Strong problem-solving skills with the ability to investigate data issues reconcile results and communicate findings clearly to technical and non-technical stakeholders.
Ability to write clear maintainable code and follow team standards documentation practices and version control processes.
Strong written and oral communication skills to be able to explain complex data engineering concepts to a less technical audience.
A collaborative mindset open cross-team teaching and knowledge sharing.

Preferred:

Experience working with actuarial insurance underwriting claims finance or portfolio management data.
Exposure to pricing profitability rate monitoring loss ratio catastrophe or portfolio KPI reporting processes.
Experience with AI-assisted or automated data quality tools such as automated profiling anomaly detection or rule suggestion.
Experience with Delta Lake Lakehouse architectures CI / CD concepts or automated deployment practices for data pipelines.
Familiarity with data governance privacy controls or regulated data environments such as financial services or insurance.
Interest in applying automation analytics and AI-enabled capabilities to improve actuarial insight generation and business decision-making.

At Zurich Canada we are committed to pay equity. We determine compensation based on objective criteria such as skills experience and internal equity. The salary range for this position is. This range reflects the expected pay for the role across Canada and may vary depending on factors like office location specific responsibilities and individual qualifications. As required by local law Zurich provides in good faith a reasonable compensation range but starting salaries may exceed this range based on a candidates skills and experience.

Our Culture

At Zurich we are proud of our culture. We are passionate about Diversity Inclusion Equity and Belonging (DIEB). We want you to bring your whole self to work and we want our employees to be reflective of the communities in which we live and work. Our DIEB initiatives are creating an environment where everyone feels welcome.

We have a collaborative culture where diversity of thought is valued. We value your input and strive to give our employees the tools they need to make an impact.

We care about our employees well-being and offer a comprehensive health/benefits plan with varying levels of coverage to suit your specific needs and a competitive total compensation package.

We understand how important it is to rest recharge and do the things you love. At Zurich all employees receive a minimum of four weeks of vacation per year to do just that.

We also understand that employees require time off for personal reasons. Maybe you have an appointment during a workday a cultural or religious holiday you would like to observe or you need time off to focus on your mental health. Zurich employees receive four personal days per year to be used at their discretion.

We are committed to continuous improvement and offer access to a comprehensive range of training and development opportunities.

We care about our communities. Our communities are where our customers people and shareholders live and work. While we can be proud of the contribution to society Zurich makes through our core business of insurance we must also give back to our communities through our talent time and resources.

We have won numerous awards for our workplace culture. We are proud to be one of Greater Torontos Top Employers and to have received Insurance Business Canadas 5-Star Diversity Equity and Inclusion Award.

Make a difference. Be challenged. Be inspired. Be supported. Love what you do. Work for us.

About Us

Zurich Canada is part of the Zurich Insurance Group a multi-line insurer with approximately 55000 employees worldwide serving customers in global and local markets. Zurich Canada has been a leading insurance provider serving mid-sized and large companies including multinational corporations in the Canadian commercial market for 100 years. With over 650 employees in offices across the country Zurich offers the global strength of a top insurance provider combined with in-depth knowledge of industries and local markets. Zurich Canada aspires to be risk management professionals first choice as their premier partner to help meet the risk challenges of today and tomorrow. Read more at .

A future with Zurich

Now is the time to move forward and make a difference. At Zurich we want you to share your unique perspectives experiences and ideas so we can grow and drive sustainable change together. As part of a leading global organization Zurich North America has over 148 years of experience managing risk and supporting resilience. We are a leading provider of commercial property-casualty insurance solutions and a wide range of risk management products and services for businesses and individuals. Today we serve more than 25 industries from agriculture to technology and insure 90% of the Fortune 500. Our growth strategy is not limited to our business. As an employer Zurich strives to provide ongoing career development opportunities and foster an environment where voices are diverse behaviors are inclusive actions drive equity and our people feel a sense of belonging. Be a part of the next evolution of the insurance industry. Join us in building a brighter future for our people our customers and the communities we serve.

As a global company Zurich recognizes the diversity of our workforce as an asset. We recruit talented people from a variety of backgrounds with unique perspectives that are truly welcome here. Taken together diversity and inclusion bring us closer to our common goal: exceeding our customers expectations. Zurich is committed to providing a diverse inclusive and barrier-free environment resulting in an accessible organization for employees customers and other parties who interact with or on behalf of Zurich. We strive to achieve a workplace free of discrimination of all forms including discrimination on the basis of physical or mental disability or medical condition. If you are interested in a job opportunity please advise if you require an accommodation so we can work with you to provide a more accessible process.

Zurich does not accept unsolicited resumes from search firms or employment agencies. Any unsolicited resume will become the property of Zurich Canadian Holdings Limited. If you are a preferred vendor please use our Recruiting Agency Portal for resume submission.

Only applicable for Canada: For Zurich Canadas commitment to diversity and accessibility please click here . If you would prefer to not receive future electronic messages from Zurich Insurance Company Ltds recruitment management system please email your request to have your job profile deleted from the system by clicking here . Zurich Insurance Company Ltd 100 King St. W. Suite 5500 Toronto ON M5X 1C9.

Required Experience:

IC