Senior Data Engineer — AI-Ready Data Pipelines

Bain & Company; Hidalgo; Presencial; MXN 900.000 - 1.300.000; Jornada completa

Descripción de la vacante

Bain & Company seeks a Senior Data Engineer to own data ingestion, transformation, and quality infrastructure for Artemis, Bain’s AI-driven marketing platform. You will build pipelines for media spend, impressions, panel data, and retailer feeds, turning raw data into model-ready inputs for Bayesian models and channel analytics.

Design scalable data models, integrate third-party and Bain data sources, and collaborate with AI engineers to support LLM workflows.

Formación

• Strong Python skills for data processing with libraries like pandas or polars.
• Experience with schema validation libraries such as Pydantic or Great Expectations.
• Solid relational database experience and data modeling for analytics.
• Experience building and maintaining data pipelines in cloud environments (Azure/AWS/GCP).
• Ability to ingest, normalize, and integrate heterogeneous data sources for analytics and AI workflows.

Responsabilidades

• Ingest, validate, and transform client datasets into clean, model-ready inputs.
• Build reliable, testable ETL pipelines adaptable to diverse data formats.
• Maintain data quality and documentation conforming to the data model across engagements.
• Design adaptable data models and manage integrations with third-party and proprietary datasets.
• Collaborate with AI engineers to ensure data layers support LLM-powered workflows.

Conocimientos

Python

Data processing

Schema validation

ETL automation

SQL/Relational databases

Data modeling

Agile teamwork

Educación

Associate/Bachelor's degree or equivalent

Herramientas

Azure Databricks

Delta Lake

Spark

Cloud platforms (Azure/AWS/GCP)

Descripción del empleo

Bain & Company seeks a Senior Data Engineer to own data ingestion, transformation, and quality infrastructure for Artemis, Bain’s AI-driven marketing platform. You will build pipelines for media spend, impressions, panel data, and retailer feeds, turning raw data into model-ready inputs for Bayesian models and channel analytics.

Design scalable data models, integrate third-party and Bain data sources, and collaborate with AI engineers to support LLM workflows.