Senior Data Engineer - Snowflake + Data Base Tools (DBT)

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 united by a commitment to innovation, service, and excellence. We are seeking a Senior Data Engineer to join our team in Colombo, Sri Lanka. In this role, you’ll design and deliver scalable, high-quality data solutions that empower our business to make informed decisions. If you’re a problem solver with a passion for data engineering and a desire to make an impact, this is your opportunity to thrive in a collaborative and inclusive environment. How you'll make an impact As a Senior Data Engineer, you’ll play a pivotal role in shaping our data landscape. You’ll design and maintain robust data pipelines, optimise data warehouse structures, and ensure the reliability and performance of our systems. Collaborating with stakeholders, you’ll translate business needs into technical solutions while adhering to data governance and security standards. Your expertise will help troubleshoot complex data challenges and drive innovation in our data engineering practices. Key contributions include: Building and optimising data models and pipelines to support business initiatives. Ensuring data quality, performance, and reliability across systems. Collaborating with cross-functional teams to deliver impactful data solutions. Addressing performance bottlenecks and resolving data-related issues. About you Here’s what you’ll bring to the role: 4+ years of experience in Data Engineering or a similar role. Proficiency in Microsoft SQL Server and SQL. Hands-on experience with ETL/ELT pipeline development. Knowledge of data warehousing and data modelling concepts. Familiarity with data security and compliance standards (e.g., GDPR). Experience with Snowflake Data Cloud and tools like FiveTran, DBT, Dataiku, and Collibra (preferred).Expertise in Microsoft Azure (e.g., Synapse, Azure DevOps). Programming skills in Python and C# Proficiency in Power BI and Microsoft Office 365. A background in the insurance domain is essential. #LI-Hybrid

Here’s what you’ll bring to the role: 4+ years of experience in Data Engineering or a similar role. Proficiency in Microsoft SQL Server and SQL. Hands-on experience with ETL/ELT pipeline development. Knowledge of data warehousing and data modelling concepts. Familiarity with data security and compliance standards (e.g., GDPR). Experience with Snowflake Data Cloud and tools like FiveTran, DBT, Dataiku, and Collibra (preferred).Expertise in Microsoft Azure (e.g., Synapse, Azure DevOps). Programming skills in Python and C# Proficiency in Power BI and Microsoft Office 365. A background in the insurance domain is essential. #LI-Hybrid

As a Senior Data Engineer, you’ll play a pivotal role in shaping our data landscape. You’ll design and maintain robust data pipelines, optimise data warehouse structures, and ensure the reliability and performance of our systems. Collaborating with stakeholders, you’ll translate business needs into technical solutions while adhering to data governance and security standards. Your expertise will help troubleshoot complex data challenges and drive innovation in our data engineering practices. Key contributions include: Building and optimising data models and pipelines to support business initiatives. Ensuring data quality, performance, and reliability across systems. Collaborating with cross-functional teams to deliver impactful data solutions. Addressing performance bottlenecks and resolving data-related issues.