RQ11713 – Software Developer – ETL – Senior

S M Software Solutions Inc; Toronto; On-site; CAD 110,000 - 150,000; Full time

Job summary

S M Software Solutions Inc in Toronto is seeking a Senior Software Developer – ETL to design, develop, and maintain scalable data pipelines across Azure and AWS platforms. You will implement ETL processes, optimize data warehouses, and contribute to BI initiatives using Power BI and related tools.

The role requires strong SQL, data modeling, and experience with Databricks, OpenSearch, and Git. Onsite work five days a week at 222 Jarvis Street is expected.

Qualifications

• Experience with Microsoft Azure data technologies including ADF, Azure SQL DB, ADL, and Power BI.
• Experience with the Databricks Platform and AWS services such as Aurora and RDS.
• Proficient ETL development and data integration for data warehouses.
• Ability to design, implement, and maintain scheduling and dependency logic for ETL scripts.
• Strong SQL, data modeling, and database administration skills.
• Experience with Git and source control, plus technical documentation.

Responsibilities

• Design, develop, and expand ETL data pipelines for data warehouse and BI use cases.
• Implement data extraction, transformation, and loading tasks across diverse data stores.
• Develop and maintain scheduling logic for ETL jobs and dependencies.
• Collaborate with stakeholders to document end-to-end data flows and mappings.
• Optimize database performance and support BI initiatives with Power BI dashboards.

Skills

Azure Data Factory

Azure SQL Database

Azure Data Lake

Power BI

Databricks

AWS Glue

SQL tuning

ETL development

Data integration

Data warehousing

Database administration

Git

Documentation

SDLC

Communication

Tools

Databricks Platform

OpenSearch

Azure Data Factory

AWS Glue

Job description

Description

Assignment Deliverables

Client: Ministry of Treasury Board Secretariat - RQ11713

We are seeking a Senior Software Developer – ETL with extensive experience in Microsoft Azure data technologies, Amazon Web Services (AWS), ETL development, data integration, data warehousing, database administration, SQL performance tuning, and business intelligence solutions. The successful candidate will design, develop, and maintain scalable data pipelines, implement data extraction, transformation, and loading processes, optimize database performance, develop technical documentation, and support enterprise data warehouse and business intelligence initiatives.

Role Snapshot

• Job Title: RQ11713 – Software Developer – ETL – Senior
• Client: Ministry of Treasury Board Secretariat
• Work Location: 222 Jarvis Street, Toronto, Ontario, Canada
• Work Arrangement: Onsite – 5 Days per Week
• Estimated Start Date: January 5, 2027
• Estimated End Date: October 5, 2027
• Business Days: 188.00
• Extension: 120.00 days
• Hours: 7.25 hours per day
• Security Level: CRJMC

Must Have

• Experience with the Microsoft suite of technologies, including:
• Azure Data Factory
• Azure SQL Database
• Azure Data Lake
• Power BI
• Experience with the Databricks Platform.
• Experience with the Amazon Web Services (AWS) suite of technologies, including Amazon Aurora, Amazon Relational Database Service (RDS), AWS Glue, OpenSearch, etc.
• Experience developing data extraction, transformation, and load (ETL) programs, including daily and initial load functionality, across a wide range of data repositories, such as structured and semi-structured files, relational databases, and multidimensional data stores.
• Experience developing, implementing, and maintaining scheduling and dependency logic for Extract, Transform, and Load (ETL) scripts.
• Experience with data integration, data cleansing, and data analytics.
• Experience with data modelling and design principles for data marts and data warehouses.
• Experience in database management and administration.
• Experience constructing complex SQL queries and performing database 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 eliciting, documenting, and validating business requirements.
• Experience in the software development lifecycle, from development through testing, quality assurance, and delivery.
• Solid communication skills, including the ability to understand, comprehend, and follow instructions and requirements, and communicate clearly and effectively both verbally and in writing.

Nice to Have

• Knowledge and understanding of the Accessibility for Ontarians with Disabilities Act (AODA) and related regulations and standards.
• Experience designing visual dashboards to highlight trends and Key Performance Indicators (KPIs), and developing scheduled and ad-hoc reports.
• Experience with programming languages such as C#, including developing application code such as APIs and functions.
• Experience writing scripts using PowerShell and other scripting languages.

Assignment Deliverables

