Data Engineer

Odyssey Reinsurance Company (OdysseyRe) is the global reinsurance arm of Odyssey Group, one of the world’s leading providers of reinsurance and specialty insurance. OdysseyRe offers a broad range of property, casualty, and specialty reinsurance products, providing capital and risk management solutions for clients to efficiently manage economic risk, through a network of branch and representative offices across North America, Latin America, EMEA (Europe, Middle East & Africa), AsiaPacific and London.

OdysseyRe is an equal opportunity employer with excellent benefits and a strong commitment to providing training and opportunities for our staff. We provide employees an innovative, enriching environment and take great pride in their career growth.

OdysseyRe is rated A+ (Superior) by AM Best and A+ (Strong) by Standard and Poor’s. Odyssey Group is a subsidiary of Fairfax Financial Holdings Limited, which is traded on the Toronto Stock Exchange under the symbol FFH.

As a Data Engineer, the role involves several critical aspects related to designing, building, and maintaining data on the Microsoft Azure platform:

1. Technical Subject Matter Expertise:
   • Integration, transformation, and consolidation of data from various sources.
   • Creation of suitable schemas for building analytics solutions.
2. Data Exploration and Understanding:
   • Stakeholders gain insights into data through exploration.
   • Building and maintaining secure, compliant data processing pipelines is a crucial part of the role.
   • Utilization of different tools and techniques to achieve this.
3. Azure Services and Frameworks:
   • Collaboration with various Azure data services and frameworks to store and produce cleansed, enhanced datasets for analysis.
   • Key services include:
     • Azure Data Factory
     • Azure Synapse Analytics
     • Azure Data Lake Storage
4. Data Architecture Patterns:
   • Designing data stores with different architecture patterns based on business requirements:
     • Modern data warehouse (MDW)
     • Big data Lakehouse architecture
5. Operationalization and Optimization:
   • Ensuring that data pipelines and data stores are high-performing, efficient, organized, and reliable.
   • Identifying and troubleshooting operational and data quality issues.
   • Designing, implementing, monitoring, and optimizing data platforms to meet data pipeline requirements.
6. Knowledge of the Insurance/Reinsurance Business:
   • Knowledge or training in any Insurance or Reinsurance business
7. Data Processing Languages:
   • Proficiency in data processing languages such as:
     • SQL
     • Python
     • Spark
8. Certification:
   • Microsoft Certified: Azure Data Engineer Associate or Azure Solution Expert certification is a plus.

We are an E-Verify employer - all hired positions require successfully passing an E-Verify Check.  

Navigate the links below to learn more about careers at OdysseyRe.

Workplace Initiatives

Career Areas for Professionals

A Rewarding Workplace

Follow us on LinkedIn for company highlights