Data Engineer ID99039
Posted Updated
Description
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.
You will own production data pipelines, translate complex business logic into robust code, and contribute to a semantic layer used by AI agents. The role emphasizes data quality, security, and collaboration with engineering and product teams.
Build and maintain the dbt pipelines, data marts, and warehouse models serving in-app reporting, spend analytics, AI features, and internal analytics. Translate complex procurement business logic into maintainable, well-tested pipeline code. Build models within our data mart architecture with proper grain, conformed dimensions, and incremental patterns. Contribute to and help build the semantic layer queried by MCP servers and AI agents. Maintain the boundary between PII and agent/reporting-safe data. Build and maintain FastAPI services that expose reporting marts to customers. Ingest data via Airbyte, OneSchema, S3 into the warehouse and support data onboarding. Implement data quality checks: freshness, schema, reconciliation tests, and alerting. Document lineage to ensure data trust for humans and AI. Tune Snowflake performance and cost within the models you build. Share learnings via code review and team discussions. Communicate data meaning and limitations clearly to engineering, product, and customer teams. 3+ years in analytics engineering, data engineering, or a closely related role with production data pipelines. Solid dbt experience: modeling, tests, macros, and incremental models. Strong SQL and Python skills. 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. Deep curiosity about business data and how customers use it. Software engineering discipline: Git, code review, CI/CD. Ability to deliver multi-sprint work from spec to production. Professional growth Competitive compensation Exciting projects FlextimeSkills
Sign in to read and join the discussion.