Apply on Kit Job: kitjob.ca/job/2fiw1r

Our GTA based, Municipal Government Client requires the services of a Senior Data Engineer with Azure experience for modeling, designing and developing data pipelines, and analytics ready data sets and business intelligence solution(s).

ROLE:

Duties

- Work with the Enterprise Data project team in designing, developing and maintaining the Client's enterprise data warehouse, data marts, data lakes
- Responsible for designing, developing and documenting SSIS and/or Azure Data Factory (ADF) packages to integrate data from multiple systems
- Responsible for designing, developing and documenting complex T-SQL, stored procedures, views, triggers, indexes, etc.
- Develop and maintain Databricks notebooks and jobs using Python (PySpark) and SQL for batch and streaming workloads
- Build curated, analytics-ready datasets following layered patterns (e.g., bronze/silver/gold) and data product principles.
- Implement Delta Lake best practices
- Responsible for designing and implementing data quality processes
- Assist in the data modelling of the data warehouse/data mart/data lake solution(s)
- Advanced data analysis to provide meaningful data driven insights

MUST HAVE:





5+ years of experience in:

- Database development or data engineering for enterprise level solutions
- Hands-on experience working with:
- Microsoft Azure Synapse and/or SQL Data Warehouse and SQL Server 2016 or later.
- Microsoft Azure Data Factory and other related Azure Services
- Azure Databricks
- CI/CD pipelines (Azure DevOps)
- SQL and Python programming
- Developing Microsoft Power BI reports or other data visualization tools
- A university degree in Computer Science, or the equivalent, combined with directly related experience in a business or computer related discipline.
- Expert understanding and enterprise scale experience working with Data Warehouse (DW) and Business Intelligence (BI) implementations
- Solid understanding of data modelling techniques and data warehouse/data lake design
- Experience with data quality, data cleansing and data stewardship processes and techniques

Disclaimer:
AI may be used in evaluating candidates.
This posting is for an existing vacancy.

Apply

Apply on Kit Job: kitjob.ca/job/2fiw1r

📌 Senior Data Engineer with Azure required for modeling, designing and developing data pipelines, and analytics ready data sets and business intelligence sol (Toronto)
🏢 S.i. Systèmes
📍 Toronto