• Designs, develops, and maintains database backend and ETL applications for data warehouse and business intelligence solutions. Uses knowledge of ETL languages and development techniques to build and expand application functionality by writing high-quality code using appropriate patterns. Ensures applications remain scalable while complying with standards and following best practices.
• Tests and debugs applications and ensures that software is properly documented.
• Collaborates clearly and professionally as part of a development team and communicates with clients.

Responsibilities

• Design, implement, and expand data pipelines by performing extraction, transformation, and loading (ETL) activities.
• Translate technical system specifications into functional and tested applications.
• Develop detailed programming specifications, write or generate code, compile data-driven programs, maintain applications, and conduct unit testing.
• Troubleshoot and resolve technical issues arising during software package usage and operations.
• Provide technical assistance for software implementation, data conversion, and migration activities.

General Skills

• Demonstrate experience in programming, analysis, and specialized software package support.
• Collaborate with IT professionals throughout the Software Development Life Cycle (SDLC).
• Apply structured methodologies for application development, design, implementation, and maintenance.
• Design, code, test, debug, and document applications.
• Utilize object-oriented and third-generation programming tools.
• Demonstrate proficiency in one or more programming languages.
• Apply application design principles, modern design patterns, deployment practices, and troubleshooting techniques.
• Work with relational and hierarchical database technologies.
• Use information retrieval tools and query languages.
• Demonstrate knowledge of communication protocols.
• Gather and document requirements from diverse business stakeholders and subject matter experts.
• Apply strong analytical, problem-solving, and decision-making skills.
• Demonstrate effective verbal and written communication, interpersonal, and negotiation skills.
• Collaborate effectively within teams and consistently meet project deadlines.

ETL Skills

• Gather requirements and understand business processes to transform data according to end-user needs.
• Maintain, optimize, and improve existing ETL processes.
• Design scalable, maintainable, and efficient data architectures.
• Collaborate with business stakeholders to design and deliver accurate, high-quality data solutions.
• Investigate data to identify issues within ETL pipelines, notify end users, and recommend appropriate solutions.
• Prepare detailed technical documentation for future reference and maintenance.

Desirable Skills

• Develop and maintain Internet-ready applications.
• Apply Rapid Application Development (RAD) methodologies.
• Understand Information Management principles, concepts, policies, and practices.
• Work with middleware technologies and gateways.
• Review, analyse, and modify product installation scripts, including encoding, testing, and debugging.
• Provide post-implementation support and resolve technical issues.
• Conduct design walkthrough sessions with project teams.
• Understand the Accessibility for Ontarians with Disabilities Act (AODA) and related regulations and standards.
• Prepare user and system documentation as required.

Experience And Skill Set Requirements

Core Technical Skills — 50%

• Experience with Microsoft technologies, including Azure Data Factory, Azure SQL Database, Azure Data Lake, and Power BI.
• Experience with Amazon Web Services (AWS), including Amazon Aurora, Amazon Relational Database Service (RDS), AWS Glue, and OpenSearch.
• Develop data extraction, transformation, and loading (ETL) programs for daily and initial data loads across structured and semi-structured files, relational databases, and multidimensional data stores.
• Develop, implement, and maintain scheduling and dependency logic for ETL scripts.
• Perform data integration, data cleansing, and data analytics.
• Apply data modelling and design principles for data marts and data warehouses.
• Perform database management and administration.
• Construct complex SQL queries and perform database performance tuning.
• Create technical documentation, including ETL source-to-target mappings, data model diagrams, architecture artifacts, and detailed design documents.

Other Technical Skills — 35%

• Design visual dashboards to highlight trends and Key Performance Indicators (KPIs).
• Develop scheduled and ad-hoc reports.
• Work with programming languages such as C# to develop application code, including APIs and functions.
• Write scripts using PowerShell and other scripting languages.
• Use Git and apply source control strategies.
• Participate in the Software Development Life Cycle (SDLC), including development, testing, quality assurance, and delivery.

Communications Skills — 10%

• Elicit, document, and validate business requirements.
• Demonstrate strong communication skills and the ability to understand, interpret, and follow instructions and requirements.
• Communicate clearly and effectively through verbal and written communication.

Standards and Best Practices — 5%

• Understand the Accessibility for Ontarians with Disabilities Act (AODA) and related regulations and standards.

Onsite Work Requirement

Onsite Work Requirement: The successful candidate is expected to work onsite five days per week, for 7.25 hours per calendar day, between the standard working hours of 8:00 AM to 5:00 PM (excluding lunch breaks), Monday to Friday inclusive, at the identified OPS office location.

• Work Arrangement: 5 days onsite.