Data Engineer

Gallagher Group

Hamilton

Hybrid

NZD 110,000 - 165,000

Full time

11 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Gallagher Group Limited is seeking a hands-on Data Engineer in Hamilton, NZ. You’ll join our Digital Business Technology team to drive a large Salesforce data migration as part of a multi-year Revenue Operations transformation.

You’ll build scalable data pipelines from SAP and other systems into Salesforce, while evolving data models and ensuring data quality. You’ll work with Azure Data Factory, Databricks, dbt, SQL and Python/PySpark, contributing from the ground up with a focus on

Qualifications

  • Commercial experience building and maintaining data pipelines in a cloud environment (Azure or AWS).
  • Strong SQL skills and coding in Python and/or PySpark.
  • Experience with a modern data platform such as Databricks.
  • Experience in dimensional data modelling, data quality and pipeline optimisation.
  • Familiarity with CI/CD, automated testing, version control and technical documentation.
  • Good communication and collaboration across a distributed project team.

Responsibilities

  • Build, test and maintain cloud-based ELT pipelines and data integration solutions.
  • Support data migration between Salesforce and enterprise platforms including SAP and licensing systems.
  • Develop and transform dimensional data models using SQL, Python and/or PySpark.
  • Work across Azure Data Factory, Databricks and dbt environments.
  • Improve pipeline performance, scalability, cost efficiency, observability and reliability.
  • Apply CI/CD, testing, code reviews and documentation best practices.
  • Collaborate with internal stakeholders and external engineers to hit milestones.

Skills

SQL
Python
PySpark
Databricks
Azure
AWS
Data pipelines
Data modelling
CI/CD
Testing
Documentation
Communication

Tools

Databricks
dbt
Azure Data Factory
Salesforce
SAP
Genesys Cloud
Git
Python

Job description

Why Gallagher?

At Gallagher, you'll work on technology that protects what matters most.

This is an opportunity to get hands-on with a significant enterprise transformation, work with modern cloud data technologies and build solutions that will make a tangible difference to how our business operates.

Alongside competitive remuneration and the flexibility to work remotely within New Zealand or from our Hamilton office, you'll enjoy:

  • Flexible hybrid working that supports work-life balance
  • Free onsite parking, a subsidised café and great local eateries in Hamilton
  • Boost App membership and exclusive Gallagher staff discounts
  • Ongoing professional development and career growth opportunities
About Gallagher

From protecting some of the world's most valuable assets to helping farmers care for millions of animals, Gallagher develops technology that makes a difference. Proudly New Zealand-founded, our solutions are trusted in more than 160 countries.

Our Digital Business Technology team brings together data, analytics, AI and technology capabilities that support our global operations. As our Security business moves to a new Salesforce platform, we're investing in the data infrastructure and integration capabilities needed to connect information across the organisation and unlock its value.

The Opportunity

We're looking for a hands-on Data Engineer to play a key role in a large-scale Salesforce data migration as part of a multi-year Revenue Operations transformation programme.

Over this 12-month fixed-term assignment, you'll help bring together data from a range of enterprise systems, including SAP, transforming and integrating it to create reliable, scalable data pipelines into and out of Salesforce.

You'll be involved in the engineering work from the ground up – building pipelines, developing data models, solving integration challenges and ensuring data is accurate, accessible and fit for purpose.

Working alongside our existing external engineer, and with guidance from Gallagher's Senior Data Engineer and wider Data, Analytics and AI team, you'll be part of a collaborative project with clear deliverables and genuine business impact.

The technology stack includes Azure Data Factory, Databricks, dbt, SQL and Python/PySpark.

It's a great opportunity to put your existing engineering skills to work while gaining deeper exposure to modern data platforms and enterprise-scale migration.

What you'll be doing
  • Building, testing and maintaining cloud-based ELT pipelines and data integration solutions.
  • Supporting the migration of data between Salesforce and enterprise platforms including SAP, Genesys Cloud and licensing systems.
  • Developing and transforming dimensional data models using SQL, Python and/or PySpark.
  • Working across Azure Data Factory, Databricks and dbt environments.
  • Improving pipeline performance, scalability, cost efficiency, observability and reliability.
  • Applying sound engineering practices across CI/CD, testing, code reviews and technical documentation.
  • Collaborating with internal stakeholders, source-system specialists and Slalom engineers to deliver project milestones.
The Fit

You're a practical, technically capable Data Engineer who enjoys solving problems and getting things built. You take ownership of your work, understand the importance of quality and reliability, and can confidently talk through the solutions you've developed and the engineering decisions behind them.

We're interested in what you can do, not just a checklist of technologies.

You don't need to be an architect or have experience across every tool in our stack. Strong engineering fundamentals, hands-on experience and the ability to pick up new technologies will go a long way.

Ideally, you'll bring:
  • Commercial experience building and maintaining data pipelines within a cloud environment such as Azure or AWS.
  • Strong SQL skills and confidence coding in Python and/or PySpark.
  • Experience working with a modern data platform such as Databricks.
  • Experience in dimensional data modelling, data quality and pipeline optimisation.
  • Familiarity with CI/CD, automated testing, version control and technical documentation.
  • Good communication skills and the ability to collaborate across a distributed project team.

Exposure to dbt Core, Azure Data Factory, Salesforce, SAP, APIs or SharePoint integrations would be a bonus.

If you're keen to work on a substantial data transformation, get stuck into modern engineering technologies and build solutions that will have a lasting impact, we'd love to hear from you.

Applications will be reviewed as they are received, and the role may be filled before the closing date.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer
Data Engineer

Gallagher • Bay of Plenty

Hybrid
NZD 120,000 - 150,000
Flexible hybrid
Onsite parking
Cafe discounts
+2
Data Engineer
Data Engineer

Gallagher • Christchurch

Hybrid
Confidential
Data Engineer
Data Engineer

Gallagher • Auckland

Hybrid
Confidential
Flexible hybrid working
Free onsite parking
Boost App membership
+2
Data Engineer — Cloud Pipelines & Salesforce Migration
Data Engineer — Cloud Pipelines & Salesforce Migration

Gallagher • Bay of Plenty

Hybrid
NZD 120,000 - 150,000
Flexible hybrid
Onsite parking
Cafe discounts
+2
Software Engineer
Software Engineer

Gallagher • Hamilton

Hybrid
Confidential
Competitive salary
Annual bonus
Hybrid office/WFH
+4
Data Engineer - Cloud ELT & Salesforce Migration
Data Engineer - Cloud ELT & Salesforce Migration

Gallagher • Christchurch

Hybrid
Confidential
Cloud Data Engineer — Salesforce & SAP ELT Migration
Cloud Data Engineer — Salesforce & SAP ELT Migration

Gallagher Group Limited • Hamilton

Hybrid
NZD 110,000 - 165,000
Software Engineer Lead
Software Engineer Lead

Gallagher Group Limited • Hamilton

Hybrid
NZD 150,000 - 210,000
Competitive salary and bonuses
Hybrid flexibility
KiwiSaver on-top and Life and Disaster
+2
Software Engineer – Junior & Intermediate
Software Engineer – Junior & Intermediate

Gallagher Group • Hamilton

Hybrid
NZD 70,000 - 110,000
Hybrid work
Competitive salary
Professional development
+1
Customer Service / Sales Support Team Leader
Customer Service / Sales Support Team Leader

Gallagher Security • Hamilton

Hybrid
NZD 110,000 - 140,000
Hybrid work model
Competitive salary
Top locations