Data Warehouse Technical Lead

  • Company:
    Govt NZ Jobs
  • Location:
  • Salary:
    negotiable / month
  • Job type:
  • Posted:
    1 month ago
  • Category:
    Govt Jobs
  • Job Type:
  • Category: Information Technology
  • Location: Wellington
  • Date Advertised: 20-FEB-20
  • Job Reference: NZTA/1440031
  • Job Title: Data Warehouse Technical Lead
  • Business Unit:
  • Division:
  • Summary:
  • Lead and develop the technical aspects of our enterprise data warehouse
  • Develop and manage assets for the enterprise
  • Wellington based

About us | Ko wai mātou

At Waka Kotahi, the NZ Transport Agency, it all starts with our people. The organisation’s performance and success depends on the people who choose to make this a great place to work and make a difference for Aotearoa. The Transport Agency has a strong future focus, understanding that new technologies and changing customer expectations mean the transport system we know today will not be the one we deliver in ten years time.

The Workplace and Technology Services Group is accountable for leading, influencing and ensuring that our corporate and transport technologies deliver to business and customer outcomes. The Group is accountable for all cyber and physical security issues, ensuring that the Transport Agency meets its ongoing security and compliance obligations.

The opportunity | Te Whiwhinga mahi

Reporting to the Manager, Enterprise Data Warehouse, as our Data Warehouse Technical lead, you will be responsible for providing leadership and support of data development for the Agency’s enterprise data warehouse platform.

In this role, you will have a primary focus on best practice design and coding within our architecture and leading the development function from a technical perspective. There is also a key focus of being responsible for monitoring the data management within the Enterprise Data Warehouse systems.

If you enjoy working in a team, have a passion for data warehouse and development tools and you want to make a difference, then this is the role for you.

About you | Ko koe tēnei

To be successful in this role, you will bring:

  • Prior experience using data warehousing and development tools, ideally Wherescape (RED and 3D), SQL, SSIS, SSRS, Azure and other cloud tools
  • Significant comprehensive ETL experience
  • Good understanding of data warehouse concepts, data vault knowledge and the ability to work with complex business rules
  • Knowledge of requirements gathering and data analysis with the ability to translate business needs into technical solutions
  • In depth knowledge of data modelling and design including star schema and data vault
  • Analytical and problem solving skills

If you have the interest and passion to perform in this role, we would love to hear from you!

Applications close | Rā Katinga: Thursday 5 March

For a copy of the position description:

For further information, email:

To be considered for this position you must have a legal right to live and work in New Zealand.

NZ Transport Agency is an equal opportunity employer (EOE). At the Agency we recognise the importance of diversity and inclusion and are committed to providing a working environment that embraces these values. Please let us know if you need any support or have any access requirements that will help you through the recruitment process.