Senior Data Engineer - AWS ETL & DSP Data Pipelines

AgileEngine, LLC.; Perímetro Urbano Manizales; On-site; COP 388,387,000 - 582,581,000; Full time

Benefits offered by this job

Professional growth

Competitive compensation

A selection of exciting projects

Flextime

Job summary

AgileEngine, LLC is seeking a Senior Data Engineer in Manizales, Colombia to lead the replacement of a third-party digital ingestion tool with a custom-built ETL pipeline within an existing AWS environment.

The role focuses on documenting legacy logic, evaluating build-vs-buy options like Fivetran, and delivering a standalone pipeline that powers client-facing dashboards, with strong emphasis on SQL and DSP data expertise.

Qualifications

• 4+ years of strong SQL and large-scale data ingestion/pipeline experience
• 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

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

DSP data experience

AWS data services

ETL/ELT tooling evaluation

Backend integration

Tools

TapClicks

Fivetran

Amazon DSP/API

Job description

AgileEngine, LLC is seeking a Senior Data Engineer in Manizales, Colombia to lead the replacement of a third-party digital ingestion tool with a custom-built ETL pipeline within an existing AWS environment.

The role focuses on documenting legacy logic, evaluating build-vs-buy options like Fivetran, and delivering a standalone pipeline that powers client-facing dashboards, with strong emphasis on SQL and DSP data expertise.