Senior Data Engineer — Snowflake/DBT, HR Data Pipelines

AgileEngine, LLC.; Perímetro Urbano Manizales; On-site; COP 356,022,000 - 517,850,000; Full time

Benefits offered by this job

Professional growth

Competitive USD-based compensation

Exciting projects

Flextime

Job summary

AgileEngine, LLC. in Colombia is seeking a Senior/Lead Data Engineer to design, build, and maintain pipelines and data models behind a centralized HR data warehouse. You will work with Snowflake, DBT, Python, and Airflow to create semantic layers for BI tools and AI agents.

The role emphasizes reliable data processing, secure data handling, and real-time ingestion from diverse sources, with exposure to Snowflake Cortex and MCP tooling for agentic querying.

Qualifications

• 4+ years of experience in data engineering.
• Snowflake data modeling, datamarts, and data warehouse design.
• DBT for data transformations.
• Python 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 from diverse sources.
• Strong SQL with optimized queries.

Responsibilities

• Develop and maintain secure, efficient data pipelines using DBT, PySpark, and Python within a cloud environment for HR data sources.
• Build infrastructure and tooling for ETL of data from various sources using Python, DBT, Terraform, and AWS (Glue, EMR, S3).
• Identify and implement internal process improvements, develop tests within the Data Quality Framework, monitor pipelines to 99.5% uptime, and maintain data models for partner teams.
• Design semantic views and ontology layers on top of existing dbt models to make HR data consumable by BI tools and AI agents.
• Develop and deploy AI agents (Snowflake Cortex) for HR use cases enabling natural-language querying over HR data.
• Configure and maintain MCP connections between Snowflake and internal AI tooling to securely expose HR data to conversational interfaces.

Skills

SQL

Python

Airflow

REST API integration

Google BigQuery

Tools

Snowflake

DBT

PySpark

Terraform

AWS

Job description

AgileEngine, LLC. in Colombia is seeking a Senior/Lead Data Engineer to design, build, and maintain pipelines and data models behind a centralized HR data warehouse. You will work with Snowflake, DBT, Python, and Airflow to create semantic layers for BI tools and AI agents.

The role emphasizes reliable data processing, secure data handling, and real-time ingestion from diverse sources, with exposure to Snowflake Cortex and MCP tooling for agentic querying.