Data Engineer: dbt + Snowflake Pipelines (Remote)
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 like Airbyte or Prefect, 3+ years in data or analytics engineering on production pipelines, strong SQL and Python, dimensional modeling, Snowflake or similar cloud warehouse, and upper-intermediate English.
Build and maintain the dbt pipelines, data marts, and warehouse models that support in-app reporting, spend analytics, AI features, and internal analytics. Translate procurement business logic into maintainable, well-tested pipeline code. Build models within the data mart architecture and propose improvements. Contribute to the semantic layer queried by internal MCP servers and AI agents. Maintain data boundary for PII and reporting-safe data. Build and maintain FastAPI services exposing reporting marts. Create ingestion pipelines (Airbyte, OneSchema, S3) into the warehouse and support data onboarding. Implement data quality checks, freshness, schema tests, and alerting. Document lineage and ensure accessibility for humans and AI agents. Tune Snowflake performance and cost within models. Share learnings through code review and team discussions. Communicate data meanings to engineering, product, and customer teams. 3+ years in analytics engineering, data engineering, or a closely related role, including hands-on work on production data 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 FlextimeSkills
Sign in to read and join the discussion.