Data Engineer - HR/People Analytics

We are seeking a pragmatic and highly skilled HR Data Engineer to lead a critical technical migration within our People Analytics ecosystem. Reporting to the Location Operational Services (LOS) Manager, you will be responsible for transitioning business-critical training compliance pipelines from a fragile, legacy Access/VBA environment to a modern, cloud-native Power BI Fabric platform. This role is essential for ensuring audit and regulatory compliance during a period of organizational transition. If you thrive in fast-paced environments, possess a "detective" mindset for reverse-engineering undocumented logic, and are committed to building maintainable, long-term solutions, we want to hear from you.

Location: Burlington, ON (Hybrid – 2 days onsite)
Contract Duration: 2-month project-focused contract
Rate: $85.65-$101.23/hr

Advantages
Strategic Impact: Play a lead role in modernizing a critical audit-compliance tool for a major organization.

Cutting-Edge Tech: Gain deep, project-based experience in the latest Microsoft Fabric environment.

Collaboration: Work closely with a supportive team during a high-energy, transitional phase.

Extension Potential: Successful delivery of this project opens doors for further data transformation opportunities across the business.

Responsibilities
Legacy Migration: Lead the migration of the Mandatory Training Dashboard. Rebuild the entire data pipeline using Power Query (M language) within Power BI Fabric (Gen2 dataflows and Lakehouses).

Reverse-Engineering: Deconstruct legacy Access macros, VBA scripts, and SQL/Python queries to extract and document buried business logic.

Pipeline Resilience: Implement failover mechanisms and resilient source switching to handle semi-automated exports from SuccessFactors and Cornerstone via SharePoint.

Dimensional Modeling: Design and implement a robust Star Schema optimized for Power BI/DAX, accounting for complex organizational hierarchies and employee master data.

Parallel Development: Ensure the legacy solution remains fully operational while building the new infrastructure in a parallel environment.

Validation & Data Quality: Conduct rigorous reconciliation between migrated outputs and legacy results to ensure 100% data integrity for audit purposes.

Documentation: Create accessible data dictionaries, process maps, and logic documentation specifically designed for non-technical maintainers.

Qualifications
Power BI Fabric (Mandatory): Hands-on experience with Fabric workspaces, Gen2 dataflows, and Lakehouses. This is a non-negotiable requirement for the 2-month delivery timeline.

SQL (Intermediate): Proficiency in writing/optimizing CTEs, joins, and subqueries, with the ability to translate SQL logic into Power Query.

Python (Intermediate): Ability to read and interpret existing Python/Pandas scripts to understand historical ETL workflows.

Power Query (M Language): Minimum foundational awareness with a commitment to building exclusively in Power Query to ensure long-term maintenance by the local team.

Microsoft Access Mastery: Strong ability to navigate and interpret Access tables, queries, and macros for reverse-engineering purposes.

Data Modeling Expertise: Deep understanding of dimensional modeling, including bridge tables and slowly changing dimensions.

SharePoint Integration: Experience using SharePoint as a data layer for file-based ETL workflows.

Soft Skills & Background
Sensitive Data Handling: Prior experience in HR or People Analytics, with a firm understanding of handling highly sensitive and confidential employee data.

Pragmatic Problem Solver: Comfortable with ambiguity and capable of making smart trade-offs to meet tight deadlines.

Communication: Exceptional ability to explain technical logic and status updates to senior leadership and non-technical stakeholders.

Summary
If you are a Data Engineer who enjoys the challenge of "untangling" legacy code and building modern, resilient architecture in the HR space, we encourage you to apply online at www.randstad.ca. Only qualified candidates will be contacted for the next steps. We look forward to hearing from you!

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.