Data Engineer

Gallagher

Auckland

Hybrid

Confidential

Full time

10 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Flexible hybrid working
Free onsite parking
Boost App membership
Staff discounts
Professional development

Job summary

Gallagher is seeking a hands-on Data Engineer for a 12-month fixed-term assignment to lead a Salesforce data migration as part of a Revenue Operations transformation. You will gather data from SAP and other systems, transform it into scalable pipelines, and enable reliable access for the business.

Focusing on Azure Data Factory, Databricks and dbt, you will build data models, optimize pipelines and collaborate with a distributed team to deliver tangible business impact.

Qualifications

  • Commercial experience building data pipelines in cloud environments.
  • Strong SQL skills with Python/PySpark development.
  • Experience with modern data platforms such as Databricks.

Responsibilities

  • Build, test and maintain cloud-based ELT pipelines and data integration solutions.
  • Support data migration between Salesforce and enterprise systems (e.g., SAP).
  • Develop and transform dimensional data models using SQL and Python/PySpark.
  • Work across Azure Data Factory, Databricks and dbt environments.
  • Improve pipeline performance, cost efficiency, and reliability.
  • Contribute to CI/CD, testing, documentation and collaboration with stakeholders.

Skills

SQL
Python
PySpark
Data pipelines

Tools

Azure Data Factory
Databricks
dbt

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 Group • Hamilton

Hybrid
NZD 110,000 - 165,000
Data Engineer
Data Engineer

Gallagher • Christchurch

Hybrid
Confidential
Data Engineer
Data Engineer

Gallagher • Bay of Plenty

Hybrid
NZD 120,000 - 150,000
Flexible hybrid
Onsite parking
Cafe discounts
+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
Software Engineer – Junior & Intermediate
Software Engineer – Junior & Intermediate

Gallagher Group • Hamilton

Hybrid
NZD 70,000 - 110,000
Hybrid work
Competitive salary
Professional development
+1
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
Junior, Intermediate and Senior Software Engineers
Junior, Intermediate and Senior Software Engineers

Gallagher Group Limited • Hamilton

Hybrid
NZD 80,000 - 120,000
Competitive salary
Bonuses
Hybrid flexibility
+4
Customer Service / Sales Support Team Leader
Customer Service / Sales Support Team Leader

Gallagher Security • Hamilton

Hybrid
NZD 120,000 - 160,000
Competitive salary and bonuses
Work from home flexibility
Free parking
+4
Top locations