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, spend analytics, and AI features. You will implement data quality checks, model within data mart architecture, and contribute to a semantic layer used by MCP servers and AI agents.
The role requires 3+ years in data/analytics engineering, strong SQL and Python, and experience with Snowflake, dbt, and orchestration tools such as Airbyte or Prefect.
Build and maintain dbt pipelines, data marts, and warehouse models for in-app reporting and analytics. Translate complex procurement logic into maintainable, tested pipeline code. Develop models within data mart architecture following grain and conformance conventions. Contribute to semantic layer development for consistent metrics across systems. Maintain boundary between PII and reporting-safe data. Build and maintain FastAPI services exposing reporting marts to customers. Ingest data via Airbyte, OneSchema, and S3 into the warehouse. 3+ years in analytics or data engineering on production pipelines. Solid dbt experience: modeling, tests, macros, incremental models. Strong SQL and Python. Data modeling fundamentals: dimensional modeling, data marts, grain, 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 explanation. Professional growth Competitive USD pay Exciting projects Flextime