At a Glance
- Tasks: Design and maintain scalable ETL solutions and data pipelines for enterprise data.
- Company: Join a dynamic team within the Ministry of Treasury Board Secretariat.
- Benefits: Competitive pay, onsite work in Toronto, and opportunities for professional growth.
- Other info: Great chance to enhance your career in a supportive and tech-driven workplace.
- Why this job: Make an impact by working on innovative data solutions in a collaborative environment.
- Qualifications: Experience with Azure stack, ETL processes, and advanced SQL skills required.
The predicted salary is between 95 - 101 $ per hour.
Role Overview
The 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 & Requirements
Mandatory 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 Criteria
- 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 Score 100%
Software Developer – Senior – Toronto employer: Analyst Technical Solutions
Join a dynamic team as a Senior Product Manager in Downtown Toronto, where your contributions will directly enhance public service delivery. Our collaborative work culture fosters innovation and empowers employees to grow through continuous learning opportunities and mentorship. Enjoy the unique advantage of working within the Government Services Integration Cluster, where your efforts will not only drive product excellence but also positively impact the community.
Contact Details:
Analyst Technical Solutions Recruitment Team
