Analytics Engineer

Join the team redefining how the world experiences design. 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 campus is in Sydney. We also have a campus in Melbourne and co-working spaces in Brisbane, Perth and Adelaide. But you have choice in where and how you work. That means if you want to do your thing in the office (if you're near one), at home or a bit of both, it's up to you.
What you'd be doing in this role The goal of the Finance Analytics Engineer is to support the ongoing development and enhancement of Canva's finance data platform by integrating new data sources from systems such as Accounting, Tax, Procurement, and FP&A, while ensuring the data is immutable, reliable, accurate, and consistent. These qualities are foundational to Canva's reporting needs and internal operations. The role will play an important part in scaling and improving the data platform, with a focus on ingesting and refining data from various business systems.
You will apply best practices in data ingestion, modelling, and management on a daily basis, helping to maintain and operate a well-defined, high-quality, tested, documented, and code-reviewed data platform. You will work collaboratively with the Senior Finance Analytics Engineer and the broader Finance Data team (including the Finance Data Lead and Data Scientists) to understand finance data requirements. Your efforts will help deliver value to the Finance Supergroup through dashboards, insights, reports, and by enabling other systems with relevant data.
Responsibilities Work primarily with SQL and Python to automate and optimise data ingestion and transformation functions that will enable consistency, accuracy and reliability in finance-reported data. Design and build out semantic data models that support operational, analytical and reporting needs that are primarily sourced from our business systems and internal application platforms. Establish and apply data engineering practices to provide clean, consistent and logical data layers in the data warehouse to end users. Maintain, operate, and tune data infrastructure (Fivetran, Snowflake, dbt, Looker, Mode Analytics, Census) at scale. Develop and maintain infrastructure, tools and scalable data ingestion, access and modelling frameworks to support Canva internal user's use case of data warehouse. Apply data management and governance practices to develop, customise and maintain high levels of data quality. Ensure that data is secure and exposed appropriately to respective groups of users. Partner and guide data analysts in efficient and manageable practices to maintain effective data lineage, governance and consistency. Collaborate with other business domain analytics engineers and other stakeholders to embed strong data practices in their relevant domains to meet the needs of big company compliance and relevant SOX controls. You're probably a match if You have at least 3 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, Marketing. You have dimensional data modeling skills specialising in sourcing data from cloud-based ERP, HCM and/or CRM Platforms. You are familiar with a wide set of data warehousing principles, including architecture, DataOps methodologies, modelling approaches, performance/optimisation principles, and data management best practices. You are familiar with data governance and data management principles, with a track record in applying standardisation across disparate datasets and implementing technical controls on data pipelines. You have experience developing dashboards and reporting solutions using BI solutions. You have experience with cloud-based technologies Snowflake, dbt, Fivetran or equivalent. You are familiar with API tools and Automation platforms. You have hands-on experience in using CICD tools, PR processes (Github, Jira, Juniper etc.) Curiosity and self-drive to continuously learn new techniques and tools to extract value from data. You have good written, verbal communication and collaborative skills, ability to design and build using high-level requirements. 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 Please note that interviews are conducted virtually.
#J-18808-Ljbffr

---