Business Intelligence Analyst

Tēnei tūranga – About the role

The Business Intelligence Analyst position in Building and Tenancy Branch is responsible for creating and supporting operational and insights business reports and dashboards, and the design, definition, and proactive publication of key metrics for the Tenancy Services and Building System regulatory systems.

This position is responsible for documenting requirements (e.g. business processes and reporting rules, data dictionaries and standards) that will help define success measures for the business, and translating these requirements into reporting solutions within the agreed technical environments (e.g. MS Power BI, SAP Business Objects, MS SQL Server, SAS EG, Excel, etc.).

The position supports the ongoing technical change programme in the branch and will assist and advise on projects related to exploring how artificial intelligence can enhance analytics capability and data/business intelligence/reporting and documenting these.

This position involves the understanding, collation, and management of data from a number of key business systems which support core branch operations in the Building and Tenancy branch, and will require a thorough understanding of business processes.

Ngā herenga – Requirements of the role

Personal specifications

• Able to demonstrate familiarity with Business Intelligence best practices, strategies, tools, systems, and processes.
• Has a good standard of competency with Power BI, T-SQL, SAP Business Objects.
• Demonstrates commitment and enthusiasm for customer services and evidence of applying business intelligence to improve the delivery of services.
• Has proven ability to work accurately and autonomously to agreed timeframes in order to meet objectives and deliverables (both strategic and tactical). Is self-aware and able to seek support where required.
• Is experienced and confident working across a variety of business systems/tools and operational data.
• Has proven knowledge and experience in analysing business information needs and the ability to translate these into business information/reporting/insight requirements within a project environment.
• Has a knowledge of basic ICT infrastructure, and established database systems and data environments.
• Has strong analytical skills.
• Possesses sound relationship management skills to develop relationships and positively influence key internal and external stakeholders.
• Must have the legal right to live and work in New Zealand.

Takohanga tuhinga o mua – Key accountabilities and deliverables

Critical areas of success

• Understands, collates, and manages data from a number of key business systems which service core branch operations.
• Designs, develops, and implements operational reports based on agreed success measures and KPIs, and facilitates the migration from a manual to an automated or scheduled reporting environment.
• Partners with the business and prepares responses to data requests, including Official Information Act requests, Media Queries, Parliamentary Questions, and Policy or Ministerial requests.
• Documents reporting business rules and standards to help define measures, and supports creating, testing, validating, and approvals for operational and insights reports.
• Develops and implements plans to efficiently and effectively enable the migration of key legacy data systems and reporting to a new data warehouse environment.
• Identifies effective ways to extract and manipulate the data available and translates it into meaningful data which empowers business users and the wider MBIE. Investigates new tools and techniques for data analysis.
• Designs, develop and publishes key statistics and metrics.
• Supervising data quality and modelling for key business systems across the branch.
• Working within an agreed delivery framework and schedule, and reporting delays or barriers.
• Proactively communicate effectively and openly with colleagues.
• Providing high quality, well researched and insightful analysis and recommendations for improvements.
• Develops and maintains effective relationships with various MBIE groups, including the Ministry’s Data Community of Practice, other data/BI delivery or technical teams.
• Builds engagement and data capability within the branch.

Business analysis

• Providing the ongoing review, analysis, support and re-engineering of reports.
• Assisting with prioritised report developments as required by the branch.
• Communicating effectively to ensure deliverables, requirements, and business rules are captured in a manner that non-technical users can understand.

Self-management

• Models the MBIE values.
• Willingly shares knowledge and expertise within the team and with others in the wider organisation.
• Acts with honesty and integrity.
• Welcomes feedback and is receptive to input from others.

Organisational commitment and public service

• Contributes to the development of, and helps to promote and build commitment to MBIE’s vision, mission, values and services.
• Willingly undertakes any duty required within the context of the position.
• Understands Equal Employment Opportunities (EEO) principles and the application of these to MBIE.
• Complies with all legislative requirements and good employer obligations.

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 Business Intelligence Analyst position reports to the Manager Business Delivery within the Building and Tenancy Branch, which sits within the 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