Introduction

Welcome to Gallagher - a general 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

In this role, you'll shape the end to end data architecture for LATAM, from Salesforce and legacy system ingestion through to Snowflake, Azure, reporting, analytics, and AI use cases. You'll work across a regional setup with global standards, so the design supports country needs while staying scalable and consistent. You'll be based in LATAM, with Bogotá preferred and flexibility on location.

How you'll make an impact

In this role, you'll shape the end to end data architecture for LATAM and help make sure the full data flow works as one connected system. You'll work across ingestion, modelling, governance, reporting, and AI readiness, so the platform is scalable, consistent, and useful for the business.

- You'll define and evolve the regional data architecture across LATAM, covering ingestion, integration, transformation, storage, governance, and consumption.
- You'll design how data comes in from Salesforce and legacy systems, using tools such as Fivetran or similar solutions.
- You'll help make sure data is complete,



consistent, and reconciled across source systems and platform layers.
- You'll set data modelling standards that work for analytics, reporting, and multi country use.
- You'll design consumption layers that give BI teams, analysts, and business users the access they need.
- You'll help set up data governance, classification, and access controls so the platform is secure and well managed.
- You'll put in place data quality, validation, and reconciliation checks across the full lifecycle.
- You'll shape pipeline orchestration, including scheduling, dependencies, error handling, and monitoring.
- You'll support testing and validation, including SIT, UAT, and end to end data checks.
- You'll keep architecture documentation up to date, including data flows, schemas, and dependencies.
- You'll guide engineering and BI teams on architecture choices and best practice.
- You'll help the platform scale as new countries, systems, and data sources are added.
- You'll keep AI readiness in mind so the data environment can support advanced analytics and future GenAI use cases.

About you

- You have 8+ years of experience in data architecture, data engineering, or analytics engineering, and have delivered end to end data solutions in complex enterprise environments.
- You have a bachelor´s degree.
- You have hands-on experience with Snowflake or a similar cloud data platform, Azure data services, dbt, Fivetran, orchestration tools such as Airflow or Automic, Power BI, and advanced SQL.
- You understand Salesforce or similar CRM data models, and you have worked with data governance, security, access control, data quality, testing, CI/CD, and release management.
- You can work across regional and global stakeholders, explain technical decisions clearly, and keep architecture documentation up to date.
- You have advanced English and Spanish level. Portuguese is a plus.

📌 LatAm Data Architect (Colombia)
🏢 Gallagher
📍 Colombia