Remote Data Engineer: AI & 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 like Airbyte or Prefect, 3+ years in data/analytics engineering on production pipelines, strong SQL and Python, dimensional modeling, and upper-intermediate English.
Build and maintain dbt pipelines, data marts, and warehouse models. Translate procurement logic into robust, tested pipelines. Develop models within data mart architecture with conformed dimensions. Contribute to semantic layer and ensure consistent metrics. Maintain boundary between PII and reporting-safe data. Build and maintain FastAPI services exposing reporting marts. Ingest data using Airbyte, OneSchema, and S3 into the warehouse. Implement data quality checks and alerting for data freshness and schema. Document lineage and ensure discoverability for humans and AI. Tune Snowflake performance and cost in models. 3+ years in analytics engineering or data engineering on production pipelines. Solid dbt experience: modeling, tests, macros, incremental models. Strong SQL and Python skills. Data modeling fundamentals: dimensional modeling and data marts. Experience with a modern cloud warehouse (Snowflake preferred). Experience with ingestion/orchestration tools (Airbyte, Prefect). Familiarity with guardrails for AI/agentic tooling and data governance. Curiosity about business data and customer use cases. Software engineering discipline: Git, code review, CI/CD. Professional growth Competitive compensation Exciting projects FlextimeSkills
Sign in to read and join the discussion.