Associate Solution Architect - Data

About the role

Fonterra is expanding its oCFO Data & AI team, which aims to automate and augment finance with data and AI through data product development and AI pilots. It is hiring an Associate Solution Architect – Data in Auckland, a hands-on role that turns finance and business requirements into well-designed data solutions. You will work alongside experienced Solution Architects and the wider Data & AI team.

Key responsibilities

• Use SQL and Databricks to investigate and profile source data
• Build and maintain data models and ERDs
• Develop source-to-target mappings and support data reconciliation, quality and lineage
• Work with Data Engineers and BI teams so data products follow agreed designs
• Develop capability in dimensional modelling, data warehousing, Databricks, finance data and semantic modelling

Required profile

• A technically curious data professional who enjoys details and problem-solving
• Experience in data analysis, BI development, analytics engineering, data warehousing or data modelling, moving toward end-to-end data solution design
• Comfortable using SQL to explore and validate data
• Interest in building robust, reusable data models rather than just reporting fixes
• Eager to learn from experienced practitioners, take feedback and take greater ownership of data design

Required skills

• SQL
• Databricks
• Data modelling and data warehousing

What we offer

• Fair and equitable pay
• Health and well-being programs (medical and mental health support)
• Professional development and career growth support
• Flexible or hybrid working where possible
• Employee recognition and support for community involvement and cultural connection