Analytics Engineer - Personalisation
Core
Build, test, and maintain dbt models and Snowflake semantic views to clean, transform, and structure data for product managers, data scientists, and engineers.
Role type
Analytics Engineer (Data Engineering)
Builds
Data pipelines, semantic views, and self-serve analytics infrastructure for Canva's Personalisation team.
Domain
SaaS / Data Engineering
Deliverable
production ML models | product features | dashboards & analysis
Required skills
Advanced SQL, data modeling, event-oriented datasets at scale, Snowflake, dbt, data quality assurance
Preferred skills
Experience with Personalisation admin portals, metrics platform integration
Technologies
dbt, Snowflake, SQL
Responsibilities
Build and maintain dbt models and Snowflake semantic views; integrate PPS admin portal with Snowflake; write SQL for business questions and self-serve analytics; partner with data scientists to define features and signals; scope and translate stakeholder requirements into data work; support onboarding of key metrics into the Metrics Platform; maintain data pipelines for experiment reporting; document data assets; participate in code reviews; investigate and resolve data issues.
Seniority
Mid-level, hands-on IC
