Lead Data Warehouse Developer

Help shape the future of Education
  
We work to  shape  an  education  system that delivers  equitable  and  excellent outcomes
  
Our organisation is made up of talented and committed people around Aotearoa, from a wide range of backgrounds and cultures. While we work in different groups and on different things, we all strive every day to make the biggest difference we can for our students in our education system.
  
About this role | Mō tēnei tūranga
  
We have an exciting opportunity for an experienced Lead Data Warehouse Developer to join a high-impact team supporting the Ministry’s enterprise data platforms. This role is central to the design, development, and evolution of our data warehousing and business intelligence solutions that underpin data and insights across the education sector. This is a core Data Warehousing team with the opportunity to define ways of working and ensure collaboration occurs across both Data and Digital Delivery. Supported by Digital Practices, the team plays a key role enabling greater use of data for Ministry, the schools, and our learners. 
  
Salary range:  $118,371 - $143,760 per annum + 3% kiwi saver.  The successful candidate will be appointed at a salary which reflects individual skills and experience.
  
For more details about the role, you can view the Job Description for   Lead Data Warehouse Developer online at: https://assets.ministrycareers.education.govt.nz/June%202025/Lead%20Data%20Warehouse%20Developer%20-%20TPR%20-%20June%202025%20(1)%20(1).pdf
   
About you | Mōhou ake
  
You will demonstrate knowledge of, or a willingness to gain an understanding of Te Ao Māori and promote tikanga and Te Reo Māori. You will also have knowledge of, or a willingness to gain an appreciation of te Tiriti o Waitangi (the Treaty of Waitangi) as it applies in the public sector.
  
To be successful in the role, you will bring

• Prior experience within the New Zealand Government would be an advantage but not essential.
• Proven experience leading and guiding data warehousing teams through complex problem-solving.
• Proven ability to collaborate across teams and with stakeholders to translate business needs into effective technical solutions.
• In-depth knowledge of database and data warehouse design concepts with demonstrated experience in Ralph Kimball and data vault data warehouse approaches.
• Extensive use of SQL and ETL tooling, such as SSIS and BimlFlex.
• In-depth knowledge of relational databases, with the ability to perform normalisation and denormalization.
• Extensive experience in data analysis, modelling and reporting.
• Proven ability to critically analyse complex information to make effective decisions ad recommendations.
• An understanding of data management principles, such as Data Quality, Reference Data, MDM, Metadata Management.
• The ability and willingness to adhere to the Public Service Standards of Integrity and Conduct.

• Operating a secure, resilient digital environment for the Ministry, including networks, devices, tools, and data infrastructure.
• Managing digital services that support the education sector’s funding, enrolment, assessment, identity, and school network needs.