RQ09229 - Software Developer - ETL - Senior

S M Software Solutions Inc; Toronto; Hybrid; CAD 90,000 - 120,000; Full time

Job summary

A leading company is seeking a Senior Software Developer specializing in ETL to join their Integrations Team. The role focuses on integrating a new Dynamics 365 solution with various systems, ensuring data quality and performance. Candidates should have extensive experience with Azure technologies and data manipulation. This position offers a chance to work on critical projects within a hybrid work environment, contributing to the development and testing of innovative solutions.

Qualifications

• 5+ years experience with MS Azure Cloud and Dynamics 365.
• Expert proficiency in data manipulation languages.
• Experience leading testing teams.

Responsibilities

• Integrate Dynamics 365 solution with internal and external systems.
• Design and execute test plans based on specifications.
• Collaborate on CI/CD pipeline integration.

Skills

Azure Cloud

Data Manipulation

SQL

Integration Technologies

Testing

Tools

Power BI

PowerApps

Azure Data Factory

Azure Synapse

Azure DevOps

Job description

RQ09229 - Software Developer - ETL - Senior

RQ09229 - Software Developer - ETL - Senior

2 days ago Be among the first 25 applicants

Client: Ministry of Public and Business Service Delivery and Procurement

Work Location: 720 Bay Street, Toronto, Ontario, Onsite

Estimated Start Date: 2025-06-02

Estimated End Date: 2025-09-15

#Business Days: 73.00

Extension: Probable after the initial mandate

Hours per day or Week: 7.25 hours per day

Security Level: CRJMC

Must Haves

• 5+ years working experience of Microsoft (MS) Azure Cloud technology especially MS Dynamics 365 Customer Relationship Management (CRM) and Enterprise Resource Planning (ERP) applications such as Customer Engagement and Finance & Operations, PowerApps, Power Automate and Power BI, Data Factory and Data Pipelines.
• 5+ years of proven working experience in integrating various data sources and systems, both on-premises and in the cloud, using Azure ETL services or other ETL tools.
• 5+ years of experience working on, preferably leading, testing teams and efforts.
• Expert proficiency with data manipulation languages (T-SQL, PL/SQL), data definition languages, physical database design, data modeling, query performance analysis & tuning
• Proficiency in Azure Data Factory, Azure Synapse workspaces
• Proficiency in Azure-specific scripting using PowerShell or Azure CLI, .NET, C#, Power Platform, Logic Apps
• Strong SQL skills and experience working with Azure SQL Databases and Dataverse; good understanding of Azure storage concepts and technologies.
• In-depth knowledge of integration technologies commonly used with Dynamics, such as DataVerse, Data Entities, and APIs.
  
  

Nice To Have

• Azure cloud certifications (e.g., Azure Administrator, Azure Developer, Azure Data Engineer, Azure Database Administrator)
• Experience with continuous integration/continuous deployment (CI/CD) processes around DevOps, data workflows, Synapse workspaces.
• Knowledge of integration technologies commonly used with Dynamics, such as DataVerse, Data Entities, and APIs.
• Understanding of data pipeline architectures, Azure workflow orchestration tools, and concepts related to data ingestion, transformation, and movement.
• Azure cloud certifications (e.g., Azure Administrator, Azure Developer, Azure Data Engineer, Azure Database Administrator)
  
  

Description

Scope

The Office of the Public Guardian and Trustee (OPGT) is seeking a Senior Software Developer – ETL to join the Integrations Team. The role involves interfacing a new Dynamics 365 solution and data warehouse with internal (OPS) and external systems in collaboration with internal and vendor staff.

Assignment Deliverables

These Deliverables Will Require

As a member of the integrations team, the person will be responsible for integrating the new Dynamics 365 solution and data warehouse and internal (OPS) and external systems as a member of the integrations team made up of internal and vendor staff. A high-level list of deliverables for the integrations team follows:

