Data Engineer - ETL + Azure Synapse + Snowflake

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 As a Data Engineer based in Sri Lanka, you’ll join a global team that champions collaboration, ethical practices, and growth. This role offers the opportunity to work with cutting-edge technologies like Azure Synapse Analytics, Snowflake, and ETL/ELT frameworks, contributing to impactful data solutions that drive business success.

How You'll Make An Impact In this role, you’ll design, develop, and maintain scalable data pipelines and solutions using Azure Synapse Analytics and Snowflake. You’ll optimise SQL queries, ensure data accuracy, and support enterprise data warehouse solutions. Collaborating with analysts, developers, and stakeholders, you’ll troubleshoot data-related issues and maintain technical documentation.

Here’s what you’ll be doing day-to-day:

• Building and supporting data solutions using Azure Synapse Analytics and Snowflake.
• Developing efficient data workflows and optimising SQL queries for performance.
• Ensuring data accuracy, consistency, and integrity across systems.
• Supporting enterprise data warehouse solutions and reporting requirements.
• Troubleshooting data-related issues and resolving performance bottlenecks.

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

• 3-4+ years of experience in Data Engineering, ETL/ELT development, and cloud-based data platforms.
• Proficiency in Azure Synapse Analytics, Snowflake, SQL, ETL/ELT, and Azure Data Factory.
• Experience in data warehousing, data modelling, and data quality governance.
• A collaborative mindset to work with cross-functional teams and stakeholders.
• A degree in Computer Science, Information Technology, or a related field.
• Knowledge of Python, PySpark, DBT, Fivetran, Azure DevOps, Power BI, and ADLS is a plus.