Senior Analytics Developer building analytical foundation from scratch for People Analytics at Wealthsimple. Designing data pipelines and ensuring data governance practices are in place.
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
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.
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
Senior Analytics Engineer building complex data models and insights at Coconut Software. Mentoring team members and supporting data - driven business strategies with advanced analytics.
Senior Analytics Engineer role at Fullscript focused on enabling self - serve analytics. Collaborating across teams to design solutions that improve data accessibility and usage.
Analytics Engineer shaping business intelligence for retail analytics at Arc'teryx. Collaborating to craft and refine reports, impacting vertical retail division performance.
Analytics Engineer Associate at Teragonia designing and developing advanced analytics for private equity clients. Collaborating closely with clients and team to deliver tailored solutions.
Engagement Manager leading a team of analytics engineers to develop advanced analytics solutions for private equity clients in Toronto. Driving value creation through innovative insights and strategic analytics.
Senior Marketing Analytics & Tagging Specialist contract at top Canadian bank. Own enterprise tagging, implement Adobe/GTM, lead analytics implementations in hybrid role.
Principal managing analytics engineering projects for private equity, leveraging AI technology. Leading cross - functional teams and contributing to business development in a hybrid work environment.
Senior Analytics Engineer responsible for managing data architecture at Grafana Labs. Collaborates with stakeholders to optimize data processes in a remote - first environment.
Prototyping analytical tools developed by the engineering and analytics teams for Clir Renewables. Collaborating on automation scripts and methods for renewable energy analysts.
AI & Analytics Engineer I at Finning tasked with developing data models and AI agents. Collaborating with senior engineers and supporting Analytics Engineering initiatives.