Data Operations Support Lead - ETL + Snowflake + Azure

Introduction At Gallagher, we help clients face risk with confidence because we believe that when businesses are protected, they’re free to grow, lead, and innovate. You’ll be backed by our digital ecosystem: a client-centric suite of consulting tools making it easier for you to meet your clients where they want to be met. Advanced data and analytics providing a comprehensive overview of the risk landscape is at your fingertips. Here, you’re not just improving clients' risk profiles, you’re building trust. You’ll find a culture grounded in teamwork, guided by integrity, and fueled by a shared commitment to do the right thing. We value curiosity, celebrate new ideas, and empower you to take ownership of your career while making a meaningful impact for the businesses we serve. If you’re ready to bring your unique perspective to a place where your work truly matters; think of Gallagher.

Overview The Data Operations Support Lead is a senior technical and operational role within Global Data Operations at Gallagher Sri Lanka. The role helps keep enterprise production data platforms stable, reliable, and performing well, with a focus on insurance and financial data warehouse environments. You’ll act as the main escalation point for complex incidents, coordinate daily operational activity across teams, and support improvements that strengthen monitoring, automation, data governance, and service health.

How You'll Make An Impact

• Own the data operations intake process, including incident logging, triage, communication, prioritisation, and follow-up actions.
• Act as the main escalation point for complex data pipeline, integration, and platform issues.
• Coordinate day-to-day production support activity with Data Engineering, DBAs, BI, Infrastructure, and Security teams.
• Help improve reliability, scalability, observability, and operational governance across enterprise data platforms.
• Support data integrity, transformation controls, lineage visibility, metadata management, and monitoring improvements.
• Review and help improve access controls, permissions, and data security standards.
• Contribute to architectural discussions, solution design reviews, and operational readiness checks for new data products.
• Prepare monthly service reports covering SLAs, KPIs, incidents, changes, and service health.
• Maintain clear documentation for pipelines, processes, dependencies, and workflows.
• Support SOX, GDPR, and internal audit activity, including evidence preparation, remediation, and control validation.
• Mentor support engineers and share practical guidance to improve team capability.
• Take part in system integrations, data modernisation, and platform upgrades.

About You

• 8+ years of experience in data operations, production support, or a similar data-focused support role.
• Hands-on experience with ETL and ELT pipelines, data warehouses, data lakes, and complex data transformations.
• Experience supporting recurring production data workflows in a time-sensitive environment.
• Experience with Snowflake, dbt, Fivetran, Astronomer (Airflow), Automic Automation, and Microsoft SQL Server.
• Experience with Azure Synapse, Azure SQL, and Azure DevOps.
• Experience managing incident intake, prioritisation, escalation, and cross-functional coordination.
• Experience mentoring or providing technical guidance to junior colleagues.
• Ability to explain technical issues clearly to technical and non-technical stakeholders.
• Ability to work independently, take ownership, and make sound escalation decisions.
• Familiarity with access controls, data security practices, and data governance requirements.
• Experience supporting SOX, GDPR, and audit requests.
• Willingness and ability to work US business hours on an assigned US time zone schedule.