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 & DevOps: Manage the development lifecycle through Azure DevOps, 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).

DevOps Skills: Proven track record of managing projects through Azure DevOps 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 implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.