About the role
AgileEngine is seeking a Mid-level Data Engineer to build and maintain dbt pipelines, data marts, and Snowflake models behind customer-facing reporting, spend analytics, and AI features.
The role requires solid dbt experience, ingestion/orchestration tools (Airbyte, Prefect), 3+ years in data/analytics engineering on production pipelines, strong SQL and Python, dimensional modeling, and a modern cloud warehouse (Snowflake). Upper-intermediate English is expected.
Build and maintain dbt pipelines, data marts, and warehouse models for reporting and analytics. Translate procurement business logic into maintainable pipeline code. Develop data models within the data mart architecture and propose improvements. Contribute to semantic layer definitions used by MCP servers and AI agents. Maintain boundary between PII and reporting-safe data. Build FastAPI services exposing reporting marts to customers. Ingest data with Airbyte, OneSchema, and S3 into the warehouse. Implement data quality checks, freshness, schema tests, and alerts. Define metrics faithfully and resolve ambiguities with the team. Maintain documentation and data lineage for humans and AI. Tune Snowflake performance and cost in models built. Use guardrails and share learnings through code reviews and discussions. Communicate data meanings clearly to engineering, product, and customers. 3+ years in analytics/ data engineering on production pipelines. Solid dbt experience: modeling, tests, macros, incremental models. Strong SQL and Python skills. Dimensional modeling and data marts fundamentals. Experience with a modern cloud warehouse (Snowflake). Ingestion tooling and orchestration (Airbyte, Prefect). Familiarity with agentic coding tools and guardrails. Curiosity about business data and customer usage. Git, code review, CI/CD discipline. Ability to take a multi-sprint piece from spec to production. Professional growth Competitive USD-based compensation Exciting projects Flextime