Solution Architect - Data

Fonterra; Auckland; Hybrid; NZD 150,000 - 220,000; Full time

Benefits offered by this job

Flexible/hybrid work

Health benefits

Career development

Global impact through data initiatives

Job summary

Fonterra is hiring a Solution Architect – Data to turn complex Finance and business requirements into scalable, reusable data solutions. You will work with source data using SQL and Databricks to model, map, and ensure data quality, collaborating closely with Data Engineers and BI teams.

You’ll provide technical guidance, design support, and help raise standards while owning technical work and solutions end-to-end in a hands-on, non-managerial role.

Qualifications

• Hands-on data engineering and modelling experience.
• Strong SQL and data integration skills.
• Experience with data governance and data quality.
• Translate business requirements into scalable data solutions.

Responsibilities

• Turn complex Finance and business requirements into scalable data solutions.
• Design conceptual, logical, physical and dimensional models.
• Develop source-to-target mappings and collaborate with Data Engineers and BI teams.
• Provide technical guidance to Associate Solution Architects and others.

Skills

SQL

Databricks

Data modeling

Data governance

Tools

Databricks

ERD design

Dimensional modeling

Job description

At Fonterra Te Mātāpuna, we want everyone to feel they can be themselves.

Whether you're early in your career or ready for your next step, Fonterra offers a unique opportunity to grow with a global dairy co-operative that values care, collaboration, and contribution.

Owned by New Zealand dairy farmers and supported by a dedicated team, we are all working together to create a better future. Imagine tomorrow with us, where your career can grow, and you can create positive change.

Fonterra as one of New Zealand’s leading companies has made significant and ongoing investments into Data & AI as we continue to build for our future. As part of this journey, we have recently made a significant investment into the oCFO Data & AI team.

The vision for oCFO Data & AI is to ‘automate and augment finance with Data & AI’, which we have been progressing via a roadmap of data product development and selective AI POC’s. Building on success, we are now increasing team capability in data governance, data architecture and product design, and AI. As we expand our team, we are looking to hire a Solution Architect – Data.

About the Opportunity | Mō tēnei tūranga

As a Solution Architect – Data, you’ll be a hands‑on technical practitioner responsible for turning complex Finance and business requirements into practical, scalable and reusable data solutions.

You’ll work directly with source data, using SQL and Databricks to understand structures, relationships and data quality; design conceptual, logical, physical and dimensional models; develop source-to-target mappings; and work alongside Data Engineers and BI teams to ensure solutions are implemented as designed.

You’ll also provide technical guidance and design support to Associate Solution Architects and other delivery team members, helping solve complex modelling and data challenges and improving our standards and ways of working. This is a technical guidance role rather than a people‑management role, with both Solution Architect and Associate Solution Architect roles forming part of the wider Data & AI team.

This is an opportunity to combine hands‑on data engineering and modelling expertise with solution design, helping build trusted, reusable Finance data products that support analytics, reporting and emerging AI use cases.

You’re an experienced data professional who enjoys staying close to the data and solving complex problems hands‑on.

You’re equally comfortable writing SQL and profiling source data as you are building an ERD, designing a dimensional model, defining source‑to‑target mappings or working through requirements with Finance stakeholders.

You understand that good architecture is not just about producing designs. You’re prepared to work through the detail, test assumptions against the underlying data and partner closely with Data Engineers and BI teams to ensure the solution works in practice.

You’ll also enjoy sharing your experience with others, providing practical technical guidance and constructive design feedback while continuing to own and deliver technical work yourself.

At Fonterra, our values of Good Together, Better Every Day, and Every Drop Counts, are for everyone – no matter your background, identify or experience. These values guide us in delivering exceptional outcomes for our farmers, customers, communities, and each other. Discover how your values align with ours by taking our Values Quiz

We care for our people globally. Our comprehensive benefits support your well‑being, development, and work‑life balance:

• Fair and equitable pay
• Health and well‑being programs (medical, mental health support)
• Work‑life balance options (flexible/hybrid working where possible)
• Employee recognition
• Support for community involvement and cultural connection

At Fonterra, we are inspired by purpose and guided by our principles and values. Together, we create goodness for generations and make a global impact at a local level. As part of our Co‑operative, you are an everyday creator, imagining what Fonterra, dairy, and you can be here.

Does this sound good to you? Come join our whānau - bring your whole self, and let's solve for better together.

Together, we're shaping a future of inclusion | He Wāhi mō te Katoa

Inclusion is key to our Co‑operative. We're building a team that reflects the diverse world we live in, believing it drives better decisions and innovation.

We welcome applications from all backgrounds (ethnicities, genders, identities, orientations, ages, abilities, neurotypes, cultures, religions).

If you face accessibility issues or need accommodations during the process, please contact your recruiter. We ensure fair participation, allowing you to be at your best. Tātou, tātou.