Senior Data Warehouse Developer

New Zealand Government; Wellington; On-site; NZD 111,000 - 131,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 (TEC) of New Zealand is seeking a senior Data Warehouse Developer to join our Wellington-based Data/Development team, delivering modern data pipelines and cloud data products using Azure Data Factory and related tools.

You will design, implement and maintain complex data solutions, lead peer reviews, mentor junior staff, and ensure security, compliance and cost‑efficient operation while collaborating with cross‑functional teams to drive insights for education

Qualifications

• 5+ years of hands-on software development, data engineering and systems architecture.
• Experience building cloud-based data warehouse solutions with ELT/ETL techniques.
• Strong SQL optimization and performance tuning.
• Experience with Python for data pipelines and data products.
• Good knowledge of Azure cloud platform; familiarity with GitHub and CI tools.

Responsibilities

• Designs, implements and maintains complex data engineering solutions for data acquisition and presentation.
• Leads design and development of cloud data products with scalability, cost optimisation and security in mind.
• Mentors junior staff and leads peer review processes.
• Reviews data pipelines and improves performance; ensures data standards and security compliance.

Skills

Data engineering

SQL optimization

Python

ETL/ELT

Cloud platforms

Tools

Azure Data Factory

GitHub

CI/CD pipelines

Job description

An exciting senior-level opportunity to be an integral part of a key data platform modernisation programme of workWork on modern tools and technologies such as Databricks and Azure Data FactoryPermanent, wellington-based role in a modern office spaceAt the Tertiary Education Commission (Te Amorangi Matauranga Matua), we are here to create a dynamic tertiary education system that delivers lifelong learning and equips learners, communities, and employers for success.Our vision is a resilient, prosperous New Zealand where every person has the skills, knowledge, and confidence to thrive. Learn more at www.tec.govt.nz.Permanent role in our Data/Development team based in Wellington.He angitutanga: About the RoleThis role reports to the Team Leader Data/Development, and you will be working within a cross-functional team of Data Warehouse Developers and Data Analysts. You will be providing senior-level leadership across the team for all aspects of what we do, from designing and developing data pipelines, to ensuring continuous improvement by optimising existing workloads. You'll be empowered to lead and be looked to for guidance and mentorship.Designs, implements and maintains complex data engineering solutions to acquire, prepare and present data.Contributes to the design and development of cloud data products, designing with scalability, cost optimisation and security at the centre.Uses extensive experience in development practices, including developing python classes and executables to build data products.Leads peer review processesCompletes regular reviews of data pipelines and enhances where necessaryUses extensive experience in dimensional data modelling, extensive knowledge of SQL, and deep understanding of database full lifecycle designing and application development.Leads the selection and development of data engineering methods, tools and techniques.Develops organisational policies, standards, and guidelines for the development and secure operation of data services and productsPlans and leads the development of data engineering solutions ensuring that solutions balance functional and non-functional requirements.Monitors application of data standards and architectures including security and compliance.Provide technical mentorship and guidance to more junior staff.He korero mou: What we are looking for:This is a great opportunity for an experienced senior-level Data Warehouse Developer looking for opportunities to work on exciting, meaningful projects that have an impact on the education sector. If your skills are developing and you are looking for an opportunity to grow into a senior role, we would still welcome your application.The position holder will have:5+ years of experience that includes hands-on software development, data engineering, and systems architecture experienceExperience in developing cloud-based data warehouse solutions and ELT/ETL techniques and processesExperience building efficient data pipelines, and integrating disparate data sources and types, including high volume semi-structured and unstructured data (e.g., JSON, etc.)Advanced skills in SQL optimization and performance tuning, and development experience in programming languages like PythonGood experience with cloud platforms (Azure preferred)Experience with version control systems like Github and deployment & CI toolsUnderstanding of metadata management, data lineage, and data glossaries is a plusWorking knowledge of agile development, including DevOps and DataOps conceptsNga ahuatanga kei a matou: What's in it for youThree additional (TEC Days) leave daysA 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 setReduced premiums through our Health Insurance Group SchemeA focus on Career development and internal opportunitiesAt 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 $111,456 up to $131,125 + 3.5% KiwiSaver depending on demonstrable skills and experience.Me pehea te tuku tono: How to ApplyTo view the job description and/or apply for the role, please click Apply For This Job or visit the TEC Careers Portal.If this sounds like you, please apply now for this great opportunity with your tailored Cover Letter and CV, we welcome your application.The closing date for this role is 11:59pm 30 October 2026. For more information or if you have any questions, please contact [e-mail] 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