Hamilton // Data Engineer

Mercury NZ Limited; Hamilton; On-site; NZD 120,000 - 180,000; Full time

Benefits offered by this job

5 days leave per annum

Home office setup grant

Employee share scheme

Discounted health insurance

Well-being programme

Job summary

Mercury NZ Limited in Hamilton is seeking an experienced Data Engineer to join our Digital Services team, focusing on Generation and Wholesale Markets data and systems. The role covers both operational and analytical data pipelines as Mercury modernises its technology platforms.

You'll work with Wholesale Analysts, Business Analysts, Software Engineers and other Data Engineers to build data solutions that deliver value, monitor pipelines, and continuously improve data infrastructure.

Qualifications

• 5+ years' experience in a commercial Technology environment, including at least 2 years in Data Engineering or analytics.
• Extensive Microsoft SQL Server experience including strong T-SQL, SSIS, SSMS.
• Exposure to modern data platforms and tools, for example Databricks, Snowflake, Fabric, Airflow, dbt
• Strong SQL and Python. Powershell experience is preferred

Responsibilities

• Building, testing, deploying and maintaining data pipelines using our existing tech stack with opportunities to progressively modernise
• Working with data source owners and SMEs to understand and leverage Mercury's data assets
• Design data solutions that deliver real value and are easy to understand and use
• Contributing to improved platform functionality - streamlining pipelines and building repeatable patterns
• Proactively monitoring and responding to operational issues for the products you've built and existing products

Skills

Strong SQL & Python

T-SQL

Education

Tertiary qualification

Tools

Databricks

Snowflake

Airflow

dbt

PowerShell

Job description

At Mercury you're not just an employee, you're part of something bigger, and something great. Our team makes a real difference to New Zealand by doing new and exciting things with energy.

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 are looking for an experienced Data Engineer to join our Digital Services team specialising in Generation and Wholesale Markets (Trading) data and systems.

This is a core function to Mercury’s operations and encompasses both operational and analytical data, and many data pipelines.

This will be an exciting time to join the team as we embark on a period of modernising our technology platforms including the data pipelines and products.

You’ll be closely working with the Wholesale Analysts team and other Business Unit Stakeholders as well as Business Analysts, Software Engineers and other Data Engineers, bringing your curiosity and technical know-how to challenge the status quo and drive continuous improvement.

Tāu e mahi ai | What you'll be doing:

• Building, testing, deploying and maintaining data pipelines using our existing tech stack with opportunities to progressively modernise
• Working with data source owners and SMEs to understand and leverage Mercury's data assets
• Design data solutions that deliver real value and are easy to understand and use
• Contributing to improved platform functionality - streamlining pipelines and building repeatable patterns
• Proactively monitoring and responding to operational issues for the products you've built and existing products
• 5+ years' experience in a commercial Technology environment, including at least 2 years in Data Engineering or analytics
• Extensive Microsoft SQL Server experience including strong T-SQL, SSIS, SSMS.
• Exposure to modern data platforms and tools, for example Databricks, Snowflake, Fabric, Airflow, dbt
• Strong SQL and Python. Powershell experience is preferred
• Hands-on experience with a cloud platform - AWS (preferred), Azure or GCP
• A tertiary qualification and/or demonstrated equivalent experience through professional work
• Additional 5 days leave per annum (MyDays)
• $400 one off tax-free payment towards setting up your home office
• 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
• Join the Employee Share Scheme where you receive $1,000 of Mercury shares annually with a 3-year period of restriction
• The opportunities, career paths and facilities associated with working for one of New Zealand's largest multi-utility providers
• 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.

Every voice has its place - and together, we thrive.

Location(s) Hamilton

Expertise Engineering - ICT, Information Technology