Enterprise Data Warehouse Developer

1 month ago

Wellington, New Zealand New Zealand Government Full time

The Data and Information Product Group are on the lookout for experienced Data Warehouse Developers

If you are passionate about data and information, this might be the opportunity for you. Join our digital whānau and support a variety of meaningful projects.
- One permanent full-time position.
- Two fixed term positions to June 2027.
- All positions are based in Wellington at National Office.
- Opportunity to grow within a fun, collaborative and dynamic team.

**Ngā kawenga | About the role**

The Enterprise Data Warehouse (EDW) is responsible for providing key data assets, reports, and insights to a variety of users and external agencies.

As the Enterprise Data Warehouse Developer, reporting to the Technical Lead Development, you will be instrumental in developing and supporting the EDW. Your role includes build and support of ETL processes, supporting business continuity through timely defect resolution, and monitoring SQL and PL/SQL performance. You will participate in design reviews, work closely with EDW Analysts to refine business requirements, and develop solutions per specifications and standards. You will be able to work autonomously, be proactive in identifying potential improvements, possess great communication skills and have a drive to construct, robust, high performing and easily maintained solutions.

**Ngā pūkenga me ngā wheako | Skills and experience**

To succeed in this role, you will have:

- Experience delivering operational support and development in a business-critical highly complex technical environment.
- Proven experience as an Oracle PL/SQL Developer working in relational and dimensional databases, and data warehousing.
- Awareness of performance factors in an Oracle data warehouse environment and well-practised in tuning of SQL and PL/SQL.

A few other skills that would be an advantage are:

- Application design and development with Oracle APEX.
- Familiarity with Python and knowledge of modern data platforms and integration tools including Azure.

A degree in Computer Science (or similar) or equivalent experience is required for this role.

**Utu ā-tau | Salary**

The mid-point of the salary range is $121,124 per annum and the full range (85%-120%) is $102,956 - $145,349 per annum. Appointment and remuneration will reflect skills and experience relevant to the role.

**Ko wai mātou | About us**

Ara Poutama Aotearoa is a name that has been gifted to us and is our commitment to improving the oranga and safety of the people, whānau, and that of the communities we serve across the motu.

As a values-led organisation, we use the principles of rangatira (leadership), manaaki (respect), wairua (spirituality), kaitiaki (guardianship) and whānau (relationships) to shape how we work and deliver the outcomes in our strategy - Hōkai Rangi.

It is an exciting time to join us, and we continue to seek out talented individuals who are committed to an inclusive, vibrant workplace. We recognise and celebrate the uniqueness of individuals, and that of the collective talent in our whānau.

To apply, please submit a tailored **CV and a cover letter** describing your motivation for joining the department highlighting relevant skills and experience. Alignment to our kaupapa is critical to our success - we ask that you provide examples which reflect and demonstrate our organisation values.

