Senior Data Engineer - Build Scalable DSP Data Pipelines

AgileEngine; Región Centro; Híbrido; MXN 1.358.000 - 2.037.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Professional growth

Competitive USD-based compensation

A selection of exciting projects

Flextime

Descripción de la vacante

AgileEngine, a fast-growing software company, seeks a Senior Data Engineer to lead replacement of a third-party ingestion tool with a custom ETL pipeline in AWS. You will document existing logic, evaluate build-vs-buy options like Fivetran, and build a standalone pipeline within our AWS environment.

Strong SQL and DSP data experience are central to this role. You'll collaborate with data science and infrastructure teams to ensure ingestion aligns with attribution and scoring for dashboards,

Formación

• 4+ years of strong SQL and large-scale data ingestion/pipeline experience (batch ETL, orchestration, schema design).
• Direct or adjacent experience with digital advertising / DSP data (e.g., Amazon DSP, Amazon Advertising API, or comparable programmatic platforms).
• Working knowledge of AWS data services (RDS/Postgres, S3, ECS) sufficient to build within an existing cloud environment.
• Ability to contribute to application and backend work beyond pure ETL to support broader platform needs.
• Familiarity with, or ability to quickly evaluate, managed ELT tools (such as Fivetran) against custom builds.
• Ability to ramp into existing attribution and scoring logic so ingestion output aligns with downstream dashboard needs.
• 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 proficiency

ETL design

Data ingestion

DSP data

Herramientas

AWS RDS/Postgres

Amazon S3

ECS

Fivetran

Descripción del empleo

AgileEngine, a fast-growing software company, seeks a Senior Data Engineer to lead replacement of a third-party ingestion tool with a custom ETL pipeline in AWS. You will document existing logic, evaluate build-vs-buy options like Fivetran, and build a standalone pipeline within our AWS environment.

Strong SQL and DSP data experience are central to this role. You'll collaborate with data science and infrastructure teams to ensure ingestion aligns with attribution and scoring for dashboards,