Analytics Engineer

Southern Cross; Auckland; On-site; NZD 110,000 - 170,000; Full time

Benefits offered by this job

Wellbeing leave

Health insurance

Employee assistance programme

Professional development support

Volunteer & community days

Job summary

Southern Cross is building a new Data & AI function in Auckland. We’re seeking an Analytics Engineer to design, build and maintain dbt models that transform raw data into analytics-ready datasets used daily by the business.

You will work with data engineers, analysts and stakeholders to deliver fit-for-purpose data products, leverage Snowflake, dbt, Git, CI/CD, and support Power BI reporting while embedding quality and governance across the data stack.

Qualifications

• Experience building analytics solutions with Snowflake and dbt.
• Strong SQL and data modelling knowledge, including dimensional modelling.
• Experience with Git, CI/CD and engineering practices.

Responsibilities

• Design, build and maintain analytics data models using dbt and Snowflake.
• Develop scalable, performant data models and documentation.
• Collaborate with data engineers and analysts to meet requirements.
• Support Power BI and other reporting tools with curated data.
• Ensure data quality, lineage and governance across datasets.

Skills

Snowflake

dbt

SQL

Git

CI/CD

Data modelling

Power BI

Data quality

Team collaboration

Education

Bachelor's degree in IT/Computing

Tools

Snowflake

dbt

Power BI

Job description

About us

Southern Cross Health Insurance is shaping a healthier Aotearoa New Zealand. Our purpose is simple: empowering our members to live well for longer. We're here to give peace of mind through timely access to quality care, inspire healthier living, and lead positive change across the health system. As a New Zealand-owned, member-based organisation, we're building a future where wellbeing is at the heart of everything we do -- delivering exceptional value for our members and creating an environment where our people thrive.

Now is an exciting time to join us. You'll be part of a high-performing, values-driven team where people are at the heart of everything we do -- and in return for your talent, you'll have the opportunity to grow, make an impact, and be proud of the difference your work makes.

About the role

Southern Cross is guided by purpose, powered by people and technology. We’re here to help almost one million members across Aotearoa New Zealand live well for longer - work with real scale, real responsibility, and a real opportunity to make a meaningful difference.

As we grow to be about assurance as well as insurance - a more proactive partner in our members’ health - we’re building a new Data & AI function from the ground up. We’re looking for an Analytics Engineer to help build the trusted, well-modelled data that everything else in the function depends on.

This is a technical role for someone who wants to get hands‑on with how data flows through an organisation: building the models, applying good engineering practice, and turning raw data into datasets people can trust and act on.

About the role

Reporting into the Innovation & Advanced Analytics Lead, you’ll design, build and maintain the dbt models that transform raw data into the analytics‑ready datasets the business runs on - the layer between the data warehouse and the people who use it every day.

You’ll work closely with data engineers to structure source data effectively, and with analysts and business stakeholders to understand requirements and deliver fit‑for‑purpose solutions - supporting Power BI and other reporting tools with curated, governed datasets.

This function is still being built, so you’ll help embed good practice as it grows - testing, documentation, lineage and code review - while exploring new capabilities across Snowflake, dbt and the wider modern data stack.

What you’ll do

• Design, build and maintain analytics data models using dbt and Snowflake

• Develop incremental and dimensional models that are scalable, performant and easy to understand

• Apply software engineering practices, including Git, code reviews, CI/CD and automated testing

• Monitor data quality and investigate issues to keep our data assets trusted and reliable

• Optimise Snowflake storage and compute usage to balance performance and cost

• Create and maintain documentation, metadata and lineage for data products

• Collaborate with data engineers to ingest and structure source data effectively

• Partner with analysts and business stakeholders to understand requirements and deliver fit‑for‑purpose solutions

• Support Power BI and other reporting tools with curated, governed datasets

• Build trusted data products that power advanced analytics and AI solutions

What you’ll bring

• Experience building and maintaining analytics solutions using Snowflake and dbt, or other equivalent tools

• Strong SQL skills and a solid understanding of data modelling principles, including dimensional modelling and medallion architecture

• Experience with Git-based development, CI/CD and software engineering practices

• The ability to translate business requirements into scalable, reusable data products

• Strong problem‑solving skills and attention to detail

• A curious, continuous‑learning mindset - always looking to improve quality, speed and simplicity

• A collaborative style that values knowledge sharing and team success

• Commitment to quality, documentation and operational excellence

• The ability to communicate technical concepts clearly to technical and non-technical audiences

Why join us

We’re investing - in people, in technology, and in the mission. We're taking a long-term view - investing in our foundations, our people, and the capabilities that will shape the future of healthcare. You’ll join a growing team with the mandate and the tools to genuinely shape data and AI practice at scale.

We’re building something worth joining. Our teams are growing, our employer brand is gaining real traction in market, and the way we show up for our members and each other is being noticed. This momentum has also been reflected externally - in 2026, Southern Cross placed 8th in the Kantar Corporate Reputation Index and 5th in New Zealand for Trust.

Who we are

Ngākau nui. Āhurutanga. Tikanga.

Join a proud, diverse team that’s always there, always real, always true. If you thrive in a caring, honest and open culture, we think you’ll love working with us.

We know our team’s culture and wellbeing drive us forward. That’s why we prioritise not only professional development but opportunities to thrive personally. We offer exceptional work/life balance, and our people are encouraged - and rewarded - for living well.

Southern Cross employee benefits include:

• Five days of wellbeing leave per year

• Health insurance for you and your immediate whānau

• Life insurance cover and discounts on pet and travel insurance

• Extra parental leave benefits and financial wellbeing support

• Participation in our workplace wellbeing programme

• The option to purchase flexi leave for study, volunteering, or supporting your whānau

• An annual volunteer day to contribute to a cause with your team

This role is Auckland based. While we appreciate interest from candidates in other locations, we’re unfortunately not able to consider remote options. Have questions? Check out our FAQs for help with the application and recruitment process.

We are proud to have taken the Pride Pledge, reflecting our commitment to inclusion and belonging. We also facilitate an active, employee‑led Diversity, Equity and Inclusion Forum, which includes our Rainbow Network, Māori Network, Pasifika Collective, and Neurodiversity and Whānau Support networks.

If you share our commitment and passion, we'd love to hear from you.