Data Engineer (SQL, SSIS)

Salt; Hamilton; On-site; NZD 115,000 - 130,000; Full time

Benefits offered by this job

4 weeks annual leave

MyDays wellness days

Health insurance subsidies

Life & income protection

Job summary

Salt in Hamilton, New Zealand, is seeking a Permanent Data Engineer to join a small team focused on a central SQL Server data platform that supports wholesale energy margins and analytics.

The role involves maintaining data pipelines, working with SSIS, stored procedures and AWS services, and collaborating with business stakeholders to deliver data-driven insights. Onsite with some flexibility and a strong focus on development opportunities.

Qualifications

• Strong SQL Server expertise.
• SSIS experience for data integration pipelines.
• Advanced stored procedure development.
• Experience supporting operational data platforms.
• Experience managing and troubleshooting data pipelines.
• Python experience is desirable.

Responsibilities

• Maintain and enhance business-critical data pipelines and data products.
• Ensure reliability and availability of data pipelines and data quality.
• Troubleshoot failures due to upstream data changes and coordinate fixes.
• Support data-driven decisions for energy margin calculations and analytics.
• Contribute to technology modernization initiatives and roadmap input.

Skills

SQL Server

SSIS

Stored procedures

Data pipelines

AWS

Python

Stakeholder management

Communication

Orchestration frameworks

Tools

SQL Server Integration Services

Job description

Want to be a part of a top-notch NZ brand and Best enterprise workplace based on employee feedback Work for a company that is one out of four across the world and the only one in NewZealand in its domain Replacement role; stable permanent role within a major NewZealand energy organisation. Opportunity to work on a business-critical data platform; exposure to wholesale energy markets; direct impact on trading and energy margin calculations; involvement in future technology decisions; opportunity to shape modernisation initiatives; Hamilton based candidates only or open to relocate Around 115k p.a. to 130k p.a. approx. Ongoing expectation is approximately three days per week in the Hamilton office, with flexibility for personal commitments where required; Initially onsite for a month to settle down with people and systems A huge list of additional benefits apart from an excellent package

THE ROLE:

Permanent Data Engineer role reporting to Delivery Lead. This is a replacement position that has been internally reclassified because Data Engineer more accurately reflects the nature of the work. The role supports Client's Wholesale Markets business unit, a critical area of the organisation. The successful candidate will join a small team of three. The team manages a central collection of SQL Server databases that consolidate data from multiple applications, integrations and third‑party sources. The data is used to calculate energy margins, support trading decisions and enable analytical reporting for business stakeholders. This environment is centred on SQL Server. Essential technical expertise includes SQL Server, SSIS (SQL Server Integration Services), SQL Stored Procedures, data integrations and maintenance of data pipelines. The current platform is hosted in AWS, although heavy use of AWS‑native data services is not expected.

Maintain and enhance business‑critical data products; ensure reliability and availability of data pipelines; troubleshoot failures caused by upstream third‑party data changes; coordinate fixes and updates; develop enhancements requested by business stakeholders; support changing market conditions and new energy initiatives such as wind farm projects; ensure data quality and operational stability while contributing to future technology evolution.

Client is actively evaluating the future direction of the platform. While SQL Server will remain important, technologies such as SSIS may be replaced over time. The successful candidate will have the opportunity to contribute ideas, influence the roadmap and participate in technology modernisation initiatives.

THE IDEAL CANDIDATE:

• Strong SQL Server expertise
• Strong SSIS experience
• Advanced stored procedure development
• Experience supporting operational data platforms
• Experience managing and troubleshooting data pipelines
• Ability to work closely with business stakeholders and deliver enhancements
• Python experience is highly desirable due to industry direction and future‑state considerations
• Exposure to modern data engineering concepts, tools or self‑driven learning projects is advantageous
• Interest in technologies such as orchestration, transformation frameworks and modern data platforms is welcomed, although no specific future technology commitments have been made
• AWS exposure is beneficial but not a key hiring criterion
• Based in Hamilton
• Good stakeholder / end user management experience
• Good oral and written communication & coordination skillsets
• Good with people

AI Expectations

Candidates should demonstrate curiosity regarding AI and how it can improve productivity, data engineering practices and data value delivery. Personal experimentation, learning initiatives and practical ideas for AI adoption will be viewed positively, although AI is not the primary focus of the role.

WHY THIS ROLE?

• 4 weeks annual leave plus an additional 5 days called MyDays that can be used for Wellbeing across the year.
• Health WOF - pay for a yearly doctors visit upto 100$ and confidential assistance program
• Life & Income protection insurance
• Health Insurance subsidies with Southern Cross & Nib
• Great discount on your electricity and mobile bills
• Excellent paternal leave policy with option to buy additional leave ; Gender affirmation leave, supportive bereavement leave including your pet
• Large focus on development and development plans and they have 1 day a month allocated as Innovation Day.
• Winner of Best Enterprise workplace awards
• Excellent salary and benefits
• Collaborative, encouraging work culture

Pls note: A valid NZ work visa is a pre-requisite for all our positions as of now. In case any client is willing to sponsor an outstation international candidate, we would mention that separately.