Data Engineer

Arthur J. Gallagher & Co. (AJG); Bogotá; On-site; COP 90,000,000 - 150,000,000; Full time

Job summary

Gallagher is hiring a Data Engineer to build trusted data across LATAM, enabling country onboarding, platform stability, and better decision-making. You will design and maintain reliable pipelines, ensure data quality, and collaborate with cross-functional teams across countries.

You'll work with Snowflake, dbt, Fivetran, and orchestration tools, contributing to scalable data products and strong governance across migrations and OneSource platforms.

Qualifications

• 4+ years of experience in data engineering or analytics engineering.
• Strong SQL skills and production data pipelines experience.
• Experience with cloud data platforms, ideally Snowflake.
• Hands-on with dbt, Fivetran, or similar ingestion/transformation tools.
• Experience with orchestration tools such as Airflow or Astronomer.
• Knowledge of data warehousing, dimensional modeling, APIs, and data products.
• Experience using Git, CI/CD, automated testing, and environment promotion.
• English and Spanish fluency; Portuguese a strong plus.

Responsibilities

• Help deliver reliable data solutions that support country migrations and platform needs.
• Build and maintain reusable data pipelines, checks, and controls for onboarding.
• Improve data movement across systems to increase trust and reliability.
• Strengthen data quality through profiling, validation, and reconciliation.
• Support stable OneSource data products that are easy to maintain and scale.
• Enhance observability, error handling, and production readiness.
• Collaborate with engineers, business teams, and country partners to translate needs into data solutions.
• Document processes and share knowledge across teams.

Skills

Data engineering

Analytics engineering

Data integration

Data migration

SQL

Cloud data platforms

dbt

Fivetran

Airflow

Astronomer

Git

CI/CD

English/Spanish fluency

Education

Bachelor's degree in Computer Science or related field

Tools

Snowflake

dbt

Fivetran

Airflow

Astronomer

Git

CI/CD pipelines

Job description

Introduction

Welcome to Gallagher - a global community of people who bring bold ideas, deep expertise, and a shared commitment to doing what's right. We help clients navigate complexity with confidence by empowering businesses, communities, and individuals to thrive. At Gallagher, you'll find more than a job; you'll find a culture built on trust, driven by collaboration, and sustained by the belief that we're better together. Whether you join us in a client-facing role or as part of our brokerage division, our benefits and HR consulting division, or our corporate team, you'll have the opportunity to grow your career, make an impact, and be part of something bigger. Experience a workplace where you're encouraged to be yourself, supported to succeed, and inspired to keep learning. That's what it means to live The Gallagher Way.

Overview

Join our LATAM data team and help build trusted data that supports country onboarding, platform stability, and better decisions. This role matters because the data you help move, shape, and protect will be used across the OPTIMA LATAM ecosystem. We are hiring two Data Engineers with shared coverage across migration, integration, OneSource, and data quality. One role will lean more toward migration and integration. The other will lean more toward OneSource and data platform engineering. Both roles will work closely together and share knowledge to reduce single-person dependency and keep delivery moving. You will help create reliable data pipelines, stronger controls, and clear documentation. You will also help improve how teams work with data across countries. At Gallagher, we value inclusion, growth, wellbeing, and purpose.

How you'll make an impact

• Help deliver reliable data solutions that support country migrations and ongoing platform needs.
• Improve how data moves across systems so teams can trust what they use every day.
• Build reusable pipelines, checks, and controls that make future onboarding faster and safer.
• Strengthen data quality through profiling, validation, reconciliation, and clear issue resolution.
• Support stable OneSource data products that are easy to maintain and scale.
• Reduce risk by improving observability, error handling, and production readiness.
• Work with engineers, business teams, and country partners to turn needs into practical data solutions.
• Share knowledge through clear documentation, cross-training, and collaborative ways of working.
• Use artificial intelligence tools responsibly to support development, testing, and documentation.
• Help create a team environment where learning, inclusion, and shared ownership are part of the work.

About you

You may be a strong fit if you bring:

• 4 or more years of experience in data engineering, analytics engineering, data integration, data migration, or a related field.
• Strong SQL skills and hands-on experience building production data pipelines and transformations.
• Experience with cloud data platforms, ideally Snowflake.
• Practical experience with dbt, Fivetran, or similar ingestion and transformation tools.
• Experience with orchestration tools such as Airflow or Astronomer, or similar platforms.
• Experience with data migration work, including source analysis, mapping, profiling, validation, and reconciliation.
• A good understanding of data warehousing, layered architecture, dimensional modeling, application programming interfaces, and data products.
• Experience using Git, continuous integration and continuous delivery, automated testing, and environment promotion.
• The ability to troubleshoot data issues across systems and explain technical topics clearly.
• Comfort working across countries and with both technical and non-technical partners.
• Practical use of artificial intelligence in engineering work, with good judgment and validation.
• English and Spanish fluency. Portuguese is a strong plus.
• A bachelor's degree in Computer Science, Software Engineering, Information Systems, or similar experience.