Senior Data Engineer — Remote ETL Pipeline & DSP Data

AgileEngine; Colombia; Remote; COP 90,000,000 - 160,000,000; Full time

Job summary

AgileEngine is seeking a Senior Data Engineer to lead the replacement of a legacy ingestion tool with a custom ETL pipeline in an AWS environment. You will document existing logic, evaluate Fivetran vs build options, and build a standalone pipeline to power client dashboards.

You will work cross-functionally with data science and backend teams, supporting ingestion across Amazon API and DSP data sources, while maintaining a remote-friendly, flexible schedule.

Qualifications

• 4+ years of 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 managed ELT tools such as Fivetran.
• Ability to ramp into attribution and scoring logic.
• Growth mindset with mentorship and learning opportunities.
• Flexible, remote-friendly working style.

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, ingesting from the Amazon API and DSP data sources.
• Evaluate off-the-shelf vs custom-built ETL options with Infrastructure Lead.
• Design a standalone, owned pipeline to power client dashboards.
• Provide engineering support for AWS-based backend work as needed.
• Coordinate with data science teams to align ingestion with downstream models.

Skills

SQL

Data ingestion

DSP data

AWS data services

ETL pipelines

Back-end work

Fivetran

Attribution & scoring

Collaboration

Remote-ready

Tools

Fivetran

AWS ECS

Amazon Advertising API

Job description

AgileEngine is seeking a Senior Data Engineer to lead the replacement of a legacy ingestion tool with a custom ETL pipeline in an AWS environment. You will document existing logic, evaluate Fivetran vs build options, and build a standalone pipeline to power client dashboards.

You will work cross-functionally with data science and backend teams, supporting ingestion across Amazon API and DSP data sources, while maintaining a remote-friendly, flexible schedule.