Senior Software Engineer focusing on building, operating, and extending systems for Affirm's data infrastructure. Responsible for core platform reliability and data access across teams.
About the role
- 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
Job title
Job type
Experience level
Salary
Degree requirement
Tech skills
Location requirements
Report this job
Found something wrong with the page? Please let us know by submitting a report below.
Senior Backend Engineer guiding the design and development of a unified data collection platform for GitLab. Building and maintaining systems to provide insights into customer usage patterns across GitLab's services.
Data & Analytics Engineer at Prophix building a data platform on Snowflake. Collaborating with finance teams and engineering data architectures for analytics and AI capabilities.
Analytics Engineer for Narvar focused on building data infrastructure and enabling internal analytics. Collaborating with stakeholders to deliver metrics, models, and self - serve analytics solutions.
Analytics Engineer developing data environments using modern technologies for clients at Cuesta Partners. Collaborating on solutions and supporting data - driven business decisions.
Senior Analytics Engineer at Forward Financing designing and optimizing data architecture and models. Collaborating with cross - functional teams to deliver AI - ready data insights.
Lead Analytics Engineer leading technical initiatives in a financial technology company focused on AI - ready data insights. Collaborating across teams to enhance the data ecosystem while mentoring engineers.
Manager of Analytics Engineering at fintech company optimizing data infrastructure for trusted AI insights. Overseeing a team to build centralized data foundation and support various business functions.
Support Engineer responsible for operational support of data analytics and cloud technologies at Sun Life Financial. Collaborate with project teams to enhance and maintain data processes.
Data & Analytics Intern/Co - op at Kinaxis modernizing data ecosystems and developing data solutions. Gain hands - on experience in data integration, engineering, modeling, and business intelligence.