Data Engineer: AI Pipelines & Snowflake (Remote)
Posted Updated
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.
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. 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. Professional growth Competitive USD-based pay Exciting projects with Fortune 500 Flextime: remote and office optionsSkills
Sign in to read and join the discussion.