Data Operations Support Lead - ETL, Snowflake, Azure

About the role

Gallagher's Global Data Operations in Sri Lanka is looking for a Data Operations Support Lead, a senior technical and operational role. The position keeps enterprise production data platforms stable and reliable, with a focus on insurance and financial data warehouse environments. You will be the main escalation point for complex incidents, coordinate daily operational activity across teams, and support improvements to monitoring, automation, data governance and service health.

Key responsibilities

• Own the data operations intake process, including incident logging, triage, communication, prioritisation and follow-up.
• Act as the main escalation point for complex data pipeline, integration and platform issues.
• Coordinate day-to-day production support 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 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 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 take part in system integrations, data modernisation and platform upgrades.

Required profile

• 8+ years of experience in data operations, production support or a similar data-focused support role.
• Experience supporting recurring production data workflows in a time-sensitive environment.
• Experience managing incident intake, prioritisation, escalation and cross-functional coordination.
• Experience mentoring or giving 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.
• Willingness and ability to work US business hours on an assigned US time zone schedule.

Required skills

• Hands-on experience with ETL and ELT pipelines, data warehouses, data lakes and complex data transformations.
• Snowflake, dbt, Fivetran, Astronomer (Airflow), Automic Automation and Microsoft SQL Server.
• Azure Synapse, Azure SQL and Azure DevOps.
• Experience supporting SOX, GDPR and audit requests.