Commercial Insights Analyst
Mercury NZ
What the role involves
- Analysing customer datasets
- Building visualisations and reporting
- Presenting insights and recommendations
What they ask for
Intermediate experience in an analytical role working with complex data; proficiency in SQL, Power BI, Oracle BI, Databricks and Excel; tertiary qualification in Finance, Economics, Analytics or Mathematics, or equivalent experience
About the job
He whakahaere aronga-anamata a Mercury, e tuku ana i te pūngao me ngā whitimamao ki te mahi a tangata o Aotearoa, ā, he nui ake i tā ētahi atu. Waihoki, e para ana i te huarahi mā te pūngao whakahou me te whai i tētahi anamata toitū. Kei te iho ko tō mātou koronga. Tiakina te anamata, mā te tūhono i ngā tāngata me ngā wāhi o te inamata. He āki tēnei i a tātou ki te whakapau kaha kia hua ake ai he anamata pai ake mō ō tātou tāngata, mō ō tātou hapori, me Aotearoa.
Mercury is a bold future-focused organisation, providing energy and telecommunications to more Kiwis than anyone else, leading the way with renewable energy and working toward a sustainable future. At the heart is our purpose. Taking care of tomorrow: connecting people and place today. This pushes us to do all we can to create a better future for our people, our communities, and Aotearoa New Zealand.
Tā mātou arawātea | Our Opportunity:
Data is only useful when it changes a decision. As a Commercial Insights Analyst in our Customer team, you’ll sit between the data and the business, turning large, complex datasets into insights our Markets segment squads can act on.
This is a technical analytics role with a strong commercial edge. You’ll work hands-on with data, partner closely with stakeholders to understand what they need, and present your findings in a way that’s clear, practical and easy to act on. You’ll report to the Practice Lead – Commercial Insights & Analytics and be part of a team that’s always looking for better ways to work.
There’s plenty happening at Mercury right now. We have two Commercial Analyst roles open, plus a Senior Commercial Insights Analyst & Data Analyst opportunity currently advertising within the team. If you’re keen to be part of what we’re building, check out our careers page at careers.mercury.co.nz.
Tāu e mahi ai | What you’ll be doing:
- Extracting, cleaning and analysing large datasets to uncover customer and market trends and behaviours
- Building visualisations and reporting that land with both technical and non-technical audiences
- Working with proposition, pricing, finance, sales, operations and other cross-functional teams to understand their needs and shape the right analysis
- Presenting insights and recommendations that are clear, direct and ready to act on
- Using commercial judgement to assess the viability of propositions and recommend ways to improve outcomes
- Validating and testing data to keep quality and accuracy high
- Finding ways to improve our reporting tools and processes, and sharing what you learn with the team
Tāu ka kawe mai | What you’ll bring:
- Intermediate experience in an analytical role working with complex data
- Proficiency in SQL, Power BI, Oracle BI and Databricks for data extraction, transformation and visualisation, plus strong Excel skills
- Strong commercial nous and an understanding of business drivers
- Confidence engaging stakeholders and explaining complex data in plain language
- Sharp problem-solving skills and attention to detail
- A growth mindset and a habit of improving how things get done
- A tertiary qualification in Finance, Economics, Analytics, Mathematics or equivalent experience
- Experience in utilities or telecommunications is an advantage, but not essential
He aha te pai o te hono mai? | Why join us?
- Additional 5 days leave per annum (MyDays)
- $400 one off tax-free payment towards setting up your home office
- Offers on electricity and telco - if you're a Mercury customer, you can enjoy 25% off eligible energy, broadband and mobile charges
- Join the Employee Share Scheme where you receive $1,000 of Mercury shares annually with a 3-year period of restriction
- A diverse workplace where your unique abilities and talents will be recognised and encouraged
- Annual salary reviews with excellent parental leave policy, with the option to purchase additional leave
- The opportunities, career paths and facilities associated with working for one of New Zealand's largest multi-utility providers
- Flexible working policy - The autonomy and trust to work flexibly from our purpose-built premises and from home, recognising the value of this flexibility in the modern world
- Discounted health insurance and free life and income insurance
- Excellent well-being programme including up to $100 annual check ups and confidential assistance programme
- Gender affirmation leave and supportive bereavement leave to be taken when you lose anyone close to you, including your pet
Mercury is a learning organisation that is committed to providing you with opportunities to grow and develop that will benefit you now and in the future. Part of your role includes building your skillset and mindset through a variety of ways. We believe this creates an energised, innovative and agile work environment where you will feel valued.
E koekoe te tūī, e ketekete te kākā, e kūkū te kererū
Every voice has its place – and together, we thrive.
At Mercury, we believe different backgrounds, experiences and capabilities make us stronger. If this role matches your skills and interests, we encourage you to apply, even if you don’t meet every requirement.
Click ‘apply’ to submit your application. If you require support or adjustments during the recruitment process, please contact recruitment@mercury.co.nz. Applications cannot be accepted via email.
The full position description is available below. Applications close at 23rd November 2026. We may review applications, begin interviews and close the advertisement before this date, so we encourage you to apply early.
Applying for this job
What to show on your CV
- It names SQL, Power BI, Oracle BI, Databricks and Excel. Use the same words on your CV for the ones you've used, so a search finds them.
- For the work it describes, like "Analysing customer datasets", give an example from your own experience, with a result you can talk about at an interview.
Our guides to the New Zealand CV format, cover letters and interview questions cover the rest.