Senior Data Engineer

We are seeking a highly specialized Senior Data Engineer for a high-impact, 35-month assignment in Toronto. This role is responsible for the foundational architecture and modernization of the enterprise data ecosystem, including the design and maintenance of the Enterprise Data Warehouse (EDW), data lakes, and data marts. You will lead the development of end-to-end data pipelines and build high-performance, analytics-ready datasets using the latest Azure cloud technologies to support complex business intelligence needs.

Duration: 35-month contract

Location:

Toronto, ON (Hybrid – Minimum 2 days onsite)

Rate: $57.46-$67.04/hr

Advantages
Unprecedented Stability: A 35-month contract provides a rare level of long-term engagement and the ability to steer a major public sector data transformation from start to finish.

Advanced Technology Stack:
Work at the forefront of cloud data engineering, utilizing the full Microsoft Azure suite and Delta Lake architectures.

Collaborative Environment:
Work within a specialized "Special Posting" team that values research, knowledge sharing, and technical excellence.

Responsibilities
Data Pipeline & Architecture
ETL/ELT Excellence:
Design, develop, and document high-performance Azure Data Factory (ADF) and SSIS packages to integrate data from disparate enterprise systems.

Modern Data Stack:
Maintain Azure Databricks notebooks using Python (PySpark) and SQL for both batch processing and real-time streaming workloads.

Medallion Architecture:
Build curated, analytics-ready datasets following the layered Bronze, Silver, and Gold patterns and implementing Delta Lake best practices.

Warehouse Engineering:
Develop complex T-SQL, stored procedures, and views within Azure Synapse and SQL Server 2016+ environments to optimize data retrieval and reporting.

Analytics & Insights
Data Modeling:
Lead the data modeling efforts for the EDW and data lake solutions, ensuring scalability and adherence to enterprise architecture standards.

Business Intelligence:
Develop and maintain sophisticated Power BI reports and dashboards to translate raw data into meaningful, data-driven business insights.

Requirement Translation:
Partner with Business Analysts to convert complex business needs into detailed technical specifications and functional designs.

Governance & Quality
Data Stewardship:
Design and implement rigorous data quality, cleansing, and stewardship processes to ensure the "single version of truth" for enterprise data.

CI/CD & Dev Ops:
Manage the development lifecycle through Azure Dev Ops, ensuring reliable deployments via automated CI/CD pipelines.

Technical Leadership:
Research and propose innovative technical solutions, conduct knowledge transfer sessions, and provide accurate time estimates for enterprise-level initiatives.

Qualifications

Experience:

5+ years of dedicated experience in Data Engineering or Database Development for enterprise-scale solutions.

Azure Mastery:
Expert-level hands-on experience with Azure Synapse (SQL DW), Azure Data Factory, Azure Databricks, and Azure SQL Services.

Programming:
Proficiency in SQL and Python (specifically PySpark for big data processing and automation).

Dev Ops

Skills:

Proven track record of managing projects through Azure Dev Ops and CI/CD pipelines.

Visualization:
Demonstrated experience developing reports and dashboards in Power BI.

Compliance:
Solid understanding of the Ontario Human Rights Code (OHRC) and AODA accessibility requirements.

Education:

University degree in Computer Science or a related quantitative discipline.

Deliverables
Detailed technical designs and functional specifications for the EDW ecosystem.

Unit-tested system components ready for QA and User Acceptance Testing (UAT).

Comprehensive technical documentation and post-implementation support guides.

Optimized data integration packages and regular project status reports.

Summary
If you are a seasoned Data Engineer with a passion for building robust cloud architectures and a talent for turning complex data into strategic assets, we encourage you to apply today!

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and…