A

Arthur J. Gallagher & Co.

Global insurance brokerage, risk management, consulting

Senior Data Engineer - ETL, Azure Synapse

Data EngineeringUpdated on Nov 10
Full-timeColombo, Sri LankaNo salary listed

About the Job

Requirements

  • A bachelor's degree in Computer Science, Software Engineering, or a related field, or equivalent experience.
  • Six to eight or more years of experience in data-centric support operations, including three or more years in data engineering roles.
  • Proficiency in SQL, data modelling, ETL/ELT processes, and performance tuning.
  • Hands-on experience with Azure Data Stack, Snowflake, DBT, Fivetran, and Power BI.
  • Leadership, mentoring, stakeholder management, and problem-solving abilities.

Responsibilities

  • Ensure the stability, reliability, and performance of enterprise data platforms, including insurance and financial data warehouses.
  • Manage and optimise data platforms, troubleshoot complex issues, conduct root cause analyses, and implement solutions that enhance platform performance.
  • Act as a technical leader and escalation point for advanced data and integration challenges.
  • Mentor and guide junior engineers.
  • Improve data quality, governance, and metadata processes to ensure compliance with standards such as SOX and GDPR.
  • Optimise query performance, data pipelines, and system scalability using Azure Data Stack (Synapse, SQL, DevOps), Snowflake, DBT, Fivetran, and Power BI.
  • Collaborate with cross-functional teams to deliver integration and platform enhancements.
  • Write clean, scalable code; conduct code reviews; and promote best practices in testing and user acceptance testing.
  • Enhance CI/CD pipelines and automate support tasks to improve operational efficiency.

About the Company

Arthur J. Gallagher & Co.

Global insurance brokerage, risk management, consulting

Arthur J. Gallagher & Co. is a global insurance brokerage and risk management firm. It helps businesses, public entities, and individuals manage risk and obtain insurance through three segments: brokerage, risk management, and corporate. The brokerage unit offers a full range of retail and wholesale insurance brokerage and consulting services to match clients with coverage. The risk management unit handles contract claim settlements, claim administration, loss control consulting, and risk management information services to reduce exposures. The corporate unit oversees the company’s clean energy and other investments. The firm differentiates itself by providing end-to-end risk solutions across insurance placement, claims handling, risk counseling, and investment activities, rather than focusing on a single service. Its goal is to help clients manage risk effectively, protect assets, and pursue value through diverse investments, including clean energy.

Company size
10,001+
Company stage
IPO
Headquarters
Itasca, IL
Founded
1927

Recently Posted Jobs

Explore more opportunities at Arthur J. Gallagher & Co.

See more jobs