RQ11713 - Software Developer - ETL - SeniorOrganization: Central Agencies ClusterMinistry: Ministry of Treasury Board SecretariatLocation: Toronto, ON OnsitePay rate: 95-101/hr incorpTitleSoftware Developer - ETLDescriptionRole 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 ResponsibilitiesPipeline 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 SkillsMicrosoft 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, Open Search).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 SkillsApplication Development: Experience with C#, REST APIs, Azure Functions, or microservices.Scripting: Automation using Power Shell 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 CriteriaCategory Criteria Breakdown WeightCore Technical SkillsAzure stack (ADF, Azure SQL, ADLS, Power BI)AWS ecosystem (Aurora, RDS, Glue, Open Search)End-to-end ETL design, scheduling, cleansing, and analyticsData warehousing, modeling, and administrationComplex SQL optimization and performance tuningSource-to-target mapping and technical documentation50%Secondary Technical SkillsGit source control strategiesEnd-to-end SDLC best practicesApplication development (C#, APIs, Functions)Power Shell scripting and automationDashboard and KPI report design35%Communication SkillsRequirement elicitation, stakeholder management, and validationClear written documentation and technical communication10%Standards & ComplianceUnderstanding of AODA standards and government IT guidelines5%Total Score100%#J-18808-Ljbffr

📌 Rq11713 - Software Developer - Etl - Senior I Toronto - Onsite I 1+Year
🏢 Analyst Technical Solutions
📍 Toronto