About the role
AgileEngine is seeking a Mid-level Data Engineer to build and maintain dbt pipelines and Snowflake data marts powering customer-facing reporting, spend analytics, and AI features.
Ideal candidates have 3+ years in analytics/data engineering, strong SQL/Python, and hands-on experience with dbt, Airbyte, Prefect, and Snowflake. This role emphasizes production-grade pipelines, data quality, and secure data handling.
Build and maintain the dbt pipelines, data marts, and warehouse models that serve in-app reporting, spend analytics, AI features, and internal analytics, treating them as production systems. Translate complicated procurement business logic into maintainable, well-tested pipeline code. Build models within our data mart architecture, following grain, conformed dimensions, and incremental patterns. Contribute to and help build out the semantic layer that our internal MCP servers and AI agents query. Maintain the boundary between PII and agent/reporting-safe data. Build and maintain the FastAPI services that expose reporting marts to customers. Build and maintain ingestion pipelines (Airbyte, OneSchema, S3) into the warehouse, and support our Forward Deployed Engineering function in bringing customer data into our systems. Implement data quality checks: freshness, schema and reconciliation tests, and alerting. 3+ years in analytics engineering, data engineering, or a closely related role, including hands-on work on production data pipelines that other systems or customers depended on. Professional growth Competitive compensation Exciting projects Flextime