Senior Data Engineer - AI/ML Pipelines & Semantic Layer

AgileEngine; Colombia; Híbrido; COP 120.000.000 - 180.000.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Flextime

Professional growth

Competitive compensation (USD-based)

Projects with Fortune 500 clients

Descripción de la vacante

AgileEngine is seeking a Senior/Lead Data Engineer to build and maintain HR data pipelines and semantic models. You will work with Snowflake, DBT, Python, and Airflow to empower BI tools and AI agents. Experience with Snowflake Cortex or MCP-based tooling is a strong plus.

You will design semantic layers, ensure data quality, and enable efficient querying across multiple data sources while maintaining security and reliability.

Formación

• 4+ years of experience.
• Snowflake, including data modeling, datamarts, and data warehouse design.
• DBT for data transformations.
• Python, including object-oriented programming and data scripting.
• Airflow for pipeline orchestration.
• REST API integration and data ingestion.
• Google BigQuery querying and optimization.
• Secure handling of large-scale and sensitive data.
• Real-time data processing.
• Strong SQL, including highly optimized queries.
• Comprehensive documentation skills.
• Upper-intermediate English level.

Responsabilidades

• Develop and maintain secure, efficient data pipelines for HR data sources.
• Build infrastructure and tooling for extract, transform, load using Python, DBT, Terraform and AWS technologies.
• Identify and implement internal process improvements; monitor pipelines for 99.5% uptime.
• Design semantic views and ontology layers over dbt models for BI and AI use.
• Develop and deploy AI agents for HR use cases enabling natural-language querying.
• Configure and maintain MCP connections between Snowflake and internal AI tooling.

Conocimientos

SQL proficiency

English communication

REST API integration

Real-time data processing

Documentation skills

Herramientas

Snowflake

DBT

Python

Airflow

Terraform

AWS (Glue, EMR, S3)

Google BigQuery

Descripción del empleo

AgileEngine is seeking a Senior/Lead Data Engineer to build and maintain HR data pipelines and semantic models. You will work with Snowflake, DBT, Python, and Airflow to empower BI tools and AI agents. Experience with Snowflake Cortex or MCP-based tooling is a strong plus.

You will design semantic layers, ensure data quality, and enable efficient querying across multiple data sources while maintaining security and reliability.