Job Description

RQ09427 Senior Software Developer ETL

Client: Ministry of Treasury Board Secretariat Central Agencies Cluster
Location: 222 Jarvis Street, Toronto, ON
Work Type: Hybrid (3 days onsite, 2 days remote)

Role Summary

The Senior ETL Developer will design, develop, and maintain backend database and ETL applications for enterprise Data Warehouse and Business Intelligence solutions. The role involves translating system specifications into functional, well-documented ETL code and collaborating with cross-functional teams to ensure scalable and reliable data flows.

Responsibilities

• Design and implement robust ETL pipelines using Microsoft technologies (Azure, SQL, Power BI).
• Translate technical specs into fully tested, functional code.
• Develop and maintain ETL scripts with schedule/dependency logic.
• Investigate and resolve issues in data flows; provide post-implementation support.
• Collaborate on solution design, documentation, and walkthrough sessions.
• Ensure applications meet performance, scalability, and compliance standards.

Mandatory Skills and Experience

• Proven experience with:
  • Azure Data Factory , Azure SQL Database , Azure Data Lake , Power BI
  • Oracle DB and structured/semi-structured data sources
  • Developing daily and initial load ETL programs
  • Constructing complex SQL queries and performance tuning
  • Data integration, cleansing, analytics, and modeling for data marts/warehouses
  • Source control tools (e.g., Git ) and documentation (ETL mappings, data models, etc.)
• Strong understanding of:
  • ETL architecture and schedule/dependency logic
  • Full SDLC (Development Testing QA Delivery)
  • Business requirement gathering and validation
• Excellent communication and collaboration skills

Desirable Skills

• Knowledge of:
  • Designing dashboards/KPIs and generating reports
  • C#, APIs, Functions, scripting languages (e.g., PowerShell )
  • SaaS implementations and RAD methodologies
  • Middleware, gateways, and software installation scripts

Job Tags

Similar Jobs