Senior Data Engineer — DSP Data & AWS ETL (Flexible)

AgileEngine, LLC.; Puebla de Zaragoza; Híbrido; MXN 900.000 - 1.300.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Professional growth

Competitive compensation

Exciting projects

Flextime

Descripción de la vacante

AgileEngine, LLC is seeking a Senior Data Engineer in Puebla to lead replacing a third‑party ingestion tool with a custom ETL pipeline in its AWS environment. You will document logic, assess Fivetran vs.

build options, and deliver a standalone pipeline for client dashboards. Strong SQL and DSP data experience are required, with the ability to work across ingestion, backend, and data science collaboration to ensure accurate downstream outcomes.

Formación

• 4+ years of strong 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)
• 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
• Ability to ramp into existing attribution and scoring logic so ingestion output aligns with downstream dashboard needs

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/pipeline

DSP data

AWS data services

Educación

Bachelor's degree in Computer Science or related field

Herramientas

TapClicks

Fivetran

Descripción del empleo

AgileEngine, LLC is seeking a Senior Data Engineer in Puebla to lead replacing a third‑party ingestion tool with a custom ETL pipeline in its AWS environment. You will document logic, assess Fivetran vs.

build options, and deliver a standalone pipeline for client dashboards. Strong SQL and DSP data experience are required, with the ability to work across ingestion, backend, and data science collaboration to ensure accurate downstream outcomes.