Data Engineer ID99039
Posted Updated
Description
AgileEngine is seeking a Mid-level Data Engineer to build and maintain dbt pipelines and Snowflake data marts that power customer-facing reporting, spend analytics, and AI features.
You will implement solid data ingestion (Airbyte, Prefect), maintain production pipelines, enforce data quality and governance, and develop FastAPI services to expose reporting marts, while optimizing Snowflake performance.
Build and maintain the dbt pipelines, data marts, and warehouse models for reporting and analytics. Translate procurement logic into maintainable pipeline code and validate models. Develop models within data mart architecture following grain and conformance conventions. Contribute to the semantic layer queried by MCP servers and AI agents. Maintain the 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 and alerting for production readiness. Document lineage and metrics definitions for reproducibility. Tune Snowflake performance and cost within the models. 3+ years in analytics engineering, data engineering, or a closely related role. Solid dbt: 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 importance. Deep curiosity about the business and data use. Professional growth Competitive compensation Exciting projects FlextimeSkills
Sign in to read and join the discussion.