Data Analyst - SQL & Data Warehouse Migration to Databricks

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

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