Intermediate Data Analyst

H2R Consulting; Wellington; On-site; 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. You will help modernise a Crown agency's data landscape, migrating from legacy SQL Server to a modern data platform.

The role involves reverse-engineering the existing SQL environment, documenting current structures, and translating findings into clear requirements for the development team. Wellington CBD with flexible working arrangements.

Qualifications

• Large data migration project experience from SQL.
• Data modelling experience.
• 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

SQL data migration

Data modelling

Data flow diagrams

Technical documentation

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
• Data modelling experience
• 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.