Location

Toronto, Canada

Job type

Full-Time

Work mode

Hybrid

Job level

Professional

Job ID

10597

Company

Munich Re, Canada (Life)

Employment type

Regular

Area of expertise

Information Technology

Position Overview

As a Senior SQL ETL Developer, you will be responsible for building and maintaining robust data integration and transformation solutions that support financial and regulatory reporting, including IFRS17. You will work with complex datasets across multiple platforms (e.g., SQL Server, Oracle, Databricks), ensuring high data quality, performance, and reliability. This role combines strong technical expertise with collaboration across business and IT teams to deliver accurate, compliant, and scalable reporting solutions in a regulated environment.

Your Role:

• Develop and maintain ETL processes using SSIS to ingest, transform, and load data from sources like Oracle Financials, P34, Convert, AXIS, and VAL into Azure SQL Server databases (Landing, Staging, Final, and Delivery zones).
• Design and optimize SQL stored procedures, functions, views, and tables for data aggregation, tagging (e.g., GOCs, Transaction Types), and validation in a multi-zone data warehouse architecture.
• Implement and troubleshoot scheduled ETL workflows using Control-M, ensuring seamless data flow to the Munich IO Hub and handling on-demand processes via Appian UI.
• Collaborate on data modeling, SCD Type 2 changes, hash-based change detection, and aggregation for IFRS17 financial reporting compliance.
• Build and optimize pipelines on Databricks for large-scale financial and actuarial data processing, integrating with Azure SQL Server and Oracle systems to support IFRS17 reporting.
• Support incident resolution, monitoring (via Dynatrace), and deployment across Dev, QA, UAT, and Prod environments, including version control with TFS and integration testing.
• Enhance reporting interfaces using Power BI and Appian for business users, including aggregation approvals and status monitoring.
• Manage security and access via Active Directory groups, linked servers, and IAM provisioning.

Your Profile:

• University degree preferably in Computer engineering / IT or similar qualification
• 3+ of experience of delivering results in a fast paced, global and regulated business environment, preferably in application release management, change management or project management
• Background in financial/actuarial data processing (e.g., IFRS17 standards) and regulatory compliance, with proven hands-on IFRS17 reporting implementation experience.
• Proficiency in T-SQL, SQL Server (including stored procedures, functions, and performance tuning) and Azure SQL Server for data warehousing.
• Strong experience with SSIS for ETL development, including package execution, error handling, and integration with linked servers.
• Hands-on experience with Databricks (PySpark/SQL) for advanced data transformations and large-scale processing.
• Strong understanding of Oracle databases, including querying, performance optimization, and integration with ETL workflows.
• Knowledge of data warehouse concepts (e.g., SCD Type 2, hashing for change detection, RI checks, and aggregation by GOC).
• Familiarity with scheduling tools like Control-M and monitoring tools like Dynatrace for job execution and alerts.
• Experience with Appian for UI development (e.g., job triggering, approvals) and Power BI for reporting and dashboards.
• Understanding of version control (TFS/Azure DevOps) and deployment pipelines; basic C# for SSIS scripting tasks.
• Working knowledge of Active Directory, IAM for user provisioning, and ServiceNow for incident management.

About Munich Re

Together, we engage with everything we have and are, to help humankind act braver and better.

As the world’s leading reinsurance company with more than 40,000 employees in over 50 locations around the globe, Munich Re introduces a paradigm shift in the way you think about insurance. By turning uncertainty into manageable risk, we enable fundamental change. We recognize Diversity, Inclusion, and Belonging as a key priority with a culture that welcomes different thoughts and opinions. We dare to think big and are continuously innovating on behalf of our clients.

Our data, our technology, and our teams place us in a unique position to drive transformative change in the life insurance industry. We invest strategically in our world class talent, offering our employees a work experience that promotes professional development, innovation, and rewards high performance.

What Can We Offer You?

We are pleased to offer our employees great benefits and resources to support their mental, physical and financial wellbeing. These include:

• An engaging and collaborative environment that promotes continuous learning and development
• A hybrid work environment that combines weekly in-office and remote days with Meeting-Free lunch hours and Focus Friday afternoons
• A great compensation package including annual company bonus
• Market leading company-paid flexible health and dental benefits, starting on your first day
• Flexible dollars provided by the company to put towards Health Spending Account and/or Wellness Spending Account
• Immediate participation in DC Pension Plan with an automatic 5% employer contribution, plus optional company match
• Generous time off including vacation, personal days, unplanned time, Statutory Holidays and company-wide early closure half-days
• Learning and development programs and resources, including unlimited access to LinkedIn Learning, Education Assistance Program and reimbursement for professional fees
• Maternity, Parental & Adoption Leave top-up program
• Employee Referral Program, Recognition & Rewards Platform

Please note that only candidates who are selected for interview will be contacted directly. We thank all candidates for their interest.

Successful candidates must be prepared to relocate to the specified job location in the job posting and will be employed directly under the hiring entity's contractual terms.

Munich Re is committed to providing a work environment that is inclusive and free of employment barriers and discrimination. Accommodations will be made for qualified applicants with a disability throughout the recruitment process. If you receive a request for an interview and you have a disability which will require an accommodation to support your participation, please contact AODARequestHR@munichre.ca as soon as practical so that suitable accommodations can be arranged.