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 Zurich's 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 Zurich's 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 intelligence-enabled 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
• 3-6 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 70,000 - 105,000. 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 candidate's skills and experience.
Make a difference. Be challenged. Be inspired. Be supported. Love what you do. Work for us.
