Data Warehouse Analyst – CERT NZ

Tēnei tūranga – About the role

A CERT is an organisation that receives cyber incident reports, tracks cyber security incidents or attacks, and provides advice and alerts to its customers on how to respond and prevent further attacks. CERTs also work closely with their international counterparts to prevent and respond to cybersecurity incidents and address cybercrime.

Establishing a national CERT means New Zealand joins an international network of CERTs, improving our access to information on potential or real-time cyber-attacks. It will help New Zealand play our part in a global effort to improve internet security. Ultimately, New Zealand will become a more trusted business and security partner

CERT NZ is staffed with passionate cyber security experts and experienced staff, providing services Monday to Friday, except when activated by the national emergency response system when staff may be required to work weekends and/or outside normal hours.

The Data Warehouse Analyst is responsible for supporting the design, implementation and maintenance of CERT NZ’s data warehousing systems, information pipelines and data models used in CERT NZ’s reporting capabilities. At present there are three Analysts that will depend on the Data Warehouse Analyst to provide a constant flow of timely, traceable, highly reliable and secure information. The Data Warehouse Analyst is the liaison between the systems function that builds and maintains the data technologies and the analysts that rely on structured information to produce insights, intelligence, and reporting.

Ngā herenga – Requirements of the role

Personal specifications

• A tertiary degree in Computer science, Information Systems or a related discipline, or equivalent relevant experience.
• Experience working with a complex, on-line integrated multi-platform environment, from mainframe to client/server.
• Experience with systems strategic planning and the evaluation of new technologies and data management techniques.
• Proficient in SQL, R, Postfix, Oracle and SAP databases (or similar).
• Proven experience working in troubleshooting, administering data warehousing solutions and cloud-based technologies.
• Proven ability to communicate with and understand the needs of non-technical internal clients.
• Ability to develop and document operational processes and standards.
• Understanding of data modelling, ETL and interrogation techniques and desire to become an expert in this Takohanga tuhinga o mua – Key accountabilities and deliverables
• Understanding of Alteryx and Microsoft SSIS, Web scripting (XML, JavaScript, JSON) PowerBI, Business Objects, Tableau etc.
• Credit check required.
• Police vetting required.
• Able to gain and maintain a Secret or Confidential national security clearance required.
• Must be a NZ citizen or hold a residence class visa.

Data warehouse and pipeline maintenance

• Responsible for ensuring data integrity and data pipelines are functioning accurately, capacity and rate specified daily.
• Support the development and implementation of projects to integrate existing, new and changing systems and other data sources into the data warehouse.
• Enable the web delivery of analysis and reporting to internal and external users.
• Contribute to strategic planning and future design of data warehouse and pipeline solutions.
• Work with CERT NZ systems team to successfully implement all data warehouse and pipeline software environment changes and enhancements from concept to implementation.
• Follow a defined change management process for all enhancements and changes to data warehouse in collaboration with CERT NZ systems team.
• Design and perform daily operational tasks of the data warehouse and pipeline environment to ensure business continuity.
• Ensure effective data integration and secure automation from pipelines to data warehouse.
• Manage data warehouse issues and incidents from notification to resolution in collaboration with CERT NZ systems team.
• Provide guidance to business customers for the effective delivery of data warehouse solutions to business needs.
• Ensure the effective implementation and use of standardised processes across the full warehouse operation
• Collect, document, interpret and confirm specifications for new or changed data warehouse requirements from the business.

Data management

• Execute projects to further data management practices at CERT NZ.
• Identify discrepancies in data quality, investigate and resolve in collaboration with CERT NZ’s Insights and Reporting team and Systems team
• Develop processes for capturing and maintaining data from all data warehousing components and data pieplines.
• Develop and test extraction, transformation and load (ETL) processes. 

Stakeholder management

• Proactively establishing and maintaining effective working relationships with key stakeholders including other functional leaders. Actively building and managing a network of stakeholders to inform and build the role’s work.
• Leveraging relationships to identify and share best practice information.

Cyber security – knowledge and incident response

• Develops a level of expertise and fluency in the cyber security field, including staying up to date with new developments and relevant international activity
• Finds opportunities to share cyber security domain knowledge with others within the team and wider CERT NZ
• Develops and builds skills and knowledge to participate in serious cyber incident response and coordination, including, where appropriate:
  • Contributing to the unit’s response, thereby being instrumental in the coordination of New Zealand’s overall response to serious cyber incidents
  • Conducting and supporting briefings to senior executives
  • Communicating with technical and non-technical audiences
• Able to participate in shift-based periods during activation for New Zealand’s response to serious cyber incidents

Wellbeing, health and 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 Warehouse Analyst position reports into the Manager Insights and Reporting within the CERT NZ branch. Te Whakatairanga Service Delivery group.

More information about MBIE’s structure

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