Senior Data Engineer - Build Scalable AWS ETL for DSP Data

AgileEngine, LLC.; Ciudad de México; Hybrid; MXN 1,694,000 - 2,447,000; Full time

Benefits offered by this job

Professional growth

USD-based compensation

Fortune 500 projects

Flextime / remote options

Job summary

AgileEngine, LLC. is seeking a Senior Data Engineer to lead replacement of a third-party ingestion tool with a custom ETL pipeline in an existing AWS environment. You will document logic, evaluate Fivetran vs custom builds, and build a standalone pipeline for client dashboards.

The role requires strong SQL, experience with digital advertising/DSP data, and proficiency with AWS data services. Upper-intermediate English is required, with flex-time and work-from-home options.

Qualifications

• 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 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 for dashboards.
• Upper-intermediate English level.

Responsibilities

• 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.

Skills

SQL

Data ingestion

ETL

DSP data

AWS

Backend work

Tools

RDS

S3

ECS

Job description

AgileEngine, LLC. is seeking a Senior Data Engineer to lead replacement of a third-party ingestion tool with a custom ETL pipeline in an existing AWS environment. You will document logic, evaluate Fivetran vs custom builds, and build a standalone pipeline for client dashboards.

The role requires strong SQL, experience with digital advertising/DSP data, and proficiency with AWS data services. Upper-intermediate English is required, with flex-time and work-from-home options.