Data Engineer: dbt, Snowflake, AI Analytics (Remote)

AgileEngine, LLC.; Capital; Hybrid; COP 227,147,000 - 308,271,000; Full time

Benefits offered by this job

Professional growth

Competitive compensation

Exciting projects

Flextime

Job summary

AgileEngine, LLC. is seeking a Mid-level Data Engineer in Villavicencio, Colombia to build and maintain dbt pipelines and Snowflake data marts behind customer-facing reporting, spend analytics, and AI features.

You will implement data quality checks, ingestion pipelines (Airbyte, Prefect, S3), and contribute to the semantic layer for analytics, while collaborating with engineering and product teams.

Qualifications

• 3+ years in analytics engineering, data engineering, or a closely related role on production data pipelines.
• Solid dbt experience: modeling, tests, macros, and incremental models.
• Strong SQL and working Python.
• Data modeling fundamentals: dimensional modeling, data marts, grain and conformance.
• Experience with a modern cloud warehouse (Snowflake preferred).
• Experience with ingestion tooling and orchestration (Airbyte, Prefect, or equivalents).
• Familiarity with agentic coding tools and guardrails around their output.

Responsibilities

• Build and maintain dbt pipelines, data marts, and warehouse models serving in-app reporting and analytics.
• Translate complex procurement logic into maintainable pipeline code and validate models.
• Build models within the data mart architecture and propose improvements.
• Contribute to the semantic layer for MCP servers and AI agents, ensuring consistent metrics.

Skills

dbt experience

SQL

Python

dimensional modeling

Snowflake

Airbyte

Prefect

Git/CI–CD

Tools

Airbyte

Prefect

Snowflake

Job description

AgileEngine, LLC. is seeking a Mid-level Data Engineer in Villavicencio, Colombia to build and maintain dbt pipelines and Snowflake data marts behind customer-facing reporting, spend analytics, and AI features.

You will implement data quality checks, ingestion pipelines (Airbyte, Prefect, S3), and contribute to the semantic layer for analytics, while collaborating with engineering and product teams.