Job Opportunity: Data Engineer at Zurich Canada

Are you searching for a nurturing, collaborative, values-driven workplace with inspiring colleagues and leaders? Do you aspire to excel and thrive at one of the most impactful global insurance providers? Look no further than Zurich Canada.

About the Role

If you possess experience as a Data Engineer and seek a new challenge, we want to hear from you.

Zurich Canada is currently hiring a Data Engineer to join our IT Data team. This team is responsible for maximizing the value of data assets across the organization. You'll help develop and implement the desired end-state data environment within our Azure Databricks setup, leveraging cutting-edge tools and technologies while refining standards and methodologies. The ideal candidate should have extensive experience with large datasets from the insurance industry and a solid understanding of building programs/mappings with Azure, Databricks, and Data Warehouses. Knowledge in ETL and Power BI Dashboards within the insurance context is preferred.

This is a unique opportunity to build your knowledge and experience in a supportive environment where your voice is valued. This is a hybrid work opportunity.

Key Responsibilities

• Architect, design, and build data engineering solutions using Databricks and other Data Integration technologies. Experience with Databricks on the Azure stack is preferred, but AWS experience is acceptable.
• Advantageous: Prior work and experience with P&C insurance data sets.
• Create design artifacts representing the full Data Engineering Lifecycle.
• Advocate and enforce architecture standards like technical design patterns, reusable code examples, and physical design best practices.
• Support knowledge transfer of Data skills within the enterprise and provide consultation on complex Data projects.
• Design integration solutions aligned with the enterprise’s broader data integration strategy.
• Identify and design transformations to maximize data consistency and usability, using profiling, cleansing, and conforming techniques.
• Provide coaching and mentorship to junior team members.
• Review data sourcing requests and assess feasibility.
• Develop data integration solutions aligned with enterprise principles.
• Perform initial data analysis and provide guidance to the business.
• Leverage reusable integration applications for projects using enterprise process and approach.
• Enable data exchange between applications and source systems, and gather necessary data to meet end-user requirements.
• Support the development and implementation of enterprise ETL standards and specifications.

Job Qualifications

Required:

• Bachelor's Degree in Computer Science or Mathematics/Statistics and 6+ years of experience in Data Engineering OR
• High School Diploma or Equivalent and 8+ years of experience in Data Engineering OR
• Zurich Certified Insurance Apprentice with Associate Degree in Computer Science or Mathematics/Statistics and 6+ years of experience in Data Engineering
• 5+ years of experience in Enterprise Data Engineering
• Experience in scripting languages, data transformation, and aggregation tools
• Experience in data analysis, data interrogation, or data profiling.

Preferred:

• Experience using Cloud platforms/technologies
• Proficiency in scripting languages such as Shell, Perl, Python, R, Java
• Experience with Big Data tools, including Spark and Kafka
• Experience with ETL technologies, strong SQL, and stored procedure skills
• Experience with Azure DevOps and Apache Airflow
• Insurance Industry experience
• Databricks Certified Data Engineer Associates or Databricks Certified Data Engineer Professionals

Our Culture

At Zurich, we are proud of our culture. We are passionate about Diversity, Inclusion, Equity, and Belonging (DEIB). We encourage employees to bring their whole selves to work, reflecting the communities in which we live and work. Our DEIB initiatives foster an environment where everyone feels welcome.

Our collaborative culture values diverse thoughts and ideas. We strive to provide our employees with the tools they need to make an impact. Recognizing the importance of well-being, we offer a comprehensive health/benefits plan to suit your specific needs and a competitive total compensation package.

Understanding the need for rest and personal time, Zurich provides a minimum of