Analytics Engineer - IT Group

Canva’s Commitment and Mission
At Canva, we celebrate diversity. We deeply believe that bringing together diversity of thoughts, perspectives and expression is key to building the best product, team and company. We look for many different skills and abilities, as well as how you can enhance Canva and our culture. So, even if you don’t think you quite meet all of the skills listed or tick all the boxes, we’d still love to hear from you! 
Our mission at Canva is to empower the world to design and since launching in 2013, we have grown exponentially, amassing over 86 million monthly active users across 190 different countries and a team of over 3,000 people… and the best bit is that we’ve only achieved 1% of what we know we’re capable of. 
Join us and design your future.
Canva IT group manages relationships with internal customers (Canva Specialities) and oversees the complex series of technologies that support Canva’s business operations. The goal of an Analytics Engineer in IT is to build foundational data capabilities that underpin Canva’s business operations supporting growth, and design holistic data solutions that empower Canvanauts to discover insights from business systems and internal applications.
The Analytics Engineer applies business modelling, software engineering, and data management best practices on a daily basis. Their purpose is to establish, maintain and operate the data platform to deliver well-defined, transformed, tested, documented, and code-reviewed data sets. 
We handle billions of rows and petabytes of data from hundreds of different sources - including events, databases, and third-party systems. We work in collaboration with multiple teams and stakeholders to support their decision-making process. We work every day to make Canva one of the most valuable companies in the world and to do the most good along the way. We are looking to grow our team and multiply our impact.

Responsibilities

• Design and build out data models that support operational analytical and reporting needs that are primarily sourced from our business systems and internal application platforms.
• Apply software engineering practices to provide clean data sets from the data warehouse to end-users.
• Work primarily with SQL and Python to automate and optimise data loading and transformation systems.
• Maintain, operate, and tune data infrastructure (Fivetran, Snowflake, Redshift, dbt, Looker, Mode Analytics, Census) at scale.
• Develop infrastructure, tools and scalable data ingestion, access and modelling frameworks to support Canva internal user’s user case of data warehouse.
• Apply data management and governance practices to develop, customize and maintain the data quality execution. Ensure that data is secure and exposed appropriately to respective groups of users.

Requirements

• At least 5 years of hands-on experience in designing and developing end-to-end cloud data warehouse solutions for internal-facing business domains, eg Finance, People, Sales, and Marketing.
• Advanced dimensional data modelling skills specialising in sourcing data from cloud-based ERP, HCM and CRM platforms.
• Familiarity with a wide set of data warehousing principles, including architecture, methodologies, schemas, performance/optimisation principles, and best practices.
• Good Data Governance and Data Management knowledge, track record in applying standardisations and implementing technical controls on data pipelines.
• Experience developing dashboards and reporting systems using BI solutions.
• Experience on cloud-based technologies Snowflake, Dbt, Fivetran or equivalent.
• Familiarity with API tools and Automation platforms.
• Hands-on experience in using CI/CD tools, and PR processes (Github, Jira, Juniper etc.).
• Curiosity and self-drive to continuously learn new techniques and tools to extract value from data.
• Good written, verbal communication and collaborative skills, ability to design and build using high-level requirements.
• Experience owning, tracking, and delivering goals, working both independently and in teams.

Working at Canva 
Our culture is unlike anywhere else and we design your #CanvaLife experience to empower you to do the best work of your life.  
Whether you’re in the office, working from home or choosing your own adventure, our benefits for permanent Canvanauts include: 
• Equity packages for you to truly be a part of the Canva journey.  • We have a hybrid work model (in-office & from home), so while our offices are always open to you, we aim to come together for 8 days a year at minimum - balancing flexibility and connection • Flexible leave so you can recharge, give back, support others or focus on your own professional development. • Inclusive parental leave policy that supports all parents and carers throughout their parenting and caring journey. • An annual Vibe & Thrive allowance. This is for you to spend on whatever will support your wellbeing and development.. because you know what you need to Vibe and Thrive, better than anyone. • Virtual and in-office wellness benefits including Canva University, Employee Assistant Programs and Fitness & Meditation Classes. • Canva For Good program matching your not-for-profit donations, Force for Good leave (3 paid volunteering days) and a range of sustainability and ethical initiatives to get involved in.   
We make hiring decisions based on your experience, skills and passion. Please note that interviews are conducted virtually. When you apply, please tell us the pronouns you use and any reasonable adjustments you may need during the interview process.