Rq11713 - Software Developer - Etl - Senior I Toronto - Onsite I 1+Year
Analyst Technical Solutions
RQ11713 - Software Developer - ETL - Senior
Organization: Central Agencies Cluster
Ministry: Ministry of Treasury Board Secretariat
Location: Toronto, ON Onsite
Pay rate: 95-101/hr incorp
Title
Software Developer - ETL
Description
Role OverviewThe Senior ETL Developer will design, build, and maintain scalable database backends, data pipelines, and Extract, Transform, Load (ETL) solutions supporting Enterprise Data Warehouse and Business Intelligence platforms.
Key Responsibilities
Pipeline Development: Design, build, and maintain initial and incremental (daily) ETL/ELT pipelines across structured and semi-structured datasets.
Architecture & Modeling: Implement scalable data architectures, dimensional models, data marts, and warehouse repositories.
Code & Automation: Write modular code, manage dependency scheduling logic, and build data cleansing routines.
Performance Tuning: Optimize complex SQL queries and conduct database administration tasks.
Documentation: Produce source-to-target mapping documents, data models, and detailed technical specifications.
Support & Collaboration: Troubleshoot production pipeline defects, participate in design walkthroughs, and translate business requirements into technical deliverables.
Qualifications & RequirementsMandatory Technical Skills
Microsoft Azure Stack: Azure Data Factory (ADF), Azure SQL Database, Azure Data Lake Storage (ADLS), and Power BI.
Cloud & Big Data Platforms: Databricks, AWS services (Amazon Aurora, RDS, AWS Glue, OpenSearch).
ETL & Data Engineering: Advanced data extraction, transformation, data modeling, cleansing, and pipeline scheduling.
Databases & Querying: Relational and dimensional databases, advanced SQL development, and query optimization.
Source Control & SDLC: Full lifecycle development experience utilizing Git and standard branching strategies.
Nice-to-Have Skills
Application Development: Experience with C#, REST APIs, Azure Functions, or microservices.
Scripting: Automation using PowerShell or similar scripting languages.
Reporting: Designing ad-hoc reports and executive KPI dashboards.
Compliance: Working knowledge of the Accessibility for Ontarians with Disabilities Act (AODA) standards.
Evaluation CriteriaCategoryCriteria BreakdownWeight
Core Technical Skills
Azure stack (ADF, Azure SQL, ADLS, Power BI)
AWS ecosystem (Aurora, RDS, Glue, OpenSearch)
End-to-end ETL design, scheduling, cleansing, and analytics
Data warehousing, modeling, and administration
Complex SQL optimization and performance tuning
Source-to-target mapping and technical documentation
50%
Secondary Technical Skills
Git source control strategies
End-to-end SDLC best practices
Application development (C#, APIs, Functions)
PowerShell scripting and automation
Dashboard and KPI report design
35%
Communication Skills
Requirement elicitation, stakeholder management, and validation
Clear written documentation and technical communication
10%
Standards & Compliance
Understanding of AODA standards and government IT guidelines
5%
Total Score100%
#J-18808-Ljbffr
Organization: Central Agencies Cluster
Ministry: Ministry of Treasury Board Secretariat
Location: Toronto, ON Onsite
Pay rate: 95-101/hr incorp
Title
Software Developer - ETL
Description
Role OverviewThe Senior ETL Developer will design, build, and maintain scalable database backends, data pipelines, and Extract, Transform, Load (ETL) solutions supporting Enterprise Data Warehouse and Business Intelligence platforms.
Key Responsibilities
Pipeline Development: Design, build, and maintain initial and incremental (daily) ETL/ELT pipelines across structured and semi-structured datasets.
Architecture & Modeling: Implement scalable data architectures, dimensional models, data marts, and warehouse repositories.
Code & Automation: Write modular code, manage dependency scheduling logic, and build data cleansing routines.
Performance Tuning: Optimize complex SQL queries and conduct database administration tasks.
Documentation: Produce source-to-target mapping documents, data models, and detailed technical specifications.
Support & Collaboration: Troubleshoot production pipeline defects, participate in design walkthroughs, and translate business requirements into technical deliverables.
Qualifications & RequirementsMandatory Technical Skills
Microsoft Azure Stack: Azure Data Factory (ADF), Azure SQL Database, Azure Data Lake Storage (ADLS), and Power BI.
Cloud & Big Data Platforms: Databricks, AWS services (Amazon Aurora, RDS, AWS Glue, OpenSearch).
ETL & Data Engineering: Advanced data extraction, transformation, data modeling, cleansing, and pipeline scheduling.
Databases & Querying: Relational and dimensional databases, advanced SQL development, and query optimization.
Source Control & SDLC: Full lifecycle development experience utilizing Git and standard branching strategies.
Nice-to-Have Skills
Application Development: Experience with C#, REST APIs, Azure Functions, or microservices.
Scripting: Automation using PowerShell or similar scripting languages.
Reporting: Designing ad-hoc reports and executive KPI dashboards.
Compliance: Working knowledge of the Accessibility for Ontarians with Disabilities Act (AODA) standards.
Evaluation CriteriaCategoryCriteria BreakdownWeight
Core Technical Skills
Azure stack (ADF, Azure SQL, ADLS, Power BI)
AWS ecosystem (Aurora, RDS, Glue, OpenSearch)
End-to-end ETL design, scheduling, cleansing, and analytics
Data warehousing, modeling, and administration
Complex SQL optimization and performance tuning
Source-to-target mapping and technical documentation
50%
Secondary Technical Skills
Git source control strategies
End-to-end SDLC best practices
Application development (C#, APIs, Functions)
PowerShell scripting and automation
Dashboard and KPI report design
35%
Communication Skills
Requirement elicitation, stakeholder management, and validation
Clear written documentation and technical communication
10%
Standards & Compliance
Understanding of AODA standards and government IT guidelines
5%
Total Score100%
#J-18808-Ljbffr
Vacancy posted 1 hour ago
Similar jobs that could be interesting for youBased on the Rq11713 - Software Developer - Etl - Senior I Toronto - Onsite I 1+Year in Winnipeg, MB vacancy
- Job Title: RQ11720 - Software Developer - Senior Organization: Government Services Integration Cluster Location: Toronto ON, Onsite 5 days a week Pay Rate:95-101/hr incorp Title: BOR - One Senior Software Developer DescriptionDevelops, configures, integrates,...Senior
- RQ11754 - Software Developer - Senior Government Services Integration Cluster ResponsibilitiesRequired to translate technical systems specifications into working, tested applications. This includes: developing detailed programming specifications writing and/or...Senior
- RQ11499 - Software Developer - CRM - Senior Organization: Government Services Integration Cluster Ministry: Ministry of Public and Business Service... ...experience and understanding of data warehouse, ETL methodologies and OBIEE Demonstrated work experience on...Senior
- RQ11661 - Software Developer - CRM – Senior Client: Government Services Integration Cluster Location: Toronto ON Duration: 1 + year Pay rate: 95-103/hr incoro TitleSoftware Developer - MS Dynamics 365 CRM DescriptionThe Ontario Ministry of Environment, Conservation...Senior
- ...RQ11508 - Software Developer - Senior Client: Government Services Integration Cluster Pay Rate: 95-101/hr incorp Location: Toronto ON - Onsite DescriptionMust Have: 10+ years of experience as a designer and developer in the large-scale multi-client web applications...SeniorManual labor
- RQ11507 - Software Developer- Front End - SeniorTitle: Software Developer- Front Endpay rate: 95-100/hr incorpLocation: Toronto ON 1+ yearDuration: 1 Year + DescriptionResponsibilities:Designing, developing and implementing front end code including user interface interactions...SeniorInternship
- RQ11685 - Software Developer - Back End - SeniorOrganization: Labour and Transportation Cluster location: Toronto ON -Onsite Title Software Developer - Back End Pay Rate: 95-100/hr incorp DescriptionResponsibilities / Deliverable / Skill Set Requirements – Analysis...SeniorInternship
- RQ11718 - Software Developer - IntermediateOrganization: Central Agencies ClusterMinistry of Treasury... ...candidate is expected to work onsite five days per week, for 7.25 hours per calendar... ...conducting unit tests. Mandatory Skills: 7+ years' experience in developing n-tier...Work at officeMonday to friday
- RQ10953 - Software Developer - CRM - Senior Justice Technology Services Ministry of Public and Business Service Delivery and Procurement Pay... ...Software Developer – CRM / Microsoft Dynamics 365 Location: Toronto, Ontario Work Arrangement: Onsite Position...SeniorContract workWork at officeMonday to friday
- ...Gating Process, and OPS Standard Systems Development Methodologies Develops strategies, prepares business cases and cost-benefit analysis,... ...stakeholder engagementExperience in the use of Computer Aided Software Engineering (CASE) tools to document conceptual requirements and...SeniorInternship
- RQ09444 - Software Developer - ETL - Senior About the job RQ09444 - Software Developer - ETL - Senior This position is currently listed as "Onsite"; however, the Assignmentunder this request will provisionally be "Hybrid", working 7.25 hours per calendar day, sometime...SeniorContract workWork at officeMonday to friday
- ...effectiveness in working closely with cross-functional teams, including developers, QA specialists, and business stakeholders, to achieve common... ...in designing with accessibility in mind, and meeting WCAG 2.1 AA requirementsPrior Public Service/OPS experience: (5%) Must Have...Senior
- Job Title: RQ11715 - Business Analyst - Senior Organization: Government Services Integration Cluster Location: Toronto ON, Onsite 5 days a week Pay Rate:90-95 /hr incorp... ...Standard Systems Development Methodologies Develops strategies, prepares business cases and...Senior
- ...Delivery and Procurementlocation: Toronto ON -OnsitePay Rate: 90-95/hr... ...and technical specifications, develop Figma prototypes; including... ...bases.This position is listed as "Onsite"; the resource is expected... ...Experience and Skill Set Requirements 1. Data & Business Analysis &...SeniorInternshipWork at officeMonday to friday
- RQ09222 - Software Developer - ETL - Senior About the job RQ09222 - Software Developer - ETL - Senior DescriptionA Note on Assignment Type:This position is currently listed as "Onsite"; however, the Assignmentunder this request will provisionally be "Hybrid", working...SeniorContract workWork at officeMonday to friday
- RQ11610 – Senior Business AnalystClientGovernment Services Integration ClusterLocation: Toronto ON - Onsite Par Rate: 90-95/hr incorp Position OverviewThe Senior Business Analyst... ...and systems development methodologies. Develop business cases, strategies, options...Senior
- Senior Software Developer, ETL & AI Data Engineering Location: Toronto, ON (Hybrid, 3 days onsite per week, near Union Station)Language: Written and spoken language requirements to be confirmedDuration: 6-month contract, until May 31, 2027About the Opportunity...SeniorContract work3 days per week
- Client: Metrolinx – RQ00241We are seeking a Senior Software Developer – ETL with significant hands‑on experience in designing, developing, and maintaining scalable, production‑grade data pipelines and integration solutions. The ideal candidate will have strong expertise...Senior3 days per week
- RQ09315 - Software Developer - ETL - SeniorAbout the job RQ09315 - Software Developer - ETL - SeniorNOTE Assignment Type: This position is... ...listed as "Hybrid" and consultants will be required to work onsite at the work location 3 days a week and 2 days from home....SeniorContract workInternship3 days per week
$95 - $101 per hour
Government Services Integration Cluster in Toronto is seeking a Senior Software Developer to design, develop, and maintain Java components. You will build cloud-based microservices in Microsoft Azure, review code, and support deployments. Strong leadership and experience with...SeniorHourly pay- RQ09467 - Software Developer - ETL - SeniorTo respond to the priorities of the Government of Ontario through the passage of the Bill 5, Protect Ontario... ...: will work in office 3 days per week (40 St. Clair West, Toronto) and 2 days remotely. A highly skilled and experienced...SeniorWork at officeRemote work3 days per week
- RQ11775 - Software Developer - Senior I Toronto ON I 2+ yearClient:Justice Technology ServicesLocation: Toronto ON onsitePay Rate- 95-101/hr incorpOPP Level 4 Clearances:This position requires an OPP Level 4 security clearance Scope A Senior Software Developer is required...Senior
- ...Bursting technologies, and Informatica ETL. Responsibilities:This request is for strong developers to help in designing and... ...programming and analysis; specialized software package support at the specified... ...Skills - 70%Must have: 5+ years’ Experience with analysis,...SeniorApprenticeship
- The Senior Software Developer - ETL will design, build, and maintain scalable data pipelines, integrations, and reusable data services that enable enterprise AI, analytics, and data initiatives. The role will help improve access to trusted data across enterprise systems...Senior
- RQ10990 - Business Analyst - Senior Organization: Land & Resources Cluster Ministry... ...Analyst - Senior Location: Toronto; 5 days onsite Pay rate: 90-100/hr incorp Description... ...Systems Development Methodologies. Develops strategies, prepares business cases...SeniorContract workWork at office
- RQ08687 - Software Developer - ETL - SeniorAbout the job RQ08687 - Software Developer - ETL - Senior Responsibilities Participate in the review of project, work request and maintenance release artefacts - Use Case, System Requirement Specification, etc. Deliver detailed...SeniorInternshipWork at office3 days per week
- ...Services Integration Cluster Location: Toronto ON Onsite Pay rate: 60-65/hr incorp TitleUX... ...efficiently and intelligently. 3+ years of relevant experience in participating... ...have Figma experience. Expertise in UX software such as JustInMind, InVision, Sketch, Adobe...Internship
- Software Developer - Full Stack Client: Community Service Cluster Location: Toronto ON Pay Rate: 95- 103/hr incorp DescriptionResponsibilities· Design, implement, and... ...provide advice to clients, program staff and senior management. · A team player with a track...Senior
- Elevate your expertise as a Senior Software Developer ETL at the Office of the Public Guardian and Trustee. This hybrid role focuses on integrating and testing the Dynamics 365 solution. In this position, you’ll contribute to critical integrations within the integrations team...SeniorWork at office
$100 per hour
SENIOR SOFTWARE DEVELOPER/ETL (Azure & Python; Enterprise AI & Data Centre of Excellence)Requisition #: R26-3629 (RQ00241) Location: Hybrid (3 days onsite / 2 days WFH; Toronto, ON - *See WorkModel) Engagement Type: Contract Number of Resources required...SeniorHourly payContract workFor contractorsWork at office
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Rq11713 - Software Developer - Etl - Senior I Toronto - Onsite I 1+Year. Be the first to apply!
Related searches
- software developer internship no experience Winnipeg, MB
- software engineer intern Winnipeg, MB
- software developer Winnipeg, MB
- software developer remote Winnipeg, MB
- software engineer - ai machine learning Winnipeg, MB
- part time software developer Winnipeg, MB
- junior software engineer Winnipeg, MB
- software engineer part time Winnipeg, MB
- software developer intern Winnipeg, MB
- senior software developer Winnipeg, MB

