Te tūnga | The role We have an exciting permanent full-time opportunity for a Data Warehouse Modeller to join our Data & Analytics group. Reporting to our Business Intelligence & Analytics Manager, you will be responsible for creating efficient and scalable data models that support the organisation's data warehousing and business intelligence initiatives. In this role, you'll be involved in:

Documenting, reviewing, updating, confirming, and gathering user requirements by engaging with relevant stakeholders for all Business Intelligence related reporting and analytics requests.
Working closely with stakeholders, including architects, business analysts, and data engineers, to translate these requirements into robust and well-structured data models that enable effective data storage, retrieval, and analysis for ESR to maximise the value of our data.
Designing logical, dimensional, and physical data models using industry good practice.
Troubleshooting and problem resolution from an information delivery and consumption perspective, including all systems up-and downstream that impacts the BI environment.

Kia angitu koe | About you To be successful in this role, you will have the following:

A relevant tertiary qualification in Information Communication Technology, Information Systems, or Computer Science.
Experience in data warehousing fundamentals and methodologies.
Knowledge and experience with SQL.
Previous experience in dimensional data modelling and data transformation, such as Kimball.
Familiarity with the data warehouse life cycle.

We are open to hearing from candidates across Aotearoa, including Auckland, Wellington or Christchurch. Ngā painga | The benefits ESR provide an excellent environment for fostering and developing our people in a values-driven, flexible and ever evolving landscape. We are leaders in our field and our laboratory facilities are second to none. We offer diverse benefits including flexible working options that support everyone's lifestyle in balance with their work commitments. Our people gain value from other benefits such as job-related learning and development opportunities, access to employee health schemes, social events and wellbeing initiatives. Tono mai | Apply Now If you have any questions about the role or would like to request a full position description, please get in touch with esr.recruitment@esr.cri.nz. We encourage applications from those with an understanding of or a willingness to develop their capability in Te Tiriti o Waitangi, tikanga Māori, and/or te reo Māori. If you are looking for a chance to meaningfully contribute to the wellbeing of New Zealanders, please apply now. Applications close at 12:00am Monday 29 April 2024. ESR is an equal opportunity employer, and we are committed to providing a working environment that embraces flexibility, diversity, and inclusion. Your unique talents and experience will help us deliver exceptional services to New Zealand. We look forward to receiving your application.

Data warehouse