Senior Analytics Developer, People Analytics

Senior Analytics Developer, People Analytics BUILD SOMETHING PEOPLE LOVE Wealthsimple's mission is to help everyone achieve financial freedom – by making financial services simple, transparent, and low-cost. We're Canada's largest fintech, trusted by over 3 million clients with more than $100 billion in assets. We move fast, we own our work, and we care deeply about the people using our products. If that sounds like you, keep reading. We're proud of what we've built — and we're just getting started. Read our Culture Manual https://www.wealthsimple.com/en-ca/culture and learn more about how we work https://www.wealthsimple.com/en-ca/careers. 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. What you'll do - 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 Skills you bring - 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 have - 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 Who you are - You're energized by building from scratch, you don't need a well-paved road to do good work, and you're not waiting for perfect requirements before you start - You possess a "product owner" mindset. You don’t just deliver a table. You ensure the end-user understands the data, trusts it, a ... (truncated, view full listing at source)