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
- 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
Analyst Technical Solutions
Winnipeg, MB1 hour ago - 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
Analyst Technical Solutions
Winnipeg, MB1 hour ago - 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
Analyst Technical Solutions
Winnipeg, MB1 hour ago - 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...SuggestedWork at officeMonday to friday
Analyst Technical Solutions
Winnipeg, MB1 hour ago - ...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
Analyst Technical Solutions
Winnipeg, MB1 hour ago - 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
Analyst Technical Solutions
Winnipeg, MB1 hour ago - RQ11668 - Business Analyst - Senior Organization: Government Services Integration Cluster... ...Delivery and Procurement location: Toronto ON -Onsite Pay Rate:90-95/hr incorp Title:... ...facing portal). Azure DevOPS is used to develop user stories. This position is to understand...SeniorInternshipWork at officeMonday to friday
Analyst Technical Solutions
Winnipeg, MB1 hour ago - RQ09230 - Software Developer - ETL - Senior About the job RQ09230 - 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
Rubicon Path
Winnipeg, MB1 hour ago - 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
Altis
Winnipeg, MB1 hour ago - ...hands-on experience designing and developing scalable, production-grade... ...-on expertise in Python, SQL, ETL/ELT, APIs, data integration and... ...platforms, applying strong software engineering practices to build... ...Location: Hybrid – 3 days a week onsite Public Sector Experience:...Senior3 days per week
Flexstaf IT
Winnipeg, MB1 hour ago - 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
Rubicon Path
Winnipeg, MB1 hour ago - Take your expertise to the next level as a Senior Software Developer specializing in ETL at Innosystech Inc in Toronto. This onsite role focuses on advanced data solutions utilizing Microsoft and AWS technologies. Innosystech Inc is seeking a Senior Software Developer skilled...Senior
Best Your Buy
Winnipeg, MB1 hour ago - ...tier IT talent with leading organizations. Location: Downtown Toronto, ON (5 days onsite in the office) Position Type: Contract Responsibilities: Power BI Development & Reporting Design, develop, and maintain interactive Power BI dashboards and reports to...Contract workWork at office
Dawn InfoTek
Winnipeg, MB1 hour ago - ...This position is listed as “Onsite” unless otherwise instructed by... ...reporting consumption. Design, develop, and release deploy Power BI... ...the use and operation of software packages, including technical... ...Mandatory Skills and Experience 6+ years experience as Azure...Work at officeMonday to friday
SOFTLINE TECHNOLOGY
Winnipeg, MB1 hour ago - 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
Analyst Technical Solutions
Winnipeg, MB1 hour ago $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 payAnalyst Technical Solutions
Winnipeg, MB1 hour ago- 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
Rubicon Path
Winnipeg, MB1 hour ago - 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
Analyst Technical Solutions
Winnipeg, MB1 hour ago - 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
Pathlion
Winnipeg, MB1 hour ago - 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
Rubicon Path
Winnipeg, MB1 hour ago - 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
Rubicon Path
Winnipeg, MB1 hour ago - 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
Analyst Technical Solutions
Winnipeg, MB1 hour ago - ...We are seeking a highly accomplished Senior Software Developer for an enterprise contract opportunity based in Toronto. In this role, you will take on a premier full-stack software engineering, application architecture, and technical delivery capacity, specializing in the...SeniorContract work
Randstad
Winnipeg, MB1 hour ago $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 officeTri-global Solutions Group Inc.
Winnipeg, MB1 hour ago$180k - $200k per year
...Location: Vancouver, BC – 3 days a week onsite Job ID: 87597 Overview As a... ...within our AI organization. While a Senior Data Scientist excels at building and... ..., Agile. What You Must Have 10+ years of experience in software or data science, with at least 8+ years...Senior3 days per week- We are seeking a dedicated and technically driven Senior Software Developer for a contract opportunity based in Toronto. In this role, you will take on an impactful AI/ML engineering, large language model (LLM) pipeline, and model inference capacity, specializing in executing...SeniorContract work
Randstad Canada
Winnipeg, MB1 hour ago - Build public-facing government portals in Toronto with React, JavaScript, and TypeScript expertise. TWC Global seeks a senior developer for registration and permit workflows.TWC Global Services is seeking a Senior Software Developer for Government Sector Enterprise projects....SeniorWork at office
Best Your Buy
Winnipeg, MB1 hour ago - ...Epsilon Solutions LTD is hiring a Senior Salesforce Developer to work on the Toronto-based role. The position involves designing, building, and deploying Apex, LWC, and Flow solutions within Salesforce Financial Services Cloud, and owning integrations via REST/SOAP APIs and...Senior
Best Your Buy
Winnipeg, MB1 hour ago - About the job RQ08100: Software Developer - ETLGeneral ResponsibilitiesThis role is responsible for designing... ...developing, maintaining, and optimizing ETL (Extract, Transform, Load) processes in... ...Location. Must Have Skills 7+ years using ETL tools such as Microsoft SSIS, stored...Work at office3 days per week
Rubicon Path
Winnipeg, MB1 hour ago - About the job RQ07956 - Sr Software Developer - ETLResponsibilities Design, implement, and continuously... ...a track record for meeting deadlines ETL Skills Knowledge and experience in... ...Technical Skills - 45% Demonstrates 5 - 10 years of experience designing, developing, and...Senior
Rubicon Path
Winnipeg, MB1 hour ago
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 engineer part time Winnipeg, MB
- software engineer Winnipeg, MB
- software design engineer Winnipeg, MB
- software engineer - computer Winnipeg, MB
- software developer internship no experience Winnipeg, MB
- ingénieur logiciel Winnipeg, MB
- software engineer co-op Winnipeg, MB
- software development engineer Winnipeg, MB
- software developer Winnipeg, MB
- software engineer - ai machine learning Winnipeg, MB