Senior Data Engineer | Flexible AWS ETL Pipeline Lead

AgileEngine; Rosarito; Presencial; MXN 1.032.000 - 1.547.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Professional growth

Competitive compensation

Exciting projects

Flextime

Descripción de la vacante

AgileEngine in Baja California, Mexico, seeks a Senior Data Engineer to lead the replacement of a third-party digital ingestion tool with a custom ETL pipeline in an existing AWS environment. You will document current logic, evaluate build-vs-buy options such as Fivetran, and build a standalone pipeline to support client dashboards for DSP data.

Collaborate with data science teams, work within ECS/S3/RDS, and ensure ingestion aligns with downstream models while maintaining an English-friendly,

Formación

• 4+ years of SQL and large-scale data ingestion/pipeline experience.
• Direct or adjacent experience with digital advertising / DSP data.
• Working knowledge of AWS data services (RDS/Postgres, S3, ECS).
• Upper-intermediate English level.

Responsabilidades

• Document current ingestion logic inside the legacy tool (TapClicks), including sources, endpoints, schemas, and transformation logic.
• Build the ETL pipeline to replace the legacy system, handling ingestion from the Amazon API, other DSP platforms, and related digital data sources.
• Evaluate and decide between off-the-shelf solutions (e.g., Fivetran) and custom-built ETL systems alongside the Infrastructure Lead.
• Design the pipeline as a standalone, owned system to power client-facing dashboards.
• Provide flexible engineering support for application and backend work within the AWS environment when directed.
• Coordinate with data science teams to ensure ingestion output aligns with the attribution and scoring logic of downstream models.
• Work seamlessly within the existing AWS environment (ECS, S3, RDS) rather than standing up parallel infrastructure.

Conocimientos

SQL

Data ingestion

ETL

AWS

DSP data

English

Herramientas

AWS ECS

Amazon S3

Amazon RDS

Descripción del empleo

AgileEngine in Baja California, Mexico, seeks a Senior Data Engineer to lead the replacement of a third-party digital ingestion tool with a custom ETL pipeline in an existing AWS environment. You will document current logic, evaluate build-vs-buy options such as Fivetran, and build a standalone pipeline to support client dashboards for DSP data.

Collaborate with data science teams, work within ECS/S3/RDS, and ensure ingestion aligns with downstream models while maintaining an English-friendly,