Analytics Engineer - Personalisation at Canva

Sydney, New South Wales, Australia -

Full Time

Start Date

Immediate

Expiry Date

23 Sep, 26

Salary

0.0

Posted On

25 Jun, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL, Data Modelling, Snowflake, dbt, Python, ELT, Data Warehousing, Schema Design, Performance Optimisation, Requirement Gathering, Stakeholder Management, Experiment Reporting, Computational Efficiency, AI Tools, Data Analysis, Code Review

Industry

Software Development

Description

Job Description Join the team redefining how the world experiences design. Hey, g'day, mabuhay, kia ora, 你好, hallo, vítejte! Thanks for stopping by. We know job hunting can be a little time consuming and you're probably keen to find out what's on offer, so we'll get straight to the point. Where and how you can work Our flagship Sydney campus is uniquely Canva - an extension of our Surry Hills neighbourhood. It’s a thoughtfully designed space with plenty of room to collaborate, focus, and connect. This role is based in Sydney, and we’re looking for someone who calls it home. Our hybrid way of working gives you the flexibility to work remotely, and to come together on campus for meaningful in-person collaboration and connection when it matters most. We trust our Canvanauts to choose the balance that empowers them and their team to achieve their goals. What you’d be doing in this role As Canva scales, change continues to be part of our DNA. But we like to think that's all part of the fun. So this will give you the flavour of the type of things you'll be working on when you start, but this will likely evolve. At the moment, this role is focused on Build, test, and maintain dbt models and Snowflake semantic views that clean, transform, and structure data for use by product managers, data scientists, and engineers across Canva Own the integration between PPS (Personalisation’s admin portal) and Snowflake, ensuring the data that lives in PPS is reliably surfaced in our data platform and available for broader analysis and reporting Write clear, well-tested SQL to answer business questions and support self-serve analytics for stakeholders Partner with data scientists and ML engineers to understand their data needs and make sure the right features and signals are available in a usable form Gather and scope requirements from stakeholders across product, data science, and engineering, translating ad hoc requests into well-defined, prioritised data work Support onboarding of key metrics into Canva’s Metrics Platform, ensuring they are consistently defined, well-documented, and accessible across the business Support experiment reporting by maintaining the data pipelines and models that feed Personalisation's dashboards and analysis workflows Document your models and data assets clearly so that others can understand, trust, and build on your work Participate in code reviews and give and receive feedback to maintain quality across the team's codebase Investigate and resolve data issues, working collaboratively with engineers and stakeholders to get to root cause You're probably a match if Your SQL is advanced and your data modelling instincts are sharp; you've worked with event-oriented datasets at scale, across large volumes and diverse schemas, and you know the difference between data that's technically present and data that's actually trustworthy. Experience with Snowflake; including building semantic views and understanding how to model data for broad, self-serve consumption is a strong plus. You understand ELT principles deeply and apply them well, and you're familiar with data warehousing concepts including architecture, schema design, performance optimisation, and best practices. You have Python skills and you feel comfortable using AI tools in your workflows. You have a mindset for computational efficiency, you think about the cost implications of the models you build and look for opportunities to optimise query performance and warehouse spend as a matter of good craft. You've built models and reporting systems that people actually use. Beyond the technical side, you're someone who takes ownership, you're used to tracking and delivering on goals, working both independently and as part of a team. You’re comfortable gathering and scoping requirements from stakeholders across product, data science, and engineering, and translating ambiguous asks into well-defined data work. Most importantly, you're curious and self-driven: you don't wait to be handed the next technique or tool, you go looking for it. About the team Personalisation sits across Canva's Growth and Discovery Supergroups and our goal is to make Canva feel like it was built just for you. We partner closely with product, data science, and engineering to translate user signals into smarter, more relevant onsite experiences. Our work directly influences how millions of people first encounter Canva and how they continue to find value over time. As an Analytics Engineer in Personalisation, you'll be an important part of how we turn raw data into trusted, well-modelled datasets that power our team's most important decisions. You'll work closely with machine learning engineers and data scientists to build and maintain dbt models, support experimentation reporting, and make sure the right data is in the right shape for the people who need it. A key part of this role will be supporting Canva’s messaging orchestration platform ensuring the analytics infrastructure is in place to measure and improve how we guide every user towards value. This is a role for someone who's ready to develop strong fundamentals in data modelling, SQL craft, and analytics engineering best practices, with mentorship and room to grow. Your work will have a direct impact on how the Personalisation team understands its users and measures what's working. What's in it for you? Achieving our crazy big goals motivates us to work hard - and we do - but you'll experience lots of moments of magic, connectivity and fun woven throughout life at Canva, too. We also offer a stack of benefits to set you up for every success in and outside of work. Here's a taste of what's on offer: Equity packages - we want our success to be yours too Inclusive parental leave policy that supports all parents & carers An annual Vibe & Thrive allowance to support your wellbeing, social connection, office setup & more Flexible leave options that empower you to be a force for good, take time to recharge and supports you personally Check out lifeatcanva.com for more info. Other stuff to know We make hiring decisions based on your experience, skills and passion, as well as how you can enhance Canva and our culture. When you apply, please tell us the pronouns you use and any reasonable adjustments you may need during the interview process. We celebrate all types of skills and backgrounds at Canva so even if you don’t feel like your skills quite match what’s listed above - we still want to hear from you! Please note that interviews are conducted virtually. Recruitment type: Permanent

Responsibilities

Build and maintain dbt models and Snowflake semantic views to structure data for product managers, data scientists, and engineers. Partner with stakeholders to translate business requirements into scalable data pipelines and support experimentation reporting.