Data Engineer ID99039
Posted Updated
Description
AgileEngine, LLC. 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, strong SQL and Python, and experience with ingestion/orchestration tools like Airbyte or Prefect. 3+ years in analytics engineering on production pipelines are expected.
Build and maintain the dbt pipelines, data marts, and warehouse models that serve in-app reporting, spend analytics, AI features, and internal analytics, treating them as production systems. Translate complicated procurement business logic into maintainable, well-tested pipeline code, and notice when a model is valid-looking but wrong. Build models within our data mart architecture, following grain, conformed dimensions, and incremental patterns, and propose improvements. Contribute to and help buildout the semantic layer that our internal MCP servers and AI agents query, so that metrics and dimensions are defined once and answered consistently. Maintain the boundary between PII and agent/reporting-safe data. Build and maintain the FastAPI services that expose reporting marts to customers. Build and maintain ingestion pipelines (Airbyte, OneSchema, S3) into the warehouse, and support our Forward Deployed Engineering function in bringing customer data into our systems. Implement data quality checks: freshness, schema and reconciliation tests, and alerting, so problems surface before customers find them. Implement metric definitions faithfully, and flag conflicting or ambiguous definitions to the chapter rather than guessing. Keep documentation and lineage current so that humans and AI agents can both find and trust what's in the warehouse. Tune Snowflake performance and cost within the models you build. Use agentic coding tools in your daily work, within the guardrails the team maintains. Share what you learn through code review and team discussion. Communicate clearly with engineering, product, and customer-facing teams about what the data means and what it can and can't do. 3+ years in analytics engineering, data engineering, or a 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 data warehouse (Snowflake preferred). Experience with ingestion tooling and orchestration (Airbyte, Prefect, or equivalents). Familiarity with agentic coding tools and understanding guardrails around their output. Professional growth Competitive compensation Exciting projects FlextimeSkills
Sign in to read and join the discussion.