Data Engineer: DBT, Snowflake & Analytics Pipelines
Posted Updated
Description
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.
The role requires solid dbt experience, ingestion/orchestration tools such as Airbyte or Prefect, 3+ years in data or analytics engineering, strong SQL and Python, dimensional modeling, Snowflake or equivalents, and upper-intermediate English.
Build and maintain dbt pipelines, data marts, and warehouse models serving in-app reporting, spend analytics, and AI features. Translate complex procurement logic into maintainable, tested pipeline code. Build models within data mart architecture following grain and conformance conventions. Contribute to semantic layer for MCP servers and AI agents to query. Maintain boundary between PII and agent/reporting-safe data. Build and maintain FastAPI services exposing reporting marts to customers. Ingest data into the warehouse via Airbyte, OneSchema, or S3, supporting Forward Deployed Engineering. Implement data quality checks: freshness, schema, reconciliation, and alerting. Document and maintain data lineage for humans and AI agents. 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 (USD) Exciting projects FlextimeSkills
Sign in to read and join the discussion.