Senior Data Engineer: Build DSP ETL Pipelines (Remote/Flex)

AgileEngine, LLC.; Colombia; On-site; COP 383,056,000 - 574,584,000; Full time

Benefits offered by this job

Professional growth

Competitive compensation

Exciting projects

Flextime

Job summary

AgileEngine, LLC. is seeking a Senior Data Engineer to lead the replacement of a third-party ingestion tool with a custom ETL pipeline. You will document existing logic, evaluate build-vs-buy options such as Fivetran, and build a standalone pipeline within an existing AWS environment.

Strong SQL and DSP data experience are central to this role. You will design the pipeline to power client dashboards, collaborate with data science teams, and contribute to backend work in AWS ECS/S3/RDS.

Qualifications

• 4+ years of strong SQL and large-scale data ingestion/pipeline experience
• Direct or adjacent experience with digital advertising / DSP data such as Amazon DSP or comparable platforms
• Working knowledge of AWS data services (RDS/Postgres, S3, ECS) 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 for downstream 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.
• 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 attribution and scoring logic of downstream models.
• Work within the existing AWS environment (ECS, S3, RDS) rather than standing up parallel infrastructure.

Skills

SQL & data ingestion

Digital advertising / DSP data

AWS data services

ELT tool evaluation (Fivetran)

English - Upper-intermediate

Tools

Fivetran

Job description

AgileEngine, LLC. is seeking a Senior Data Engineer to lead the replacement of a third-party ingestion tool with a custom ETL pipeline. You will document existing logic, evaluate build-vs-buy options such as Fivetran, and build a standalone pipeline within an existing AWS environment.

Strong SQL and DSP data experience are central to this role. You will design the pipeline to power client dashboards, collaborate with data science teams, and contribute to backend work in AWS ECS/S3/RDS.