Senior AI Data Engineer: Build Scalable AI Data Pipelines

Strategic Systems International; Ciudad de México; Presencial; MXN 900.000 - 1.500.000; Jornada completa

Descripción de la vacante

Strategic Systems International is seeking a Senior AI Data Engineer to design and operate the data foundation powering AI systems. You will model data, build scalable pipelines, and own the data contracts and lineage across source, warehouse, and retrieval layers.

The role emphasizes production-grade Python, Kimball-based modeling, and end-to-end governance for reliable, observable data flows in a fast-moving AI environment.

Formación

• 5–10+ years in software or data engineering, with substantial time in production data platform work.
• Expert-level SQL with window functions, CTEs, and performance tuning in a columnar warehouse.
• Production-grade Python with typing, packaging, dependency management, and testing.
• Strong design skills: SOLID, domain-driven design, bounded contexts.

Responsabilidades

• Design and evolve Kimball dimensional models and snowflake schemas with proper grain declarations.
• Build and operate batch and streaming ETL/ELT pipelines with Airflow, Prefect, or Dagster and ensure idempotent retries.
• Develop AI data pipelines for embedding generation, vector stores, and feature provisioning.
• Maintain end-to-end data lineage, governance, and cost management in cloud platforms.
• Collaborate with data scientists to provide reliable data foundations and governance.

Conocimientos

Data Warehousing

SQL

Python

Data Modeling

Orchestration

Cloud Platforms

Kubernetes

dbt

Data Quality

Kafka/Kinesis

Herramientas

Airflow

Prefect

Dagster

Iceberg

Delta Lake

Hudi

Kubernetes

dbt

SQL tooling

Descripción del empleo

Strategic Systems International is seeking a Senior AI Data Engineer to design and operate the data foundation powering AI systems. You will model data, build scalable pipelines, and own the data contracts and lineage across source, warehouse, and retrieval layers.

The role emphasizes production-grade Python, Kimball-based modeling, and end-to-end governance for reliable, observable data flows in a fast-moving AI environment.