Data & Automation Engineer

The OpportunityAre 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 with actuarial 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 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 tableRequired:• 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.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 Toronto’s Top Employers and to have received Insurance Business Canada’s 5-Star Diversity, Equity and Inclusion Award. Make a difference. Be challenged. Be inspired. Be supported. Love what you do. Work for us.  About UsZurich Canada is part of the Zurich Insurance Group, a multi-line insurer with approximately 55,000 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 ZurichNow 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 Canada's commitment to diversity and accessibility pleaseclick here.If you would prefer to not receive future electronic messages from Zurich Insurance Company Ltd's recruitment management system, please email your request to have your job profile deleted from the system by clickinghere. Zurich Insurance Company Ltd 100 King St., W., Suite 5500, Toronto, ON, M5X 1C9.