Data Engineer

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 as a Data Engineer and are looking for a new challenge, we would love to hear from you.

Zurich Canada is currently looking for a Data Engineer who will be a part of the IT Data team that will be responsible for leveraging the value of the data assets throughout the organization. The team will facilitate the development/implementation of the desired end-state data environment within our Azure Databricks environment leveraging emerging tools and technologies, while evolving and refining standards and methodologies. The Data Engineer should have extensive experience working with very large data sets from the insurance industry and knowledge of building programs/mappings that leverage the Azure and Databricks platforms and Data warehouses. This role will also have significant knowledge of Data technologies and tools with the ability to share ideas among a collaborative team. Prior experience with ETL, Power BI Dashboards within the insurance industry context would be preferred.

This is a unique opportunity to build your knowledge and experience for the future in a supportive environment where your voice matters.

This is a hybrid work opportunity.

• Architect, design and build data engineering solutions using Databricks as well as other Data Integration technologies. Preference will be given to candidates who have experience in Databricks on the Azure stack, but AWS experience is also acceptable.

• Prior work in the P&C Insurance industry and experience with insurance data sets will be an advantage.

• Produce appropriate design artifacts representing full Data Engineering Lifecycle.

• Advocate and enforce adoption of architecture standards such as technical design patterns, reusable code examples, and physical design best practices.

• Assists with the transfer of knowledge of Data skills in the enterprise. Provide data engineering consultation on complex Data projects.

• Design integration solutions that fit within the enterprise's larger data integration strategy or initiative, including recommending data integration tools.

• Identify and design any transformations or conversions required to maximize data consistency and usability. Utilize data profiling, cleansing, and conforming techniques to design procedures / packages.

• Provide coaching and mentorship to junior members of the team.

• Review requirements for data sourcing requests and understand feasibility.

• Develop data integration solutions in alignment with enterprise data integration principles.

• Gain access to the data sources and perform initial analysis to identify sourcing strategies and act as technical expert to provide guidance to the business.

• Utilize enterprise process and approach to leverage reusable integration applications for projects and to support the development of standard integration specification template(s).

• Develop process to enable exchange of data between applications and source systems. Gather and understand the data necessary to satisfy the end-user business requirements.

• Support the development and implementation of enterprise ETL standards and the design and development of ETL specifications and mappings.

What you bring to the table:

Required:

• Bachelors Degree in Computer Science or Mathematics/Statistics and 6 or more years of experience in the Data Engineering area.

OR

• High School Diploma or Equivalent and 8 or more years of experience in the Data Engineering area.

OR

• Zurich Certified Insurance Apprentice including an Associate Degree in Computer Science or Mathematics/Statistics and 6 or more years of experience in the Data Engineering area.

AND

• 5 or more of experience in Enterprise Data Engineering.

• Experience in scripting languages.

• Experience with data transformation and aggregation tools.

• Experience in data analysis, data interrogation or data profiling.

Preferred:

• Experience using Cloud platforms/technologies.

• Experience in scripting languages including Shell, Perl, Python, R, Java.

• Experience Big Data tools including using Spark and Kafka.

• Experience with ETL technologies; strong SQL and stored procedure skills.

• Experience with Azure Dev/ops and Apache Airflow.

• Insurance Industry Experience

• Strong preference will be given to Databricks Certified Data Engineer Associates or Databricks Certified Data Engineer Professionals candidates.

At Zurich, we are proud of our culture. We are passionate about Diversity, Inclusion, Equity and Belonging (DEIB). 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 Us

Zurich 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 500 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 Canada's commitment to diversity and accessibility please click 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 clicking here. Zurich Insurance Company Ltd 100 King St., W., Suite 5500, Toronto, ON, M5X 1C9.