Data 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 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.

What you will do :

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.

Job Qualifications

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.
• High School Diploma or Equivalent and 8 or more years of experience in the Data Engineering area.
• 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.
• 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.

Our Culture

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

Why Zurich

At Zurich, we like to think outside the box and challenge the status quo. We take an optimistic approach by focusing on the positives and constantly asking What can go right?

We are an equal opportunity employer who knows that each employee is unique - that’s what makes our team so great!

Join us as we constantly explore new ways to .

• Location(s) : CA - Toronto - 100 King
• Remote working :
• Schedule : Full Time
• Recruiter name : Ananya Trehan
• Closing date :
30+ days ago