Data Analyst – CERT NZ
On this page
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 Analyst is responsible for enhancing, maintaining, and curating information pipelines and data models that support CERT NZ’s reporting capabilities. The role is critical in ensuring all data used and released by CERT NZ is timely, of the utmost quality, traceable and secure. The Data 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.
Ngā herenga – Requirements of the role
Personal specifications
- Relevant tertiary qualification preferred and/or comparable experience.
- Proficient in SQL, R, Postfix, Oracle, and SAP databases (or similar).
- Proficient in analytics, mathematics, and statistical methods.
- Ability and interest to self-learn applications and systems profoundly.
- Curious and proactive at investigating and identifying software application problems with little guidance.
- Passionate about quality, precision and customer service.
- Understanding of data modelling, ETL and interrogation techniques and desire to become an expert in this.
- 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 national security clearance required.
- Must be a NZ citizen or hold a residence class visa.
Data analysis and maintenance
- Responsible for ensuring data integrity and data pipelines are functioning accurately, capacity and rate specified daily.
- Identify discrepancies in data, investigate and seek to resolve data or pipeline issues.
- Develop CERT NZ data models information frameworks and implement fit for purpose databases.
- Develop processes for capturing and maintaining data from all data warehousing components.
- Develop and test extraction, transformation and load (ETL) processes.
- Define and capture metadata and rules associated with ETL processes.
- Maintain and create internal and external dashboards and reports to a mix of stakeholders.
- Respond to data queries from public, local authorities and team members at short notice with high accuracy.
- Contribute data management, modelling, architecture, software design, and implementation decisions.
- Execute small projects to further data management practices at CERT NZ. Support larger initiatives as required.
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.
- Able to participate in shift-based periods during activation for New Zealand’s response to serious cyber incidents.
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.
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 Analyst position reports into the Manager Insights and Reporting within the CERT NZ branch. 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
