Senior Data Engineer – Snowflake + Data Build Tool (DBT)
About the role
Gallagher is seeking a Senior Data Engineer to join their team in Colombo, Sri Lanka. The role involves designing and delivering scalable, high-quality data solutions to support business decision-making. Responsibilities include building and optimizing data models and pipelines, ensuring data quality and reliability, collaborating with cross-functional teams, and addressing performance and data-related issues. The ideal candidate will have significant experience in data engineering, strong technical skills in SQL Server, ETL/ELT, data warehousing, and programming, as well as a background in the insurance domain. Gallagher offers a collaborative and inclusive environment focused on innovation and service excellence.
Must have
- 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).
- Programming skills in Python and C#
- Proficiency in Power BI and Microsoft Office 365.
- A background in the insurance domain is essential.
Nice to have
- Experience with Snowflake Data Cloud and tools like FiveTran, DBT, Dataiku, and Collibra (preferred).
- Expertise in Microsoft Azure (e.g., Synapse, Azure DevOps).
Technologies
- Azure
- Azure DevOps
- C#
- Data Engineering
- Data Modeling
- Data Pipelines
- Data Warehousing
- dbt
- ELT
- ETL
- Fivetran
- Microsoft 365
- Power BI
- Python
- Snowflake
- SQL
- SQL Server
Highlights
The position is based in Colombo, Sri Lanka. Experience in the insurance domain is essential. The company emphasizes a culture of teamwork, integrity, and career ownership. Application details are not specified in the listing.