Job Description

Kaiwhakawhanake Pātaka Raraunga: Data Warehouse Developer (Senior-level)

Te Amorangi Mātauranga Matua, the TEC - is a small Crown agency with a big job to do - ensuring New Zealanders have the skills and the knowledge they need to build a great life, and ensure New Zealand thrives. We invest over $3 billion annually across the tertiary education and careers systems.

If you're looking for your “why”, then come and join us at TEC. We truly believe in the transformational benefits of education and vocational training and as a result we invest $3 billion a year in tertiary education and training and seek to lift the aspirations and skill bases of all New Zealanders from ages 7 to 74.

It's an exciting time in the careers and education sector with large scale and meaningful change taking place.

He angitūtanga: About the Role

This role reports to the Team Leader - Data/Development, and you will be working within a cross-functional team of Data Warehouse Engineers 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 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 processes
• Completes regular reviews of data pipelines and enhances where necessary
• Uses 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 products
• Plans 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 kōrero mōu: 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:

• 4-5+ years of experience that includes hands-on software development, data engineering, and systems architecture experience
• Experience in developing cloud-based data warehouse solutions and ELT/ETL techniques and processes
• Experience 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 Python
• Good experience with cloud platforms (Azure preferred)
• Experience with version control systems like Github and deployment & CI tools
• Understanding of metadata management, data lineage, and data glossaries is a plus
• Working knowledge of agile development, including DevOps and DataOps concepts

Ngā āhuatanga kei a mātou: What's in it for you

• 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 $111,450 up to $131,125 + 3% KiwiSaver depending on demonstrable skills and experience.

Me pēhea te tuku tono: How to Apply

To 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 05 June 2025.  For more information or if you have any questions, please contact hr@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