Design and build the data pipelines and transformation models that move raw data from source systems into a centralized data warehouse.
Drive the creation of a canonical employee record with a stable, consistent identifier that survives job changes, rehires, and system migrations.
Own the semantic layer for people metrics: define, document, and maintain agreed-upon definitions for core measures so that HR, Finance, and leadership are always working from the same numbers
Bridge the gap between raw sources and business value. Ensure that data models are not just technically sound, but are purposefully built to answer the specific strategic questions for Wealthsimple
Build slowly-changing dimension patterns and dated workforce snapshots that enable accurate point-in-time analysis.
Establish data governance practices that belong in a people analytics function.
Partner with HR business partners, Finance, and People Operations leaders to translate business questions into well-structured data models and durable analytical solutions
Use AI tools to accelerate your work, drafting pipeline code, generating documentation, stress-testing metric logic, and turning technical findings into clear communication for non-technical partners

Python for pipeline orchestration, data transformation, and scripting
Experience with dimensional modelling, SCD types 1/2/3, and snapshot patterns.
Hands-on experience with dbt or equivalent, including testing documentations and incremental loading patterns.
Pipeline orchestration using Airflow, Prefect, or similar.
Familiarity with cloud data warehousing (Snowflake, BigQuery, or Redshift)
Advanced SQL, including window functions, CTEs, date spine logic.
HR data literacy: employee lifecycle events, job hierarchies, headcount types, and compensation structures
Experience extracting data from various data platforms such as Workday, Ashby, or Greenhouse.
Version control in Git as standard practice.

Top-tier health benefits and life insurance
Long-term group savings with employer match, through Wealthsimple for Business
20 vacation days, 4 wellness days, and unlimited sick and mental health days per year
90 days away: work outside Canada for up to 90 days per year
Employee resource groups, including Rainbow (2SLGBTQ), Women of WS, and Black at WS

Senior Analytics Developer, People Analytics

Key skills