Senior Software Developer - ETL
Senior Software Developer - ETL
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
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
Employment Type
Full Time
