Senior ETL Developer

Tangentia; Toronto; Hybrid; CAD 80,000 - 120,000; Full time

Job summary

A leading technology firm in Canada is looking for a Senior ETL Developer to drive data integration and transformation efforts. The candidate will leverage a variety of Microsoft technologies to support diverse data environments. This position offers a hybrid work arrangement with a compelling focus on ETL development and analytical tasks, supporting the growth of the data analytics team.

Qualifications

• Experience developing ETL programs for various data repositories.
• Experience constructing complex SQL queries.
• Strong communication skills and ability to validate business requirements.

Responsibilities

• Develop and maintain data extraction, transformation, and loading functionalities.
• Create technical documentation such as ETL mappings and architecture diagrams.
• Implement and manage schedule/dependency logic for ETL scripts.

Skills

Data integration

Data cleansing

Data analytics

SQL

ETL processes

Communication

Tools

Azure Data Factory

Azure SQL Database

Azure Data Lake

Power BI

Git

Job description

Role: Senior ETL Developer
Location: Toronto, ON
Duration: 1 year +
Hybrid - Candidate MUST work 3 days onsite and 2 days remote

Job Description

• Experience with the Microsoft suite of technology including: Azure Data Factory, Azure SQL Database, Azure Data Lake, and Power BI
• Experience with developing data extraction, transformation, and load programs (daily and initial load) functionality on a wide range of data repositories (structured and semi-structured files, relational and multi-dimensional data stores)
• Experience with developing, implementing, and maintaining schedule/dependency logic for Extract, Transform, Load (ETL) scripts
• Experience with data integration, data cleansing, and data analytics
• Experience with data modeling and design principles for data marts and data warehouses
• Experience in database management and administration
• Experience in constructing complex SQL queries and performance tuning
• Experience with Git and knowledge of source control strategies
• Experience creating technical documentation including ETL source-to-target mappings, data model diagrams, architecture artifacts, detailed design documents, etc.
• Experience in eliciting, documenting, and validating business requirements
• Experience in the software development lifecycle from development, testing, quality assurance, to delivery
• Solid communication skills: the ability to understand, comprehend, and follow instructions and requirements to communicate clearly and effectively both verbally and in writing.