Data Warehousing and Business Intelligence Developer
On this page
Tēnei tūranga – About the role
Data warehousing and business intelligence has the power to transform the way that our organisation works. Imagining, innovating, and implementing analytical solutions which allow our departments to harness their data in meaningful ways has the power to change the way we work, and ultimately impact the lives of many New Zealanders.
As a Data Warehousing & Business Intelligence (DW&BI) Developer you will work closely with MBIE’s other business groups to bring these opportunities to life by developing the structure, reports and objects which allow us to deliver data back to our audiences in formats which give the business the critical insights required for them to be confident in their decision making.
You can translate requirements into effective solutions which have a significant impact on the perceived value of your 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 in mind.
The wider ICT team enable and empower the functions of our core business through effective use of technology; the implementation of services and systems which strengthen the way our Ministry delivers services and delivers on the outcomes required by Government.
Ngā herenga – Requirements of the role
Personal specifications
- You will be seen to be an expert in the field of data warehousing and business intelligence.
- You will have the ability to design and develop smart business solutions from complex data sources using the tools utilised by the DW and BI team.
- You will become a trusted advisor to our diverse stakeholder base.
- You will have clear communication skills.
- You will have a tertiary qualification in a related subject.
- You must have the legal right to live and work in New Zealand and be able to satisfy the Ministry’s security clearance requirements.
CG&I Capability Level
This role requires SFIA Competency Level 6, indicating a high level of organisational impact and influence, and the critical nature of this role within the wider business.
AUTHORITY
Has defined authority and accountability for actions and decisions within a significant area of work, including technical, financial, and quality aspects. Establishes organisational objectives and assigns responsibilities.
INFLUENCE
Influences policy and strategy formation. Initiates influential relationships with internal and external customers, suppliers, and partners at senior management level, including industry leaders. Makes decisions, impacts the work of employing organisations, achievement of organisational objectives, and financial performance.
BUSINESS SKILL
Has a broad business understanding and deep understanding of own specialism(s). Performs highly complex work activities covering technical, financial, and quality aspects. Contributes to the implementation of policy and strategy. Creatively applies a wide range of technical and/or management principles.
TECHNICAL COMPLEXITY
Absorbs complex information and communicates effectively at all levels to both technical and non-technical audiences. Manages and mitigates risk. Understands the implications of new technologies. Demonstrates clear leadership. Understands and communicates industry developments, and the role and impact of technology in the employing organisation. Promotes compliance with relevant legislation. Takes the initiative to keep both own and colleagues' skills up to date.
CG&I Technical Competency levels
SFIA Competencies |
SFIA Skill Level |
Technical Specialism – TECHThe development and exploitation of expertise in any specific area of information or communications technology, technique, method, product, or application area. |
Level 4:Maintains knowledge of specific specialisms, provides detailed advice regarding their application, and executes specialised tasks. The specialism can be any area of information or communication technology, technique, method, product, or application area. |
Emerging Technology Monitoring – EMRGThe identification of new and emerging hardware, software and communication technologies and products, services, methods and techniques and the assessment of their relevance and potential value as business enablers, improvements in cost/performance or sustainability. The promotion of emerging technology awareness among staff and business management. |
Level 4:Maintains awareness of opportunities provided by new technology to address challenges or to enable new ways of working. Within own sphere of influence, works to further organisational goals, by the study and use of emerging technologies and products. Contributes to briefings and presentations about their relevance and potential value to the organisation. |
Analytics – INANThe validation and analysis of significant volumes of data, including the ability to discover and quantify patterns and trends in numbers, symbols, text, sound, and image. Relevant techniques may include statistical and data mining algorithms and machine learning methods such as rule induction, artificial neural networks, genetic algorithms, and automated indexing systems.
|
Level 4:Applies a variety of analytical and visualisation techniques, in consultation with experts if appropriate, and with sensitivity to the limitations of the techniques.
|
Data Management – DATMThe management of practices and processes to ensure the security, integrity, safety, and availability of all forms of data and data structures that make up the organisation’s information. The management of data and information in all its forms and the analysis of information structure (including logical analysis of taxonomies, data, and metadata). The development of innovative ways of managing the information assets of the organisation. |
Level 4:Takes responsibility for the accessibility, retrievability and security of specific subsets of data. Assesses the integrity of data from multiple sources (including, for example, from sensors & measurement systems). Provides advice on the transformation of data/information from one format/medium to another, where appropriate. Maintains and implements information handling procedures. Enables the availability, integrity and searchability of information through the application of formal data structures and protection measures. Manipulates specific data from information services, to satisfy local or specific information needs. |
Methods and Tools – METLEnsuring that appropriate methods and tools for the planning, development, testing, operation, management, and maintenance of systems are adopted and used effectively throughout the organisation. |
Level 4:Provides expertise and support on use of methods and tools. |
Data Analysis – DTANThe investigation, evaluation, interpretation, and classification of data can define and clarify information structures which describe the relationships between real world entities. Such structures facilitate the development of software systems, links between systems or retrieval activities |
Level 4:Investigates corporate data requirements, and applies data analysis, data modelling and quality assurance techniques, to establish, modify or maintain data structures and their associated components (entity descriptions, relationship descriptions, attribute definitions). Provides advice and guidance to database designers and others using the data structures and associated components. |
Systems Design – DESNThe specification and design of information systems to meet defined business needs in any public or private context, including commercial, industrial, scientific, gaming and entertainment. The identification of concepts and their translation into implementable design. The design or selection of components. The retention of compatibility with enterprise and solution architectures, and the adherence to corporate standards within constraints of cost, security, and sustainability. |
Level 4:Recommends/designs structures and tools for systems which meet business needs and takes into account target environment, performance & security requirements, and existing systems. Delivers technical visualisation of proposed applications for approval by customer and execution by system developers. Translates logical designs into physical designs and produces detailed design documentation. Maps work to user specification and removes errors and deviations from specification to achieve user-friendly processes. |
User Experience Design – HCEVThe iterative development of user tasks, interaction, and interfaces to meet user requirements, considering the whole user experience. Refinement of design solutions in response to user-centred evaluation and feedback and communication of the design to those responsible for implementation. |
Level 4:Collaborates with colleagues from other disciplines to define technology objectives, assess solution options and devise architectural solutions that both achieve strategic business goals and meet operational requirements. Creates design briefs for new web and digital projects or refreshes of existing projects. Develops visual user experiences across digital assets, working with project teams to present propositions and strategies. Rapidly translates digital concepts into hi-fidelity visual outputs and interactive prototypes. Captures multi-disciplinary requirements, and translates those requirements into user experiences, prototypes, and final assets. Plans and costs UX activities, building in time for iteration, user feedback and design changes, and articulating the costs and benefits of different design approaches. |
Takohanga tuhinga o mua – Key accountabilities and deliverables
Technology outcomes
- You are using your development experience to design and deliver highly usable solutions focussed on high levels of data integrity and always with data warehousing and business intelligence best practice.
- You are finding 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.
- The solution you deliver is easily consumed; you are actively looking for ways to improve the utility of the Ministry’s data.
- Both you and the wider team are adding value to the Ministry by genuinely taking ownership of the solutions it designs and delivers.
Relationships
- Relationships with your peers, your stakeholders and your leaders are productive; communication is professional, clear, and timely. Your conversations are robust, and trust is created.
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 Data Warehousing and Business Intelligence Developer position reports into the Manager of Data Warehousing within the Information and Communications Technology branch. The branch sits within the Digital Data and Insights 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
