Senior Data Engineer - AWS ETL & DSP Data Pipeline

AgileEngine; Pereira; Híbrido; COP 372.694.000 - 496.925.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Professional growth

Competitive compensation

Exciting projects

Flextime

Descripción de la vacante

AgileEngine is seeking a Senior Data Engineer to lead the replacement of a third-party ingestion tool with a custom ETL pipeline in an existing AWS environment. You will document current logic, compare build-vs-buy options like Fivetran, and build a standalone pipeline for dashboards.

Strong SQL and DSP data experience, plus knowledge of AWS data services, are essential. This role offers flextime and USD-based compensation with opportunities for growth.

Formación

• 4+ years of SQL and large-scale data ingestion experience.
• Experience with digital advertising / DSP data (e.g., Amazon DSP or similar).
• 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 ELT tools such as Fivetran.
• Upper-intermediate English proficiency.

Responsabilidades

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

Conocimientos

SQL

Data ingestion

ETL

AWS

Digital advertising data

Herramientas

Fivetran

AWS ECS/S3/RDS

Descripción del empleo

AgileEngine is seeking a Senior Data Engineer to lead the replacement of a third-party ingestion tool with a custom ETL pipeline in an existing AWS environment. You will document current logic, compare build-vs-buy options like Fivetran, and build a standalone pipeline for dashboards.

Strong SQL and DSP data experience, plus knowledge of AWS data services, are essential. This role offers flextime and USD-based compensation with opportunities for growth.