• Designing, developing, and executing test plans, test cases, scripts, and test data based on technical/functional specifications.
• Maintaining a complete test plan and traceability matrix from requirements to test cases and results.
• Performing manual and automated testing to ensure system and integration functionality and performance.
• Collaborating on integrating tests into CI/CD pipelines.
• Providing development, analytical, and testing support across applications and solutions.
• Planning and executing data migration activities to Dynamics 365 CE and F&O.
• Verifying system configuration and optimization for seamless integration with other systems.
• Performing system integration performance analysis and optimization.
• Delivering user support through documentation, training, and issue resolution.
• Conducting data validation and resolving quality issues.
• Developing secure data/file transfer processes (e.g., via sFTP, API, Logic Apps).
• Implementing encryption/decryption processes in Azure.
• Executing interface-related QA/testing tasks.
• Documenting developed processes.
• Performing other duties as assigned.
  
  

The Vendor’s Personnel Will Also Be Required To

• Complete work and achieve milestones within the assigned deadlines;
• Notify the Cluster/Ministry project Manager in writing of any issues or other material concerns related to the Assignment Deliverables, as soon as he/she becomes aware of them
• Submit Deliverables for the Cluster/Ministry approval as they are completed.
• Comply with the Ontario Government and the Cluster/Ministry security procedures and practices
• Comply with the Ontario Government and the Cluster/Ministry architecture/technology standards and best practices
• Comply with the Ontario Government and the Cluster/Ministry Conflict of Interest and Confidentiality Guidelines
• Provide knowledge and skill transfer to a designated Cluster/Ministry staff; and comply with the Ontario Government I&IT Directive, Operational Policy on the I&IT Project Gateway Process, and other applicable Guidelines, Standards and Procedures.
  
  

Desired Skills And Experience

• 5+ years working experience of Microsoft (MS) Azure Cloud technology especially MS Dynamics 365 Customer Relationship Management (CRM) and Enterprise Resource Planning (ERP) applications such as Customer Engagement and Finance & Operations, PowerApps, Power Automate and Power BI, Data Factory and Data Pipelines.
• 5+ years of experience working on, preferably leading, testing teams and efforts.
• 5+ years of proven working experience in integrating various data sources and systems, both on-premises and in the cloud, using Azure ETL services or other ETL tools
• In-depth knowledge of integration technologies commonly used with Dynamics, such as DataVerse, Data Entities, and APIs.
• Expertise in data transformation techniques, aggregation, enrichment, and normalization using Azure cloud technologies.
• Understanding of data governance principles, data privacy regulations and experience working with high-sensitivity data, and knowledge of best practices for data security and compliance in Azure.
• Ability to monitor and troubleshoot integration processes and implement efficient data processing techniques in Azure.
• Strong SQL skills and experience working with Azure SQL Databases and Dataverse; good understanding of Azure storage concepts and technologies.
• Expertise with Microsoft Power Platform, Logic Apps.
• Familiarity with version control systems (e.g., Azure Repos) and collaboration tools (e.g., Azure DevOps) for managing code, tracking changes, and collaborating with team members.
• Experience with continuous integration/continuous deployment (CI/CD) processes around DevOps, data workflows, Synapse workspaces.
• Experience with SQL Server Management Studio, Azure data management tools, XRM toolbox, data modeling tools (ERWIN or PowerDesigner).
• Familiarity with data warehousing concepts and experience working with Azure Synapse Analytics.
• Experience with PowerApps platform, Power Automate, Dynamics CE and F&O
  
  

Experience And Skill Set Requirements

Criteria 1: Microsoft Dynamics 365 CRM & ERP Applications and Azure Cloud Experience - 40 Points

• Demonstrated experience of Microsoft (MS) Azure Cloud technology especially MS Dynamics 365 Customer Relationship Management (CRM) and Enterprise Resource Planning (ERP) applications such as Customer Engagement and Finance & Operations, PowerApps, Power Automate and Power BI, Data Factory and Data Pipelines.
  
  

