Senior Data Warehousing and BI Developer
On this page
Tēnei tūranga – About the role
The Customer, Design and Innovation (CDI) branch enables and empowers the functions of Te Whakatairanga Service Delivery (TWSD) to ensure that work is planned and prioritised in a way that will deliver on our strategic outcomes and in alignment to financial obligations. The CDI Branch is centre of expertise, delivering a variety of specialised functions across Te Whakatairanga Service Delivery (TWSD). It brings clarity and robust advice to the way work is commissioned and governed.
The Senior Data Warehousing and BI Developer works with the Manager Data Systems to support the ingestion (collection), storage (data warehouse) and curation (management of datasets) of Te Whakatairanga Service Delivery (TWSD) data. They will support development of team members and uplifting internal capability of data collection and storage across TWSD.
With the ability to translate requirements into effective reports and dashboards the Senior Developer Data Warehousing will have a significant impact on the perceived value of the Data Systems team. Your pride in your work will mean you are designing and modelling our data warehouse solutions in a robust manner, always with best practice always in mind.
The Senior Data Warehousing and BI Developer will support the Manager Data Systems and working closely with the members of the team, complete a review of the team's work, stakeholder expectations, comparison with Corporate and Digital Shared Services (CDSS) and financial impacts on the business to help inform a roadmap of future capability and strategic focus areas for the team.
The Senior Data Warehousing and BI Developer works closely with teams in CDSS and across TWSD to understand the needs of business groups and translates these into data models to support their business enablement.
Ngā herenga – Requirements of the role
Personal specifications
- Expert knowledge and wide experience across data modelling disciplines with an in-depth understanding of best practice principles.
- You will be seen to be an expert in the field of data and BI development.
- Proven ability at a senior level to lead the design of data modelling from complex data sources.
- Ability to successfully deliver output that meets client needs and supports their business enablement.
- Improve the storage, retrieval and use of data assets of structured, semi-structured and unstructured form
- Proactively contribute and provide data management expertise into analytics and insights efforts
- Support the development data pipeline architecture optimal to advancing the use of analytics and insights
- Construct data sets that meet functional / non-functional business requirements, some of which are of a large, complex nature
- Identify and drive improvement of processes in automation, optimisation of delivery, scalability of data structures
- Established data engineering professional with track record of leading successful data projects
- Advanced knowledge and experience working with various relational databases, proficiency in query authoring (SQL)
- Knowledge and experience working with a variety of on premise and cloud data warehousing solutions (preferably Azure)
- Knowledge and experience building and optimizing data pipelines, architectures, data warehouses, data marts and data sets.
- Proven ability to develop and maintain the trust and credibility with senior leaders and stakeholders.
- Sound appreciation of corporate management disciplines, techniques and understanding of Government decision-making and operating procedures.
- Tertiary qualification in a relevant field or extensive comparable experience.
- Must have the legal right to live and work in New Zealand.
Takohanga tuhinga o mua – Key accountabilities and deliverables
Critical areas of success
- Develops and defines MBIE’s approach and practice for data modelling, ensuring high standards of data integrity, quality and accuracy are achieved.
- Ensures MBIE has effective ways to extract and manipulate data that results in meaningful data which empowers wider MBIE.
- Ensure data management / modelling structures are accessible in formats which give MBIE teams the critical insights required for them to be confident in their decision making.
- Engage in a systematic and integrated way and share information with sectors that share strategic interests.
- Ensure the application, integration and use of Te ao Māori and Te ao Māori practices in the work of the Branch and as such MBIE; tikanga, Te Reo and an appreciation of the Treaty of Waitangi, Te Tiriti and the Treaty Principles.
- Foster a customer-focused culture across the Branch.
Technology outcomes
- Use development experience to design and deliver highly usable solutions focussed on high levels of data integrity and always with BI/DW best practice always.
- Find effective ways to extract and manipulate the data available to you and reinvent this into meaningful data which empowers our business users and the wider MBIE.
- Stakeholders are experiencing improvements – through increased availability of useful data you and your team are creating.
- Reporting is easy to consume, you are actively looking for ways to improve the usability of the Ministry’s data.
Relationship management - work collaboratively with others to support the achievement of MBIE outcomes
- Build strategic alliances with key government and non-government representatives to ensure MBIE’s views are influential in their decision-making.
- Build and maintain effective relationships and partnerships with national and international organisations to identify and share best practice information and to promote the Ministry, its products, and services.
- Lead any engagement programme(s) with identified influencers and key stakeholders.
- Actively look for opportunities and synergies with internal and external stakeholders that focus on and meet customer needs.
- Use a one organisation perspective when contributing to internal forums and governance bodies.
- Represent whole-of-Ministry views and protect its reputation in external interactions.
Wellbeing, health & safety
- Displays commitment through actively supporting all safety and wellbeing initiatives.
- Ensures own and others safety at all times.
- Complies with relevant safety and wellbeing policies, procedures, safe systems of work and event reporting.
- Reports all incidents/accidents, including near misses in a timely fashion.
- Is involved in health and safety through participation and consultation.
Tō tūranga i roto i te Manatū – Your place in the Ministry
The Senior Data Warehousing and BI Developer position reports into the Manager Data Systems within the Data, Research and Insights Unit, within the Customer, Design and Innovation Branch. The branch sits within the Te Whakatairanga Service Delivery group.
To mātou aronga – What we do for Aotearoa New Zealand
Hīkina Whakatutuki is the te reo Māori name for the Ministry of Business, Innovation and Employment. Hīkina means to uplift. Whakatutuki means to move forward, to make successful. Our name speaks to our purpose, Grow Aotearoa New Zealand for All.
To Grow Aotearoa New Zealand for All, we put people at the heart of our mahi. Based on the principles of Te Tiriti o Waitangi / The Treaty of Waitangi, we are committed to upholding authentic partnerships with Māori.
As agile public service leaders, we use our breadth and experience to navigate the ever-changing world. We are service providers, policy makers, investors and regulators. We engage with diverse communities, businesses and regions. Our work touches on the daily lives of New Zealanders. We grow opportunities (Puāwai), guard and protect (Kaihāpai) and innovate and navigate towards a better future (Auaha).
Ngā matatau – Our competencies
Cultivates innovation We create new and better ways for the organisation to be successful by challenging the status quo generating new and creative ideas and translating them into workable solutions.
Nimble learning We are curious and actively learn through experimentation when tackling new problems by learning as we go when facing new situations and challenges.
Customer focus We build strong customer relationships and deliver customer-centric solutions by listening and gaining insights into the needs of the communities we serve and actively seeking and responding to feedback.
Decision quality We make quality and timely decisions that shape the future for our communities and keep the organisation moving forward by relying on an appropriate mix of analysis, wisdom, experience, and judgement to make valid and reliable decisions.
Action oriented We step up, taking on new opportunities and tough challenges with purpose, urgency and discipline by taking responsibility, ownership and action on challenges, and being accountable for the results.
Collaborates We connect, working together to build partnerships with our communities, working collaboratively to meet shared objectives by gaining trust and support of others; actively seeking the views, experiences, and opinions of others and by working co-operatively with others across MBIE, the public sector and external stakeholder groups.
Te Tiriti o Waitangi
As an agency of the public service, MBIE has a responsibility to contribute to the Crown meeting its obligations under Te Tiriti o Waitangi (Te Tiriti). Meeting our commitment to Te Tiriti will contribute towards us realising the overall aims of Te Ara Amiorangi – Our Path, Our Direction, and achieve the outcome of Growing New Zealand for All. The principles of Te Tiriti - including partnership, good faith, and active protection – are at the core of our work. MBIE is committed to delivering on our obligations as a Treaty partner with authenticity and integrity and to enable Māori interests. We are committed to ensuring that MBIE is well placed to meet our obligations under the Public Service Act 2020 (Te Ao Tūmatanui) to support the Crown in strengthening the Māori/Crown Relationship under the Treaty and to build MBIE’s capability, capacity and cultural intelligence to deliver this.
Mahi i roto i te Ratonga Tūmatanui – Working in the public service
Ka mahitahi mātou o te ratonga tūmatanui kia hei painga mō ngā tāngata o Aotearoa i āianei, ā, hei ngā rā ki tua hoki. He kawenga tino whaitake tā mātou hei tautoko i te Karauna i runga i āna hononga ki a ngāi Māori i raro i te Tiriti o Waitangi. Ka tautoko mātou i te kāwanatanga manapori. Ka whakakotahingia mātou e te wairua whakarato ki ō mātou hapori, ā, e arahina ana mātou e ngā mātāpono me ngā tikanga matua o te ratonga tūmatanui i roto i ā mātou mahi.
In the public service we work collectively to make a meaningful difference for New Zealanders now and in the future. We have an important role in supporting the Crown in its relationships with Māori under the Treaty of Waitangi. We support democratic government. We are unified by a spirit of service to our communities and guided by the core principles and values of the public service in our work.
What does it mean to work in Aotearoa New Zealand’s Public Service?(external link) — Te Kawa Mataaho The Public Service Commission
