Senior ETL Developer

Randstad Digital; Oakville; Hybrid; CAD 90,000 - 110,000; Full time

Benefits offered by this job

Competitive salary and benefits

Dynamic team environment

Recognition as a top workplace

Job summary

A leading insurance firm in Canada is seeking a Senior ETL Developer to join their hybrid team. The role involves building efficient data pipelines and operationalizing high-quality data solutions. Candidates should have extensive experience in data modeling, SQL, and using Azure services, along with a Bachelor's degree in Computer Science or related field. The firm is recognized for its innovative environment and offers competitive salary and benefits.

Qualifications

• 5-7 years of data modeling experience in BI/Analytics, data warehouses, or data marts.
• 3-5 years using data modeling tools like ER/Studio or Erwin.
• 3-5 years of experience with advanced SQL and SQL Server.

Responsibilities

• Build reliable, scalable, and efficient data pipelines.
• Operationalize high-quality data solutions supporting enterprise reporting.
• Design and implement data models that support Power BI.

Skills

Data modeling in BI/Analytics

Advanced SQL

Relational and dimensional modeling

Metadata management

Education

Bachelor’s degree in Computer Science

Tools

Azure SQL Database

Power BI

Azure Data Factory Databricks

Job description

Overview

Our client, an innovative industry leader in the insurance domain, is looking for a Senior ETL Developer - Hybrid to join their growing team. The successful candidate will have extensive experience building reliable, scalable, and efficient data pipelines to operationalize high-quality data solutions that support enterprise reporting, analytics, and decision-making. This is a full-time permanent role, hybrid with 3 days per week in office (Oakville). Candidates must be based in and legally eligible to work for any employer in Canada. 2 managerial references required; criminal, credit, education, and employment backchecks required.

Application Instructions

To apply, send your current CV directly to [e-mail].

Please note: Due to high application volumes, only candidates who meet the outlined requirements will be contacted for further discussion.

Advantages

Work on a dynamic team with cutting-edge technology on innovative products in the insurance domain. Our client offers a competitive salary and benefits package. The Great Place to Work Institute has named our client one of Canada’s Top 50 Best Workplaces, Best Workplaces in Canada for Financial Services & Insurance, Best Workplaces in Canada for Women, Best Workplaces in Canada for Inclusion and Best Workplaces in Canada for Mental Wellness. They are also recognized as one of Achievers\' 50 Most Engaged Workplaces in North America.

Responsibilities

The Senior ETL Developer - Hybrid will have extensive experience building reliable, scalable, and efficient data pipelines to operationalize high-quality data solutions that support enterprise reporting, analytics, and decision-making.

Qualifications

Must-have Qualifications

• Data modeling in BI/Analytics, data warehouses, or data marts - 5-7Y+
• Data modeling tools such as ER/Studio, Erwin, or equivalent - 3-5Y+
• Relational and dimensional modeling (star/snowflake schemas) - 3-5Y+
• Advanced SQL, SQL Server and related MS stack components - 3-5Y+
• Designing and implementing data models that support Power BI - 3-5Y+
• Synapse, Azure Data Factory Databricks, or SSIS - 3-5Y+
• Azure cloud data services like Azure SQL Database, Azure Synapse Analytics, Azure Data Lake Storage (ADLS), and Delta Lake - 2-4Y+
• Metadata management, data lineage, and data governance frameworks - 3-5Y+
• Bachelor’s degree in Computer Science, Information Systems, Data Science, or related field - 3-4Y+