Senior Data Engineer – DSP Data & AWS ETL, Flextime

AgileEngine, LLC.; Perímetro Urbano Barranquilla; Hybrid; COP 379,711,000 - 569,566,000; Full time

Benefits offered by this job

Professional growth

Competitive USD-based compensation

Exciting projects with Fortune 500/Top

Flextime and remote/hybrid options

Job summary

AgileEngine, LLC. is seeking a Senior Data Engineer to lead replacing a third-party ingestion tool with a custom ETL pipeline in an existing AWS environment. You will document current logic, evaluate options like Fivetran, and build a standalone pipeline to power client dashboards.

The role requires strong SQL, experience with DSP data, and upper-intermediate English. Flextime and remote/hybrid work options are available, with competitive USD compensation.

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

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 pipelines

AWS data services

DSP data

English proficiency

Tools

Fivetran

TapClicks

Amazon DSP API

RDS

S3

ECS

Job description

AgileEngine, LLC. is seeking a Senior Data Engineer to lead replacing a third-party ingestion tool with a custom ETL pipeline in an existing AWS environment. You will document current logic, evaluate options like Fivetran, and build a standalone pipeline to power client dashboards.

The role requires strong SQL, experience with DSP data, and upper-intermediate English. Flextime and remote/hybrid work options are available, with competitive USD compensation.