Salt
Data Engineer (SQL, SSIS)
Permanent data engineer joining a three-person team that runs a business-critical SQL Server data platform for a major NZ energy company's wholesale markets unit — maintaining SSIS pipelines and stored procedures, troubleshooting third-party data feeds, and supporting trading and energy margin reporting. Hybrid role, ~3 days/week in the Hamilton office.
- Compensation
- NZ$112K–NZ$130K / yr
- Location
- Hamilton Central, Waikato
- Work setup
- Hybrid
- Seniority
- Not specified
- Employment
- Full time
- Experience
- Not specified
- Category
- Data engineering
- Posted
Skills
Must have
- Strong SQL Server expertise
- Strong SSIS (SQL Server Integration Services) experience
- Advanced SQL stored procedure development
- Experience supporting operational data platforms
- Experience managing and troubleshooting data pipelines
- Ability to work closely with business stakeholders and deliver enhancements
- Based in Hamilton or open to relocating there
- Valid NZ work visa
- Good stakeholder / end user management experience
- Good oral and written communication and coordination skills
Nice to have
- Python experience (highly desirable)
- Exposure to modern data engineering concepts, tools or self-driven learning projects
- Interest in orchestration, transformation frameworks and modern data platforms
- AWS exposure (beneficial but not a key hiring criterion)
- Curiosity about AI for productivity and data engineering practices
Full description
Salary: $112000.00 - $130000.00 p.a. + + benefits
- 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 New Zealand in its domain
- Replacement role; stable permanent role within a major New Zealand 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.