Senior Software Developer – ETL

Job Title: Senior Software Developer – ETL

Location: Toronto, ON, Canada

Work Arrangement: Onsite – 5 Days a Week

Duration: Contract

Job Overview

We are seeking an experienced Senior ETL Developer to design, develop, implement, and maintain robust data pipelines for Data Warehouse and Business Intelligence solutions. The ideal candidate will have strong hands-on experience with Microsoft Azure data technologies, AWS data services, Databricks, SQL, and ETL development.

The candidate will be responsible for building scalable data integration solutions, optimizing data processing workflows, ensuring data quality, and collaborating with business stakeholders and technical teams to deliver reliable, high-quality data solutions.

Note: This position requires onsite work five days per week at the designated Ontario Public Service (OPS) office in Toronto, with a daily working schedule of 7.25 hours, Monday through Friday, within standard business hours of 8:00 AM to 5:00 PM, excluding lunch breaks.

Key Responsibilities

• Design, develop, implement, and maintain ETL pipelines for data warehouse and business intelligence applications.
• Build and enhance data extraction, transformation, and loading processes for structured and semi-structured data sources.
• Develop and maintain ETL workflows, including scheduling, dependency management, initial data loads, and daily incremental loads.
• Work with Azure Data Factory, Azure SQL Database, Azure Data Lake, Databricks, and Power BI to develop and support data solutions.
• Leverage AWS services, including AWS Glue, Amazon Aurora, Amazon OpenSearch, and related database technologies, for data integration and processing.
• Develop complex SQL queries, perform database administration, and optimize query performance.
• Implement data integration, cleansing, validation, and analytics processes to ensure data accuracy and consistency.
• Design and maintain data models, data marts, and data warehouse structures that support business reporting and analytics.
• Troubleshoot ETL pipeline failures, investigate data quality issues, and implement appropriate corrective actions.
• Translate business and technical requirements into detailed technical specifications and production-ready solutions.
• Create and maintain technical documentation, including source-to-target mappings, data models, architecture diagrams, and detailed design documents.
• Follow software development lifecycle processes, coding standards, testing procedures, version control practices, and deployment best practices.
• Collaborate with business stakeholders, data teams, and IT professionals throughout development, testing, implementation, and post-production support.
• Provide technical support, resolve application issues, and ensure solutions remain scalable, reliable, and maintainable.

Mandatory Skills and Qualifications

• Strong hands-on experience with Microsoft Azure data technologies, including Azure Data Factory, Azure SQL Database, Azure Data Lake, and Power BI.
• Experience with the Databricks platform for data engineering and processing.
• Hands-on experience with AWS data services, including AWS Glue, Amazon Aurora, Amazon OpenSearch, and related database technologies.
• Proven experience developing and maintaining ETL pipelines for structured and semi-structured data repositories.
• Experience implementing ETL scheduling, workflow orchestration, and job dependency logic.
• Strong knowledge of data integration, data cleansing, data quality, and data analytics.
• Experience with data modeling and design principles for data warehouses and data marts.
• Strong database management and administration skills.
• Expertise in complex SQL query development, troubleshooting, and performance tuning.
• Experience with Git and source control management strategies.
• Ability to prepare technical documentation, including ETL mappings, data models, architecture artifacts, and detailed design specifications.
• Experience gathering, documenting, and validating business and technical requirements.
• Knowledge of the software development lifecycle, including development, testing, quality assurance, deployment, and maintenance.
• Excellent analytical, problem-solving, communication, and collaboration skills.

Nice-to-Have Skills

• Knowledge of the Accessibility for Ontarians with Disabilities Act (AODA) and related accessibility standards.
• Experience designing Power BI dashboards, KPI visualizations, scheduled reports, and ad hoc reports.
• Experience with C# and application development, including APIs and Azure Functions or similar services.
• Experience with PowerShell and other scripting languages.
• Experience with middleware, gateways, and application integration.
• Familiarity with rapid application development methodologies and structured software development practices.
• Experience providing post-implementation support and resolving production issues.

Required Professional Competencies

• Strong attention to detail and commitment to data accuracy and quality.
• Ability to analyze complex technical problems and recommend effective solutions.
• Strong written and verbal communication skills.
• Ability to work collaboratively with technical teams and business stakeholders.
• Proven ability to manage priorities, follow instructions, and meet project deadlines.
• Commitment to coding standards, technical documentation, and software development best practices.

Ideal Candidate

The ideal candidate is a senior-level ETL Developer with practical experience across Azure, AWS, Databricks, and SQL-based data engineering. They should be capable of independently developing and optimizing complex ETL workflows, supporting enterprise data warehouse solutions, resolving data quality issues, and translating business requirements into reliable technical implementations.