Marketing Data Analytics Engineer building Salesforce, Marketo, and warehouse pipelines for PointClickCare’s healthcare analytics platform. Automating campaign reporting and supporting marketing - sourced pipeline insights.
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 Analytics Engineer designing Lime’s finance - grade data warehouse and semantic layer. Ensuring governed, audit - ready reporting for the global shared micromobility business.
Analytics Engineer building Snowflake and dbt data platforms for Tucows’ Internet businesses. Applying AI, SQL, Looker, and Python to drive data - informed decisions.
Senior Analytics Engineer designing financial, GTM, and product data models for Lightspeed’s cloud commerce platform. Owning pipelines, documentation, and analytics foundations used across the business.
Senior Analytics Engineer building scalable data pipelines and AI - native analytics foundations at Mercury, a fintech company. Supporting agentic tooling, self - service analytics, governance, and data products.
Senior Analytics Engineer shaping Fleetio’s fleet - management data platform. Building dbt models, semantic layers, dashboards, and AI - enabled analytics solutions.
Senior Business Systems Analyst modernizing Boeing Canada’s defence sustainment systems and cloud data platforms. Translating mission needs into requirements, analytics, integrations, and reporting solutions.
Senior Analytics Engineer building GTM pipelines, metrics, dashboards, and AI data tools. Supporting Motive’s platform for safer, more productive physical operations.
Data Analytics Engineer building trusted SQL data systems for Toptal, a global talent network. Owning transformation, governance, warehousing, and AI - enabled analytics foundations.
Analytics Engineer building dbt models, AI - ready datasets, and Tableau reporting for Movable Ink’s content personalization platform. Translating stakeholder needs into trusted metrics and business intelligence.