Data Engineer - Data Operations (Support & Development)

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 At Gallagher, we are innovative thinkers and service-minded individuals, united by a commitment to one another's growth and the pursuit of shared goals. As a Data Engineer - Data Operations , you’ll play a vital role in ensuring the stability, accuracy, and performance of our financial and insurance data platforms. Based in Sri Lanka, this role offers you the opportunity to collaborate with global teams, maintain a healthy data ecosystem, and contribute to operational excellence.

How You'll Make An Impact In this role, you’ll be at the heart of our data operations, ensuring the accuracy, consistency, and security of our data platforms. You’ll monitor and validate data pipelines, troubleshoot issues, and collaborate with cross-functional teams to optimise performance. Your work will directly support our mission to deliver tailored insurance solutions and effective risk management strategies.

You’ll also:

• Perform data validation, cleansing, and transformation to maintain data quality.
• Respond to service requests and incidents, diagnosing and resolving issues in data pipelines and systems.
• Enforce data access controls and support audit activities to ensure compliance.
• Monitor and optimise data ingestion jobs and query performance.
• Document data processes and contribute to service reports, including SLA metrics.
• Collaborate with global teams to support data modernisation and knowledge sharing.

About You Here’s what you’ll bring to the role:

• A bachelor’s degree in Computer Science, Software Engineering, Information Systems, or equivalent experience.
• 2-5+ years of experience in data-centric support operations, including ETL processes, data warehouses, and data lakes.
• Proficiency in SQL for querying and debugging, with knowledge of data modelling concepts.
• Familiarity with ITSM/ITIL environments and foundational knowledge of financial or insurance data domains.
• Strong communication and problem-solving skills, with a keen eye for detail and a commitment to data integrity.
• Awareness of data governance and security principles.

Technology Stack:

• Cloud Platforms: Azure Data Stack (Azure Synapse, Azure SQL, DevOps)
• Data Tools: Snowflake, DBT, Fivetran
• Databases: Microsoft SQL Server (including Master Data Services)
• Visualisation Tools: Power BI
• Other Tools: Microsoft 365 applications, ServiceNow