Senior ETL Developer

Toronto, ON
On-site
Posted Oct 10, 2026
1 position

$90–$101 / hour

Opens LinkedIn

Employment type: Contract
Experience level: Senior · 5+ years
Posting language: English
Working hours: 37 hours per week
Seniority: Mid-Senior level
Application method: Direct apply is available

Job summary

Design, develop, and maintain ETL pipelines, data warehouse and business intelligence applications, and automated data processing workflows using Azure, Databricks, AWS, and SQL. Ensure data quality and performance through modeling, testing, troubleshooting, documentation, and collaboration with business and technical stakeholders.

Job details

Senior ETL Developer Location: Ontario Work Arrangement: Onsite, 5 days per week Schedule: Monday to Friday, 7.25 hours per day Job Description We are seeking an experienced Senior ETL Developer to design, develop, and maintain data pipelines and backend applications supporting data warehousing, business intelligence, and analytics solutions. The ideal candidate will have strong expertise in Microsoft Azure, Databricks, AWS, SQL, and ETL development, along with experience in data integration, data modeling, and performance optimization. Key Responsibilities Design, develop, and maintain ETL pipelines for extracting, transforming, loading, and integrating data from various structured and semi-structured sources. Develop and optimize data pipelines using Azure Data Factory, Databricks, Azure SQL Database, Azure Data Lake, and AWS services. Build and maintain data warehouse and business intelligence applications, ensuring scalability, performance, and data quality. Develop and maintain ETL scheduling, dependencies, and automated data processing workflows. Perform data cleansing, validation, troubleshooting, and performance tuning. Write complex SQL queries and manage database operations and administration. Design data models for data warehouses and data marts. Translate technical specifications and business requirements into tested, reliable applications. Conduct unit testing, debugging, quality assurance, and post-implementation support. Maintain technical documentation, including source-to-target mappings, data models, architecture diagrams, and detailed design documents. Collaborate with business stakeholders, technical teams, and subject matter experts throughout the software development lifecycle. Follow coding standards, source control practices, and established development methodologies. Mandatory Qualifications Strong experience with Microsoft Azure technologies, including: Azure Data Factory Azure SQL Database Azure Data Lake Power BI Hands-on experience with the Databricks platform. Experience with AWS technologies, including Amazon Aurora, Amazon Relational Database Service (RDS), AWS Glue, and OpenSearch. Proven experience developing ETL processes for initial and recurring data loads across multiple data repositories. Experience implementing and maintaining ETL scheduling and dependency logic. Strong knowledge of data integration, data cleansing, and data analytics. Experience with data modeling and design principles for data warehouses and data marts. Strong SQL development skills, including complex queries and performance tuning. Experience with database management and administration. Experience using Git and source control strategies. Ability to gather, document, and validate business and technical requirements. Experience across the software development lifecycle, including development, testing, quality assurance, and delivery. Strong analytical, troubleshooting, problem-solving, and communication skills. Nice-to-Have Qualifications Experience designing Power BI dashboards, KPI reports, and scheduled or ad hoc reports. Experience with C#, APIs, serverless functions, or similar application development. Experience with PowerShell and other scripting languages. Knowledge of accessibility standards, including the Accessibility for Ontarians with Disabilities Act (AODA). Experience with application deployment, technical documentation, and post-implementation support. Knowledge of information management principles, policies, and best practices. Work Arrangement This is an onsite contract opportunity requiring attendance at the designated Ontario office five days per week, Monday to Friday, during standard business hours. Note: We use AI tools to: obtain basic information, detect plagiarism, false employment history or references, categorize your skills, and do an initial match with job posting.

What you’ll do

Requirements

Candidates need strong experience with Azure, Databricks, AWS data services, ETL development and scheduling, data integration, data modeling, and complex SQL, along with database administration and Git experience. They must also be able to gather and validate requirements and contribute across the software development lifecycle, including testing, quality assurance, and delivery.