Criteria 2: Data Manipulation Skills and Experience - 30 Points

• Demonstrated experience with ETL development, data pipelines, workflow orchestration and data ingestion, transformation, and movement.
• Demonstrated experience in integrating various data sources and systems, both on-premises and in the cloud, using Azure ETL services or other ETL tools
• Demonstrated experience with data manipulation languages (T-SQL, PL/SQL), data definition languages, query performance analysis & tuning.
  
  

Criteria 3: Testing and Quality Assurance - 20 Points

• Demonstrated experience of creation and execution of test cases, test scripts, and test data based on functional and technical specifications.
• Maintain comprehensive testing documentation, including test plans, test cases, test results, and defect reports and ensure all documentation is up-to-date and accessible to relevant parties.
• Identify potential risks related to testing and implement mitigation strategies.
  
  

Criteria 4: Communication Skills - 10 Points

• Ability to effectively communicate complex technical information to non-technical stakeholders.
• Ability to work collaboratively with cross-functional teams.
• Strong interpersonal skills to build relationships with stakeholders.
  
  

Note: This position is currently listed as "Onsite"; however, the Assignment under this request will provisionally be "Hybrid", working 7.25 hours per calendar day, sometime between 8:00 AM and 5:00 PM (excluding breaks) Monday to Friday inclusive, unless otherwise identified. These conditions are subject to change as the OPS reflects on its current situation. During the duration of the assignment, you will be under the discretion of the Hiring Manager's requirements for the Project you are assigned to.

The VOR Master Service Agreement which expires on April 5, 2026, leaves some Contracts with funding unassigned for fiscal 2026-27. If the current statement of work expires on March 31, 2026, the remaining funds can be used to exercise an option to extend the SOW beyond March 31, 2026, based on business case approvals. Such extensions will be allowable, only if the Master Service Agreement is extended beyond April 5, 2026, and be upon the same terms, conditions, and covenants contained in the SOW.

The start date is subject to change based on security clearances and contract signing timelines.

Eligibility and Application Steps

If you are enthusiastic about this exciting opportunity, we kindly request you to provide the following documents: [e-mail]

Without mandatory documents, we cannot submit a candidate.

• Updated Resume in word format (Mandatory)
• Skills Matrix and References (Mandatory)
• Expected hourly rate (Mandatory)
• Visa Status (Mandatory)
• LinkedIn ID (Mandatory)
  
  

Please only apply if you meet the qualifications mentioned above. Feel free to share with your network or tag someone who fits for this role!

If you have any questions or need further clarification, feel free to call or text at [phone]

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Engineering and Information Technology

• Industries

  IT Services and IT Consulting

Referrals increase your chances of interviewing at S M Software Solutions Inc by 2x

Get notified about new Senior Software Engineer jobs in Toronto, Ontario, Canada.

Senior Engineering Manager - Developer Experience

Senior Team Lead, Software Development (IoT)

Data Scientist Lead, AI and Data - Elevate Program 2025

Senior Software Engineer - Java, Spring, AWS

Java - Applications Development Sr Programmer Analyst - AVP

Java - Applications Development Sr Programmer Analyst - AVP

Java - Applications Development Sr Programmer Analyst - AVP

Java - Applications Development Sr Programmer Analyst - AVP

Senior Software Engineer - Transaction Auditing

Senior Online Programmer – Unannounced IP

Principal Generalist Programmer – Dead by Daylight

Senior Product Manager, AI Applications & Developer Frameworks

Senior Software Quality Assurance Specialist - Propulsion Thermal Simulation Lead

Lead Data Scientist - Feature Engineering

Lead Data Scientist - Articial Intelligence Specialist

Senior Data Scientist - Product Analytics

Senior Marketing Cloud Technical Consultant/Developer

Senior Database Developer, Product Support Team (Bangkok based, relocation provided)

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.