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
$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- ...control products. After more than 60 years, Price remains a privately held family company... ...for a passionate and experienced Software Developer with expertise in .NET to join our team.... ...to learn from the feedback provided by senior team members. • Translate business requirements...Senior
- ...critical controls, and noise control products. After more than 60 years, Price remains a privately held family company with a deep... ...Price Café offers free Tea and Coffee Job Title: Software Developer Location: Winnipeg Department: Business Systems Reports...Suggested
- 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
- ...Join The North West Company as a Software Development Lead, where you'll provide hands-on technical leadership in a collaborative environment... ...and troubleshoot issues Requirements: Minimum 5 years in software development, preferably in retail Bachelor's degree...Suggested
- 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
- ...critical controls, and noise control products. After more than 60 years, Price remains a privately held family company with a deep... ..., and you’re invited to be a part of that. Lab Systems Software Developer We are looking for a Software Developer to support the design...
- 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
- ...critical controls, and noise control products. After more than 60 years, Price remains a privately held family company with a deep... ...Our convenient Price Café offers free Tea and Coffee. ERP Software Developer An ERP Software Developer designs, develops, and implements...
- ...eligible for a gym membership reimbursement of up to $300 per year, this includes Fitness related App’s. • As part of our Goals... ...• Our convenient Price Café offers free Tea and Coffee. Software Developer – Antec Controls The Systems Developer role offers the opportunity...
- 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
- 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
- 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
- ...included as well as paid time off. Work schedule is Monday - Friday 8:00 AM - 8:30 PM, with 2.5 hour scheduled breaks. Saturday is 8:00 AM - 1:00 PM with 30 minutes scheduled break. Please apply if you have the qualifications listed on the advertisement. *English speaking...Live InMonday to friday
- ...Senior Back End Software Engineer Canada, United Kingdom, United States 1 gün 9 saat 9 dakika önce yayınlandı. Full Time Himalayas - Our software engineers at Epistemix... ...Your key responsibilities will include: Design, develop, and maintain clean, testable, and highly...SeniorFull time
- 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
- ...TD in Toronto is seeking an experienced leader to drive development programs in our Technology Solutions group. You will lead multi-disciplinary teams, coordinating delivery of complex software solutions, ensuring milestones are met while staying within budget and scope....Senior
- 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
- ...Build AI Inference Networking software at Equinix using SDN, proxying, and... ...distributed development team. As a Senior SDN Network Software Engineer, you will help develop open-source software for Equinix’... ...platforms Requirements: 5+ years designing highly redundant SDN...Senior
- ...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
- ...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
- 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
- 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
- ...25%. Job Description We are looking for a Senior Routing Engine Developer to design and build the next generation interaction routing... ...into routing capabilities. Qualifications ~8+ years of software engineering experience, including substantial ownership...SeniorFull timeInternshipRemote workRelocation
- ...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
- 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
- Job Overview: Looking for a high energy reliable part time babysitter for our super fun little girls. We have a 8 year old and a 3 year old. Looking primarily for after school/evenings and one weekend day. We live in the River Heights area. Starting date mid/end of September...Part timeLive In10 hours per weekFlexible hoursWeekend workDay shiftAfternoon shift1 day per week
- ...Paradigm has opportunities for Developers to employ their knowledge,... ...technology. The role will be based onsite for our customers who are in... .... If you have strong Developer experience within IT and feel... ...Consulting practice with over 35 years of experience and presence in...Contract work
- 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
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


