About the role
AgileEngine is seeking a Mid-level Data Engineer to build and maintain dbt pipelines and Snowflake data marts behind customer-facing reporting and analytics. You will own production data pipelines, ensure data quality, and support AI features with strong SQL and Python skills.
You will collaborate with engineers and product teams to translate complex business logic into reliable data models, while maintaining data governance around PII and reporting-safe data.
- 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 for MCP servers and AI agents. - Maintain the boundary between PII and agent/reporting-safe data. - Build and maintain FastAPI services exposing reporting marts to customers. - Build and maintain ingestion pipelines (Airbyte, OneSchema, S3) into the warehouse. - Implement data quality checks: freshness, schema tests, reconciliation tests, and alerting. - Keep documentation and lineage current for humans and AI agents. - Tune Snowflake performance and cost within models. > 3+ years in analytics engineering, data engineering, or closely related role with production 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. Professional growth Competitive compensation Exciting projects Flextime