Data Engineer - Salesforce Migration

About the role

Gallagher is looking for a hands-on Data Engineer to join a large-scale Salesforce data migration as part of a multi-year Revenue Operations transformation programme. This is a 12-month fixed-term assignment in which you will bring together data from enterprise systems such as SAP, transform and integrate it, and build reliable, scalable data pipelines into and out of Salesforce. You will work alongside an existing external engineer and with guidance from the Senior Data Engineer and the wider Data, Analytics and AI team.

Key responsibilities

• Build, test and maintain cloud-based ELT pipelines and data integration solutions.
• Support the migration of data between Salesforce and enterprise platforms including SAP, Genesys Cloud 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 sound engineering practices across CI/CD, testing, code reviews and technical documentation.
• Collaborate with internal stakeholders, source-system specialists and Slalom engineers to deliver project milestones.

Required profile

• A practical, technically capable Data Engineer who takes ownership of their work and values quality and reliability.
• Strong engineering fundamentals and hands-on experience; the ability to pick up new technologies is valued.
• Good communication skills and the ability to collaborate across a distributed project team.

Required skills

• Ideally commercial experience building and maintaining data pipelines in a cloud environment such as Azure or AWS.
• Strong SQL skills and confidence coding in Python and/or PySpark.
• Experience with a modern data platform such as Databricks, dimensional data modelling, data quality and pipeline optimisation.
• Familiarity with CI/CD, automated testing, version control and technical documentation.
• Exposure to dbt Core, Azure Data Factory, Salesforce, SAP, APIs or SharePoint integrations is a bonus.

What we offer

• Flexible hybrid working, with the option to work remotely within New Zealand or from the Hamilton office.
• Free onsite parking, a subsidised café and local eateries in Hamilton.
• Boost App membership and staff discounts.
• Ongoing professional development and career growth opportunities.