Senior Data Support Engineer - ETL + Azure Synapse

About the role

Gallagher is looking for a Senior Data Support Engineer to join its Global Data Operations team. You will ensure the stability, reliability and performance of enterprise data platforms, including insurance and financial data warehouses, and lead complex technical initiatives while mentoring a team of engineers.

Key responsibilities

• Manage and optimise data platforms, troubleshoot complex issues and carry out root cause analysis
• Act as technical leader and escalation point for advanced data and integration challenges
• Mentor and guide junior engineers
• Improve data quality, governance and metadata processes to meet standards such as SOX and GDPR
• Optimise query performance, data pipelines and system scalability using Azure Data Stack (Synapse, SQL, DevOps), Snowflake, DBT, Fivetran and Power BI
• Collaborate with cross-functional teams on integration and platform enhancements
• Write clean, scalable code, run code reviews and promote testing and UAT best practices
• Enhance CI/CD pipelines and automate support tasks

Required profile

• Bachelor's degree in Computer Science, Software Engineering or a related field, or equivalent experience
• 6-8+ years in data-centric support operations, with 3+ years in data engineering roles
• Strong leadership, mentoring and stakeholder management, with excellent problem-solving skills

Required skills

• SQL, data modelling and ETL/ELT processes
• Performance tuning
• Azure Data Stack (Synapse, SQL, DevOps), Snowflake, DBT, Fivetran and Power BI