Data Engineer ID99039
Posted Updated
Description
AgileEngine is seeking a Mid-level Data Engineer to build and maintain dbt pipelines and Snowflake data marts for customer-facing reporting, spend analytics, and AI features. The role requires solid dbt experience, strong SQL and Python, and familiarity with Airbyte or Prefect for ingestion and orchestration.
The candidate will translate complex procurement logic into maintainable pipeline code, contribute to a semantic layer for MCP servers and AI agents, and ensure data quality and governance
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 the FastAPI services that expose 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. Implement metric definitions faithfully and flag conflicts or ambiguities. Keep documentation and lineage current for humans and AI agents. Tune Snowflake performance and cost within the models built. Use agentic coding tools within guardrails and review processes. Share lessons learned through code reviews and team discussions. Communicate clearly with engineering, product, and customer-facing teams about data meaning. 3+ years in analytics engineering, data engineering, or a closely related role. 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 an understanding of guardrails around their output. Professional growth Competitive compensation Exciting projects FlextimeSkills
Sign in to read and join the discussion.