Enterprise Data Warehouse Analyst

Enterprise Data Warehouse Analyst

Ara Poutama Aotearoa (Department of Corrections) is seeking an experienced Data Warehouse Analyst to join the Data and Information Product Group.

About the role

The Enterprise Data Warehouse Analyst focuses on analysis of source data for acquisition, modelling the data using the Kimball methodology, and thorough testing before delivering data products used for reports and dashboards to meet the product owner's satisfaction. Additionally creating and enhancing information insights by delivering data visualizations, business analytics, and reports to business customers, product owners, and stakeholders.

In our Data Warehouse team, you will elicit and assess requirements from business users, use data analysis techniques to gather information, and apply innovative thinking to create and test end-to-end solutions from data models to dashboards. You will also provide support and training to end users, help people understand our information through data stories, and work within an agile methodology.

The role is based at National Office in Wellington, however nationwide applications will also be considered for the right candidate.

Skills and experience

Recent experience in some or all of the skills below are key to this role:

• Using Dimensional modelling (Kimball) and producing quality meta-data
• Working closely with the business to produce business rule definitions, and process models.
• Experience using SQL for data analysis and testing
• Oracle products such as OAS (Oracle Analytics Server), or OBIEE (Oracle Business Intelligence Enterprise Edition) for report design and development

A tertiary qualification in IT, Business Management, Statistics or similar relevant discipline is required for this role.

Salary

The mid-point of the salary range is $131,914 per annum and the full range (85%-120%) is $ 112,127 - $158,297 per annum. Appointment and remuneration will reflect skills and experience relevant to the role.

About us

Join Ara Poutama Aotearoa - Department of Corrections, where your work will contribute to improving public safety, reducing re-offending, and address the overrepresentation of Māori in correctional facilities. As a values-led organisation, we use the principles of rangatira (leadership), manaaki (respect), wairua (spirituality), kaitiaki (guardianship), and whānau (relationships) to guide our work and achieve the goals of our Hōkai Rangi strategy.

We value inclusion and diversity in our workforce, and as a Public Service organisation we are committed to building a workforce that reflects the public we serve. We strive to make our recruitment process fair, and we encourage you to discuss reasonable accommodations with us if required.

To submit an application and view the position description, click the apply link. All applications must be submitted through our careers site to ensure transparency – applications received via email will not be considered.

When applying, submit a tailored CV and a cover letter describing your motivation for joining the department highlighting relevant skills and experience and the alignment to our work.

Applications close on: Monday 29 June 2026, 11pm, NZST.

If you have any questions or want to learn more about a career with us, contact View email address on click.appcast.io.