Data Analyst - Intermediate level

Tertiary Education Commission; Wellington; On-site; NZD 91,000 - 107,000; Full time

Benefits offered by this job

TEC Days

Flexible working

Wellness programme

Extra leave purchase

Career development

Job summary

The Tertiary Education Commission in Wellington is seeking a permanent Data Analyst to join our Data and Development team. You will help remodel our SQL Server data warehouse for a Databricks-based Modern Data Platform, and document data structures, transformations and business rules for the new solution.

With three to five years of relevant experience, you will analyse source systems, create data flow diagrams, support data modelling and work closely with business users and technical teams to

Qualifications

• Strong SQL skills with ability to read and optimize complex queries.
• Experience in data warehouse analysis and data modelling.
• Ability to document data definitions, transformations and lineage.

Responsibilities

• Analyse existing SQL Server data warehouse structures and processes.
• Read and reverse-engineer stored procedures, views and complex SQL queries.
• Trace data from source systems through to warehouse and reporting outputs.
• Create data flow diagrams, source-to-target mappings and ER diagrams.
• Document data definitions, transformation rules and data lineage.
• Profile data to identify missing values and data quality issues.
• Support data modelling and define data outcomes for testing.
• Collaborate with business users, data architects, developers and testers.

Skills

SQL and data analysis

Data modelling

Data warehouse analysis

Understanding migrations

Communication

Problem-solving

Education

Bachelor's degree in a relevant field

Tools

Azure

Databricks

SQL Server

Job description

Tertiary Education Commission – Wellington Central, North Island

• Use your SQL, data analysis and modelling skills on a major data migration.
• Help redesign an enterprise data warehouse for a modern Databricks platform.
• Join a collaborative data and development team.
• Permanent, Wellington-based role.

The Tertiary Education Commission Te Amorangi Mātauranga Matua (TEC) is a small Crown agency with a big job. We help shape a tertiary education system that equips learners, communities and employers for success.

We invest more than $3 billion each year across the tertiary education and careers systems. Our data supports investment decisions, funding, monitoring and reporting across TEC.

We are looking for a permanent Data Analyst with strong SQL, data warehouse analysis and data modelling skills.

This role is well suited to an analyst who enjoys working with technical detail, complex data and data models.

He angitūtanga: About the Role

You will report to the Data Development Team Lead and join our Data and Development team. The team includes data analysts and data warehouse developers at intermediate, senior and principal levels.

You will initially work on a major data migration project. We are remodelling data from our existing SQL Server data warehouse for our Databricks-based Modern Data Platform.

You will analyse how data currently moves through the warehouse. You will document the data structures, transformations and business rules that the new solution must support.

You will translate high-level business requirements into detailed data requirements and technical documentation. Data warehouse developers will use your documentation to design and build the new solution.

Your work will include:

• Analysing existing SQL Server data warehouse structures and processes.
• Reading and reverse-engineering stored procedures, views and complex SQL queries.
• Tracing data from source systems through to warehouse and reporting outputs.
• Creating data flow diagrams, source-to-target mappings and entity relationship diagrams.
• Documenting data definitions, transformation rules, dependencies and lineage.
• Profiling data to identify missing values, inconsistencies and data quality issues.
• Identifying undocumented business rules and validating them with subject matter experts.
• Supporting logical and physical data modelling, including dimensional and star-schema models.
• Defining expected data outcomes to support testing and reconciliation.
• Working with business users, data architects, data warehouse developers, testers and reporting teams.

These responsibilities align with the intermediate level in the role description, including analysing source systems and warehouse structures, profiling data, documenting requirements and supporting data modelling.

This role will suit someone with around three to five years' relevant experience in data analysis, data warehouse analysis, data modelling or a similar role.

You will have:

• Strong SQL skills, including the ability to understand complex queries, views and stored procedures.
• Experience analysing or reverse-engineering existing data warehouse processes.
• Experience translating high-level business requirements into detailed data requirements.
• Practical experience creating data flow diagrams, source-to-target mappings and entity relationship diagrams.
• Experience documenting data definitions, transformation rules, business rules and data lineage.
• Experience profiling data and investigating missing, inconsistent or poor-quality data.
• Knowledge of data warehouse modelling, including facts, dimensions and star schemas.
• Strong analytical and problem-solving skills, with close attention to detail.
• Clear and well-structured written communication.
• The ability to explain technical information to technical and non-technical people.
• Experience working with business subject matter experts and technical delivery teams.

We will consider the quality and relevance of your experience alongside the number of years you have worked.

Experience with migrations would help

It would be useful if you also have:

• Experience contributing to a data warehouse or data platform migration.
• Experience with Azure or Databricks.
• Experience using data modelling or diagramming tools.
• Experience supporting data testing and reconciliation.
• Python experience for data analysis or profiling.
• Experience working in an Agile delivery environment.

Experience with all our technologies is not expected. A solid foundation in SQL-based analysis, data documentation and data modelling will help you succeed in the role.

• Three additional (TEC Days) leave days.
• A range of benefits including flexible working options, a wellness programme and the ability to purchase extra leave.
• A motivated and supportive manager, keen to make the most of your skill set.
• Reduced premiums through our Health Insurance Group Scheme.
• A focus on Career development and internal opportunities.
• At TEC we are committed to supporting a range of flexible working arrangements to help staff manage their work and personal commitments, we also expect team members to be in the office at least three days per week to help collaboration.

The salary range for this position starts from $90,956 up to $107,007+ 3.5% KiwiSaver depending on demonstrable skills and experience.

The closing date for this role is Monday, 21 September 2026 at 11:59pm. For more information or if you have any questions, please contact **@tec.govt.nz.

Applicants must have the ability to obtain and maintain the legal right to work in New Zealand.

Prior to the Tertiary Education Commission confirming any offer of employment, pre-employment checks will be undertaken including criminal conviction history and reference checking as a minimum.

The TEC is an equal opportunity employer and committed to providing a working environment that embraces and values diversity and inclusion. Your unique talents and experience will help us deliver exceptional services to New Zealand. We look forward to your application