Marketing Analytics Data Engineer (Snowflake & Power BI)
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.
You will translate complex procurement logic into robust pipelines, contribute to semantic layers, and ensure data quality and governance across PII boundaries. Strong SQL, Python, and cloud data warehouse experience are required.
Build and maintain the dbt pipelines, data marts, and warehouse models serving in-app reporting, spend analytics, AI features, and internal analytics. Translate complex procurement business logic into maintainable, well-tested pipeline code. Build models within our data mart architecture and propose improvements where needed. Contribute to and help build the semantic layer for MCP servers and AI agents. Maintain the boundary between PII and agent/reporting-safe data. Build and maintain FastAPI services exposing reporting marts to customers. Build and maintain ingestion pipelines (Airbyte, OneSchema, S3) and support Forward Deployed Engineering in onboarding data. Implement data quality checks: freshness, schema tests, reconciliation tests, and alerting. 3+ years in analytics engineering or data engineering 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 with Fortune 500 and Flextime: remote and office optionsSkills
Sign in to read and join the discussion.