Senior Data Engineer – Special Posting

We are seeking a highly skilled Senior Data Engineer for an extensive 35-month contract to lead the design and evolution of enterprise-level data architectures. In this role, you will be responsible for modeling, developing, and maintaining a robust Enterprise Data Warehouse (EDW), data lakes, and data marts. You will play a critical role in building analytics-ready datasets and business intelligence solutions that drive data-informed decision-making for a major transit organization.

Duration: 35-month contract

Location: Toronto, ON (Hybrid – Minimum 2 days onsite)

Rate: $57.46-$67.04/hr

Advantages
Unmatched Stability: A 35-month contract provides rare long-term stability and the opportunity to lead a project from foundational design to mature operation.

Enterprise Scale: Work on a massive transit data ecosystem, solving complex data problems that impact millions of users.

Modern Cloud Stack: Deepen your expertise in the full Azure data suite, including Delta Lake, PySpark, and Synapse.

Strategic Role: Move beyond simple coding to help model the enterprise data strategy and deliver actionable business intelligence.

Responsibilities
Data Architecture & Pipeline Development
Enterprise Integration: Design, develop, and document Azure Data Factory (ADF) and SSIS packages to integrate complex data from multiple source systems.

Modern Data Stack: Build and maintain Databricks notebooks and jobs using Python (PySpark) and SQL for both batch and streaming workloads.

Layered Data Design: Implement curated, analytics-ready datasets following the Medallion Architecture (Bronze, Silver, Gold layers) and Delta Lake best practices.

Database Engineering: Develop complex T-SQL, stored procedures, views, triggers, and indexes to optimize performance within Azure Synapse and SQL Server environments.

Analytics & Business Intelligence
Insight Generation: Conduct advanced data analysis to provide meaningful, data-driven insights to business stakeholders.

Visualization: Develop high-quality Power BI reports and dashboards to visualize key performance indicators and operational metrics.

Modeling: Assist in the data modeling of the data warehouse/data lake solutions to ensure scalability and alignment with business requirements.

Governance & Quality
Data Stewardship: Design and implement rigorous data quality and cleansing processes to ensure the integrity of the enterprise data assets.

CI/CD Excellence: Manage the end-to-end development lifecycle using Azure DevOps pipelines to ensure reliable and automated deployments.

Technical Leadership: Convert business requirements into detailed technical specifications, provide accurate time estimates, and conduct knowledge transfer sessions for the team.

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

Azure Mastery: Hands-on expertise with Azure Synapse (SQL DW), Azure Data Factory, Azure Databricks, and SQL Server 2016+.

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

DevOps: Proven experience implementing CI/CD pipelines using Azure DevOps.

Visualization Tools: Demonstrated experience developing reports in Power BI.

Education: University degree in Computer Science or an equivalent combination of education and experience.

Core Skills: Expert understanding of DW/BI implementations, data lake design, and data stewardship techniques.

Deliverables:
Detailed technical design and functional specifications.

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

Comprehensive technical documentation and post-implementation support.

Regular status reports and project timeline estimates.

Summary
If you are a seasoned Data Engineer with a passion for building scalable, high-quality data products on the Azure platform, 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.