Data Engineer: AI Pipelines & Snowflake (Remote)

AgileEngine, LLC.; Perímetro Urbano Barranquilla; Hybrid; COP 292,047,000 - 421,845,000; Full time

Benefits offered by this job

Professional growth

Competitive USD-based pay

Exciting projects with Fortune 500

Flextime: remote and office options

Job summary

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

You will handle ingestion and orchestration with Airbyte and Prefect, write strong SQL and Python, and ensure data quality and governance across the warehouse and semantic layer.

Qualifications

• 3+ years in analytics engineering, data engineering, or a closely related role with production data pipelines.
• Solid dbt experience: modeling, tests, macros, and incremental models.
• Strong SQL and 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 for reporting, spend analytics, AI features, and internal analytics.
• Translate complex procurement logic into maintainable, well-tested pipeline code.
• Build models within the data mart architecture and propose improvements.
• Contribute to the semantic layer for MCP servers and AI agents to ensure consistent metrics.
• Maintain boundary between PII and agent/reporting-safe data.
• Build and maintain FastAPI services exposing reporting marts to customers.
• Ingest data into the warehouse using Airbyte, OneSchema, and S3; support Forward Deployed Engineering.
• Implement data quality checks: freshness, schema and reconciliation tests, and alerting.
• Implement metric definitions faithfully and communicate tradeoffs to stakeholders.
• Maintain documentation and lineage for trust.
• Tune Snowflake performance and cost within models.
• Share learnings through code review and team discussions.
• Communicate data meaning to engineering, product, and customer-facing teams.

Skills

SQL

Python

dbt experience

Data modeling

Snowflake

Ingestion tools

Airbyte

Prefect

Git

CI/CD

Tools

Snowflake

Airbyte

Prefect

FastAPI

Job description

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

You will handle ingestion and orchestration with Airbyte and Prefect, write strong SQL and Python, and ensure data quality and governance across the warehouse and semantic layer.