ETL Software Developer

emergiTEL Inc.; Toronto; On-site; CAD 90,000 - 120,000; Full time

Job summary

A technology services company is seeking a Senior ETL Software Developer to design and maintain scalable data pipelines and analytics solutions. The role focuses on ETL development, data integration, and performance optimization. Candidates must have strong experience with Microsoft Azure data technologies, AWS data services, and data modeling principles. This position requires developing ETL workflows, performing data transformations, and collaborating with stakeholders to ensure high-quality solutions.

Qualifications

• Strong experience in Microsoft Azure data technologies.
• Hands-on experience with the Databricks platform.
• Experience with AWS data services such as Amazon Aurora and AWS Glue.

Responsibilities

• Design, develop, and maintain ETL pipelines for data sources.
• Perform data extraction, transformation, and loading.
• Build and maintain scheduling logic for ETL workflows.

Skills

Microsoft Azure data technologies

Databricks platform

AWS data services

ETL solutions

Data integration

Data modeling and design principles

Advanced SQL skills

Git

Job description

Job Title: Software Developer – ETL (Senior)

Work Arrangement

Onsite (5 days per week)

Role Summary

The Senior ETL Software Developer is responsible for designing, developing, and maintaining scalable data pipelines and analytics solutions across cloud-based and enterprise data platforms. The role focuses on ETL development, data integration, data modeling, and performance optimization to support data warehouse, data lake, and business intelligence solutions.

Key Responsibilities

• Design, develop, and maintain ETL pipelines for structured and semi-structured data sources

• Perform data extraction, transformation, and loading for both initial and incremental loads

• Translate technical and business requirements into working, tested ETL solutions

• Develop detailed programming specifications and write high-quality, reusable code

• Build and maintain scheduling and dependency logic for ETL workflows

• Conduct unit testing, debugging, and performance tuning of ETL processes

• Investigate data issues, identify root causes, and propose corrective solutions

• Ensure data architecture is scalable, maintainable, and aligned with best practices

• Create and maintain technical documentation (ETL mappings, data models, architecture diagrams)

• Collaborate with business and technical stakeholders throughout the SDLC

• Provide post-implementation support, including troubleshooting and enhancements

Mandatory Technical Skills

• Strong experience with Microsoft Azure data technologies, including:

  • Azure Data Factory

  • Azure SQL Database

  • Azure Data Lake

  • Power BI

• Hands-on experience with the Databricks platform

• Experience with AWS data services, including:

  • Amazon Aurora

  • Amazon Relational Database Service

  • AWS Glue

  • OpenSearch

• Strong experience developing ETL solutions across multiple data repositories

• Expertise in data integration, data cleansing, and data analytics

• Strong knowledge of data modeling and design principles for data marts and data warehouses

• Experience designing modern analytics architectures (data warehouses, data lakes, lakehouses)

• Advanced SQL skills, including complex queries and performance tuning

• Experience with database management and administration

• Experience using Git and source control strategies

• Strong understanding of the full Software Development Life Cycle (SDLC)

General Development & Analysis Skills

• Experience in application design, coding, testing, debugging, and documentation

• Familiarity with structured development methodologies

• Ability to elicit, document, and validate business requirements

• Experience collaborating with cross-functional IT and business teams

• Strong analytical, problem-solving, and decision-making skills

• Proven ability to meet deadlines and work independently or as part of a team

Nice-to-Have Skills

• Experience designing dashboards and reports (scheduled and ad-hoc) highlighting KPIs and trends

• Programming experience with C#, APIs, or cloud-based functions

• Scripting experience using PowerShell or other scripting languages

• Experience with middleware, gateways, or integration platforms

• Knowledge of AODA and accessibility standards

• Experience conducting design walkthroughs and providing user/system documentation