AI Data Engineer: SQL, Snowflake & Data 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. Must have solid dbt experience, ingestion/orchestration tools like Airbyte or Prefect, and 3+ years in data engineering with strong SQL and Python.
The role involves producing production-grade pipelines, contributing to semantic models, and ensuring data quality and governance, with a flexible remote/office work setup.
Build and maintain dbt pipelines, data marts, and warehouse models for in-app reporting, spend analytics, and AI features. Translate procurement business logic into maintainable, tested pipeline code. Build models within the data mart architecture with grain and conformed dimensions. Contribute to the semantic layer used by MCP servers and AI agents. 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. Implement data quality checks: freshness, schema tests, reconciliation, and alerting. Keep documentation and lineage current for humans and AI agents. Tune Snowflake performance and cost within built models. 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 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-based Exciting projects Flextime: remote and office optionsSkills
Sign in to read and join the discussion.