Our purpose at Gallagher is 'Protect what matters most' and we live it every day. Not only does our technology protect some of the world's highest security environments and agriculture businesses, but our purpose also means we care deeply about our people and their families. With operations in New Zealand, Australia, Asia, Africa, USA, Canada, the UK, and Europe and exports across the world, we provide our employees unrivalled globally focused career pathways.
The Opportunity
We are on the hunt for an experienced Senior Data Engineer to join our dynamic Information Services team at Gallagher. You'll be a key member of the team, focusing on driving enhancement of our Business Intelligence services & solutions.
You will be responsible for designing, developing, and maintaining data pipelines and platforms that enable better business insights and decision-making across the Gallagher Group.
You'll mentor a talented team, improving data processes, and integrating cutting-edge technologies to continuously innovate how we manage and use data.
Additionally, you will manage ELT environments and data governance practices, develop actionable data models using tools like dbt Core and Databricks, and collaborate with business stakeholders to translate data needs into effective solutions.
Key responsibilities include:
Operating, maintaining, and leading the development of data engineering solutions, ensuring performance, scalability, & usability of BI models & processes.
Developing high-quality dimensional data models and continuously improving analytics engineering processes.
Operating and maintaining Azure Data Factory, Databricks, and dbt CICD solutions, while leading improvements in CICD processes.
Collaborating on Power BI report development and administration and exploring advancements in BI technologies.
Engaging with business stakeholders to document business questions and relevant source system data.
The Fit
You have a blend of expertise in Azure Data Factory and Dimensional Data Modelling, strong problem-solving and analytical skills, and a collaborative and mentoring mindset. To succeed in this role, you'll also need:
Relevant bachelor's degree or higher in Statistics, Mathematics, or Computer Science, as well as 5+ years proven industry experience.
Databricks Data certificate, preferably Engineering Professional level.
Demonstrated record in business analysis and project delivery.
Proven experience in Azure DevOps pipelines and API data extraction solutions.
Proven experience in languages such as Python, SQL, PySpark, as well as knowledge of markup languages such as YAML and JSON for configuration and data interchange.
If you have experience in the following domains, this would be an advantage:
dbt, preferably in dbt Core
Working with ERP data, preferably SAP
Integrating SharePoint lists and document libraries into data solutions
Working with Azure Key Vault
Using Azure Logic Apps for automated workflows
Managing Azure virtual machines (VMs) and Azure Virtual Networks (VNets)
Working with Microsoft Entra ID for identity management
Proficiency in scripting and automation tools, enabling efficient data workflows, process automation, and systems integration.
Why Gallagher?
At Gallagher, we foster a supportive and family-friendly work environment, where collaboration, innovation, and continuous improvement are at the forefront of everything we do. We value work-life balance and prioritize the well-being of our employees. We also offer:
Free parking, subsidised on-site café, and great eateries nearby.
Life & Disability Insurance.
Boost App membership; Gallagher staff discounts at a variety of NZ stores.
Plenty of fun along the way; team building events, inspiring guest speakers, and team lunches.
Make a significant impact in Gallagher's Information Services team and contribute to the success of our global business. Apply now to become a valued member of #TeamGallagher.
#J-18808-Ljbffr