**Applications close on**:Tuesday 19 November at 11pm NZST.

  • Senior Data Warehouse Engineer

    6 months ago

    Wellington City, New Zealand New Zealand Government Full time

    Te tūnga | The role We have an exciting permanent full-time opportunity for a Senior Data Warehouse Engineer to join our Data & Analytics group. Reporting to our Business Intelligence & Analytics Manager, you will be responsible for the development and maintenance of ESR's enterprise data warehouse to support analysis and reporting for both internal and...

  • Senior Data Warehouse Developer

    6 months ago

    Wellington City, New Zealand HAYS Full time

    6-Month Contract Opportunity for a Senior Data Warehouse Developer (MS Stack) Title**:Senior Data Warehouse Developer** Organisation**:Public Sector** Length**:6 Months** Rate**:$115 - $130 p/hr** Location**:Wellington + WFH Flexibility** In this role, you'll be responsible for - Designing, implementing and maintaining complex data engineering solutions to...

  • Data Operations Manager

    1 month ago

    Wellington, New Zealand Datacom Full time

    Our WhyDatacom works with organisations and communities across Australia and New Zealand to make a difference in people's lives and help organisations use the power of tech to innovate and grow.About the Role (Your Why)THIS ROLE CAN BE WORKED FROM ANY DATACOM OFFICE IN NZAre you passionate about driving data excellence and optimizing enterprise data systems?...

  • Data Warehouse Developer

    6 months ago

    Wellington City, New Zealand New Zealand Government Full time

    **Kaiwhakawhanake Pātaka Raraunga**: Data Warehouse Developer (intermediate) 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...

  • Principal Data Warehouse Developer

    3 months ago

    Wellington City, New Zealand New Zealand Government Full time

    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...

  • Data Operations Manager

    1 month ago

    Wellington City, New Zealand Datacom Full time

    Our Why Datacom works with organisations and communities across Australia and New Zealand to make a difference in people’s lives and help organisations use the power of tech to innovate and grow.  About the Role (Your Why) THIS ROLE CAN BE WORKED FROM ANY DATACOM OFFICE IN NZ Are you passionate about driving data excellence and optimizing enterprise data...

  • Team Leader

    3 months ago

    Wellington City, New Zealand New Zealand Government Full time

    If you're looking for your “why”, then come and join us at the TEC. We invest $3 billion a year in the education and training that transforms the lives of individuals, our communities and the economy. We play a fundamental role in lifting the aspirations and skills of all New Zealanders from ages 7 to 74. What will you be doing? - Lead a high performing...

  • Business Intelligence and Data Warehouse Developer

    6 months ago

    Wellington City, New Zealand New Zealand Government Full time

    Contribute to transforming the future of health in this Business Intelligence and Data Warehouse Developer role - Opportunity to thrive in a fast paced and dynamic environment - Flexible working fully supported to balance your workplace and lifestyle - Wellington Location preferred (negotiable for the right person) - Permanent, Full-time opportunity Join Te...

  • Gm - Data & Enterprise Architecture

    1 month ago

    Wellington City, New Zealand NZ Post Full time

    **Mō te Tukurau Aotearoa - About NZ Post** It's an exciting time to join the NZ Post whanau. Our organisation has a clear ambition with a refreshed strategy, and we are on a journey to bring this to life. Part of this is ensuring our Data and Technology (D&T) offering is always improving to be fit for purpose and where we can create distinct value for NZ...

  • Team Leader

    3 months ago

    Wellington City, New Zealand New Zealand Government Full time

    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...

  • Senior Developer Information and Bi

    7 months ago

    Wellington City, New Zealand New Zealand Government Full time

    Senior BI Developer (PowerBI) - Business Intelligence Services Data & Information Te whiwhinga mahi/The Opportunity Join a high performing team delivering Business Intelligence solutions for the Ministry of Justice. This role is based in Wellington and primarily focuses upon PowerBI reporting needs for a number of critical business functions including...

  • Senior Developer Information and Bi

    6 months ago

    Wellington City, New Zealand New Zealand Government Full time

    Te whiwhinga mahi/The Opportunity Join a high performing team delivering Business Intelligence solutions for the Ministry of Justice. This role is based in Wellington and primarily focuses upon PowerBI reporting needs for a number of critical business functions including Property Management, Project Management and operational reporting for our National...

  • Data Warehouse Solutions Architect

    4 weeks ago

    Wellington, Wellington, New Zealand This Is An IT Support Group Full time

    This Is An IT Support Group is seeking a Data Warehouse Solutions Architect to lead the centre of excellence in delivering data warehouse and application solutions. The role will involve leading a high-performing team that is future-focused on cloud technologies like Databricks.About the RoleThe ideal candidate will have proven experience in building and...

  • Team Leader Data

    4 weeks ago

    Wellington, New Zealand This Is An It Support Group Full time

    Role type: PermanentLocation: WellingtonJob published on: 14 November 2024You will be responsible for leading the centre of excellence that delivers the data warehouse and application solutions needed to manage data. Leading a high performing data warehouse development team that is future focused with the move to cloud technologies like Databricks.To qualify...

  • Team Leader Data

    4 weeks ago

    Wellington, New Zealand This Is An IT Support Group Full time

    Role type: Permanent Location: Wellington Job published on: 14 November 2024 You will be responsible for leading the centre of excellence that delivers the data warehouse and application solutions needed to manage data. Leading a high performing data warehouse development team that is future focused with the move to cloud technologies like Databricks. To...

  • Team Leader Data

    1 month ago

    Wellington, New Zealand Presto Resourcing Options Full time

    Role type: Permanent Location: Wellington Job published on: 14 November 2024You will be responsible for leading the centre of excellence that delivers the data warehouse and application solutions needed to manage data. Leading a high performing data warehouse development team that is future focused with the move to cloud technologies like Databricks.To...

  • Data Warehouse Modeller

    6 months ago

    Wellington City, New Zealand New Zealand Government Full time

    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...

  • Team Leader Data

    1 month ago

    Wellington, New Zealand Presto Resourcing Options Full time

    Role type: Permanent Location: Wellington Job published on: 14 November 2024 You will be responsible for leading the centre of excellence that delivers the data warehouse and application solutions needed to manage data. Leading a high performing data warehouse development team that is future focused with the move to cloud technologies like Databricks. To...

  • Team Leader Data

    4 weeks ago

    Wellington, New Zealand This is an IT support group Full time

    Role type: PermanentLocation: WellingtonJob published on: 14 November 2024 You will be responsible for leading the centre of excellence that delivers the data warehouse and application solutions needed to manage data. Leading a high performing data warehouse development team that is future focused with the move to cloud technologies like Databricks. To...

  • Enterprise Data Architect for Cloud Platforms

    4 weeks ago

    Wellington, Wellington, New Zealand Datacom Full time

    Role OverviewWe are seeking a seasoned Enterprise Data Architect to lead the technical delivery of large-scale data platform and BI solutions at Datacom. As a Principal Consultant, you will be responsible for designing, implementing, and owning the delivery of robust Data Platform solutions and end-to-end components.