Back to jobs

Data Engineer - ETL + Azure Synapse + Snowflake

Pay
Pay not listed
Work setting
Not stated
Employment
Full-time — employment source
Employment type in the employer’s posting: FULL_TIME
From the employer’s posting

What you’ll work on

Full posting
  • Design, develop and maintain scalable data pipelines in Azure Synapse and Snowflake

  • Optimise SQL queries and workflows for performance

  • Ensure data accuracy, consistency and integrity across systems

  • Support enterprise data warehouse solutions and reporting requirements

  • Troubleshoot data issues and resolve performance bottlenecks

From the employer’s posting
design, develop, and maintain scalable data pipelines and 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.
Apply at Arthur J. Gallagher &

Posting record

Report an error

Open 4 monthsWe first saw this posting 131 days ago and it is still up. Roles open this long are often slow to fill or kept open to collect applications.

Status in our records
Live
First seen by us
Jul 13, 2026131 days ago
Recorded sightings
449
Last seen by us
Nov 21, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 131

Up longer than most. Similar jobs usually come down between day 6 and day 56.

From 14,767 similar postings that came down. Coming down is not always a hire.

Arthur J. Gallagher & is hiring

62 open jobs

Open jobs by the week we first saw them, last 12 weeks.

  • Hiring is picking up
  • Its jobs tend to stay up a long time
  • 3% of open jobs were reposted
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • SQL
  • Azure
  • dbt
  • Fivetran
  • Power BI
  • Snowflake
  • PySpark
Where the posting names them
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. #LI-Hybrid

Your next step

Complete your application on apacjobs-ajg.icims.com. The employer’s form will show what is required.

Applying through iCIMS

  • You start with your email. New applicants then create a login, and returning ones sign in.
  • Upload your resume before you fill anything in: iCIMS fills some profile fields from it.
  • Check your status on the employer’s iCIMS Dashboard, under Past Job Submittals.

Already applied? Track this application

Job description

View original posting ↗

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. #LI-Hybrid

About Arthur J. Gallagher &

People
About 72,000 in 2025, up 29% from the year before.Annual report (SEC Form 10-K)
Company
Listed as AJG.

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 845, the most 1,344, and the latest week had 1,007.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Colombo, Sri Lanka

This passage needs a closer read in the full description.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.