Senior Commercial Insights Analyst
Mercury NZ
What the role involves
- Analyzing complex datasets
- Uncovering market trends
- Presenting commercial recommendations
What they ask for
Extensive experience in data analysis, business intelligence or related role; advanced SQL skills; proficiency in Power BI; expert-level Excel skills; strong commercial acumen; solid commercial analysis experience including NPV and payback period
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:
We’re growing our Commercial Insights & Analytics team and have a Senior Commercial Insights Analyst role open. Building on the work of our Commercial Insights Analysts, this Senior role takes the analysis further, turning complex data into insights that shape commercial decisions across the Customer business.
You’ll work with stakeholders across Mercury to understand what matters to them, then present clear recommendations that influence the direction of the business. You’ll also share your expertise with junior analysts and help lift how the team works.
Industry knowledge helps here. If you understand the drivers behind energy and utilities, you’ll be well placed to influence commercial decisions from day one.
There’s plenty happening at Mercury right now. Alongside this role we have two Commercial Analyst roles open, & a 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:
- Leading the extraction, cleaning and analysis of large, complex datasets, keeping your work aligned to business strategy
- Working with teams across Mercury to uncover market trends and customer behaviours
- Leading commercial analysis, including NPV, payback period and margin assessments, to test the viability of new propositions
- Engaging stakeholders to understand what they need, then presenting your findings and recommendations with confidence
- Turning complex data into clear stories, with visualisations and presentations that work for technical and non-technical audiences
- Building trusted relationships within the team and with internal and external stakeholders
- Mentoring and supporting junior analysts
- Improving our processes, tools and reporting, and keeping across industry developments
Tāu ka kawe mai | What you’ll bring:
- Extensive experience in data analysis, business intelligence or a related role
- Advanced SQL skills for complex data extraction, transformation and analysis
- Proficiency in Power BI, and expert-level Excel skills
- Strong commercial acumen, ideally backed by a tertiary qualification in finance, economics, analytics or mathematics (or equivalent experience)
- Solid experience with commercial analysis, including NPV and payback period
- Strong data storytelling and communication skills, with the ability to influence senior stakeholders
- A track record of collaborating well across teams and managing relationships
- Attention to detail, and a habit of validating your work so the data is accurate
- Experience in the utilities sector is an advantage
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 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 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 "Analyzing complex 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.