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.
Description
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.
How to Apply
If you are interested and your profile matches the requirements, kindly send the following mandatory documents to
hrsmss@smsoftconsulting.com by
Wednesday, October 14, 2026, at 10:00 AM EST.
Mandatory Documents
- Updated Resume in Word format – Mandatory
- References – Mandatory
- Expected Hourly Rate – Mandatory
- Visa Status – Mandatory
- LinkedIn ID – Mandatory
Without the mandatory documents, we cannot submit a candidate.
WhatsApp Group
For daily job updates, you can also join our WhatsApp group using the link below:
Join Our WhatsApp Group
https://chat.whatsapp.com/KCmWoqPlxWvAZmyXLcd8or
Note
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.
Email is the best way to reach us.
You have received this message either as a result of contacting our company to express interest in employment or as a result of posting your resume in a location that can be accessed by recruiters or HR specialists, which suggests an interest in being contacted about employment opportunities.
