Data Migration Analyst - Flexible SQL Data Platform

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 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.