Intermediate Data Analyst | 1248533

H2R; Wellington; Hybrid; NZD 90,000 - 120,000; Full time

Job summary

Jora New Zealand is seeking a Data Analyst to dive into technical detail, untangle complex datasets, and build meaningful data models. The role supports modernising a crown agency’s data landscape by migrating from a legacy SQL Server warehouse to a modern data platform, based in Wellington.

You will reverse-engineer the current SQL environment, document data structures and models, and translate findings into clear requirements for the development team.

Qualifications

• Large data migration project experience from SQL
• Experience developing data flow diagrams
• Technical documentation skills

Responsibilities

• Analyse and unpack legacy SQL Server data warehouse
• Reverse-engineer existing data structures, models and relationships
• Produce clear technical documentation for the migration
• Develop data models and data-flow diagrams
• Translate legacy functionality and business requirements for data developers
• Communicate technical findings to developers, testers, product owners and other stakeholders
• Support the first delivery phase of the Modern Data Platform
• Contribute across both project work and business-as-usual activities
• Assist elsewhere within the team when priorities require it

Skills

Data modeling

Technical documentation

Stakeholder communication

Tools

SQL

Job description

Jora New Zealand will close on 16th September 2026. Thank you for being with us, we are cheering you on as you continue your career journey.

We’re looking for a Data Analyst who enjoys diving into technical detail, untangling complex datasets, and building meaningful data models. Join a crucial Crown agency as it modernises its data landscape, helping drive the migration from a legacy SQL Server data warehouse to a modern data platform.

About the role:

You will investigate and reverse-engineer the existing SQL environment, document current data structures and models, and translate these findings into clear requirements for the development team.

Key Responsibilities

• Analyse and unpack legacy SQL Server data warehouse
• Reverse-engineer existing data structures, models and relationships
• Produce clear technical documentation for the migration
• Develop data models and data-flow diagrams
• Translate legacy functionality and business requirements for data developers
• Communicate technical findings to developers, testers, product owners and other stakeholders
• Support the first delivery phase of the Modern Data Platform
• Contribute across both project work and business-as-usual activities
• Assist elsewhere within the team when priorities require it

The right candidate will need…

• Large data migration project experience from SQL
• Experience developing data flow diagrams
• Technical documentation skills

What’s in it for you?

Have the opportunity to make a tangible impact on a major data modernisation programme while working in a collaborative and supportive team environment. You’ll do so within a positive team environment, centrally located in Wellington’s CBD, with flexible working arrangements that encourage a healthy work-life balance.