Senior Analytics Developer, People Analytics

Wealthsimple Technologies

1d • Hybrid

About The Position

The People Analytics team is a new function. We're standing up the analytical foundation from scratch, and are looking for a Senior level Analytics Developer to join the team to build out this function. You'll be the first members of the People Analytics team, which means you're not inheriting a system: you're designing one. You'll build the pipelines, data models, and quality frameworks that turn raw data into the analytics foundation the business needs. This is a 0-to-1 role that calls for someone who's comfortable with ambiguity, energized by ownership, and serious about doing foundational work well.

Requirements

• 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.

Nice To Haves

• Experience with identity resolution or entity matching — directly relevant to the golden record problem
• Familiarity with survey data platforms such as Qualtrics, Glint, or Culture Amp
• Exposure to workforce planning or headcount forecasting models
• Experience in a regulated or compliance-heavy environment, including familiarity with GDPR, CCPA, EEO reporting requirements

Responsibilities

• 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

Benefits

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed
• Number of Employees: 501-1,000 employees