Data Analyst (Intermediate) — DW Migration on Databricks

New Zealand Government; Wellington; Hybrid; NZD 91,000 - 107,000; Full time

Benefits offered by this job

TEC Days leave

Flexible working options

Wellness programme

Extra leave purchase

Job summary

The Tertiary Education Commission Te Amorangi Mātauranga Matua (TEC) is seeking a permanent Data Analyst in Wellington. You will apply SQL, data warehouse analysis and data modelling on a major migration to a Databricks-based Modern Data Platform.

You will document data structures, transformations and business rules to guide the new solution. You will collaborate with data engineers, business users and QA teams to ensure data quality, lineage and testing support, reporting to the Data

Qualifications

• Strong SQL skills with 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.
• Experience creating data flow diagrams, source-to-target mappings and ER diagrams.
• Experience documenting data definitions, transformation rules and data lineage.

Responsibilities

• Analyse existing SQL Server data warehouse structures and processes.
• Document data definitions, transformation rules, dependencies and lineage.
• Create data flow diagrams and source-to-target mappings.
• Support data modelling, including dimensional and star-schema models.
• Collaborate with business users and data warehouse developers to ensure accurate documentation.

Skills

SQL

Data analysis

Data modelling

Documentation

Stakeholder communication

Tools

Azure

Databricks

Job description

The Tertiary Education Commission Te Amorangi Mātauranga Matua (TEC) is seeking a permanent Data Analyst in Wellington. You will apply SQL, data warehouse analysis and data modelling on a major migration to a Databricks-based Modern Data Platform.

You will document data structures, transformations and business rules to guide the new solution. You will collaborate with data engineers, business users and QA teams to ensure data quality, lineage and testing support, reporting to the Data