Enterprise Data Warehouse Developer
3 days ago
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 Developer
1 day ago
Wellington City, New Zealand New Zealand Government Full timeHelp shape the future of education in New Zealand **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...
-
Senior Data Warehouse Developer
3 days ago
Wellington City, New Zealand Ministry of Education NZ Full timeJob Type: Permanent - Location: Wellington, NZ **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...
-
Data Warehouse Developer
2 weeks ago
Wellington City, New Zealand New Zealand Government Full time**Data Warehouse Developer (intermediate) : Kaiwhakawhanake Pataka Raraunga**: - An exciting senior-level opportunity to be an integral part of a key data platform modernisation programme of work - Work on modern tools and technologies such as Databricks and Azure Data Factory - Wellington-based role in a modern office space Te Amorangi Matauranga Matua, the...
-
Senior Data Warehouse Engineer
3 days ago
Wellington City, New Zealand New Zealand Government Full timeTe 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...
-
Data and Analytics Consultant
7 days ago
The Terrace, Wellington, , New Zealand enterprise IT Full time NZ$80,000 - NZ$120,000 per yearCompany Description We are preferred employer, partner and supplier of choice for innovative data services, anywhere. Our purpose is to demystify technology enabling our customers to reach their potential. Within the data & analytics team, we we help our customers make smarter faster decisions with ALL their data. Job Description This role involves...
-
Enterprise Data Modeller
5 days ago
Wellington City, New Zealand Kiwibank Full timeAuckland or Wellington based opportunity - New role as a result of growth within Kiwibank’s Transformation roadmap - Flexible working, opportunities for learning & development, plus the chance to help shape the future of banking for Kiwi! **This is us. Where you matter.** Making a difference for all Kiwi starts with making a difference for our people....
-
Wellington City, New Zealand New Zealand Government Full timeJoin a supportive and inclusive team and workplace culture - Opportunity to thrive in a fast paced and dynamic environment where the work you do truly impacts! - Flexible working fully supported to balance your workplace and lifestyle Ko wai mātou | Our Organisation It's not very often something happens that's big; like, really big. Big to the point that...
-
Data Operations Manager
1 day ago
Wellington City, New Zealand Datacom Full timeOur 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...
-
Data Warehouse Analyst
3 days ago
Wellington City, New Zealand H2R Consulting Full time**Location**: Wellington Type: Permanent / Full Time Reference: 653381 H2R Technologies are currently on the lookout for an experienced Data warehouse analyst to join a specialist unit within one of New Zealands largest central government organisations. **Requirements**: - Identify, investigate and resolve any discrepancies in data quality - Develop...
-
Team Leader
2 weeks ago
Wellington City, New Zealand New Zealand Government Full timeTe 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...
