Senior AI Data Engineer

Job Summary

We are seeking a Senior AI Data Engineer to design and operate the data foundation that our AI systems depend on. This role owns the movement, modeling, and quality of data from source systems through the warehouse and into the retrieval and feature layers that power LLM pipelines, agentic workflows, and analytical products.

The adecuado candidate is a rigorous software engineer first and a data specialist second: someone who models a warehouse deliberately, writes production Python that other engineers can extend, and treats pipelines as versioned, tested, observable software rather than scripts.

This role partners closely with the AI/ML Data Scientist, who owns model behavior and retrieval strategy. The boundary: you own the pipeline, the schema, and the guarantees; they own the algorithm, the prompt, and the evaluation.

Key Responsibilities

Data Warehousing & Dimensional Modeling

Design and evolve dimensional models using Kimball methodology - star schemas, conformed dimensions, an enterprise bus matrix,



and explicit fact-table grain declarations.

Implement transaction, periodic snapshot, and accumulating snapshot fact tables as the business process warrants, and defend the choice of grain.

Manage slowly changing dimensions (Type 1 / 2 / 3, and hybrid variants) with correct effective-dating, surrogate key strategy, and late-arriving dimension handling.

Model semi-structured and unstructured sources - documents, transcripts, event streams -into queryable structures without discarding provenance.

Maintain a governed semantic layer so that both human analysts and agentic consumers resolve the same metric to the same number.

Pipeline & ETL/ELT Engineering

Build and operate batch and streaming pipelines with orchestration frameworks such as Airflow, Prefect, or Dagster, including backfill, replay, and idempotent-retry semantics.

Implement ELT transformation layers with tested, documented, version-controlled SQL.

Own data

📌 Senior AI Data Engineer (Ciudad de México)
🏢 Strategic Systems International
📍 Ciudad de México