Senior Data Engineer (4 - 5 Months Contractor)

The engagement runs across four phases. Total time investment is roughly 18 weeks core + 3 months ad-hoc support, so you can plan around it: Phase 1 — Build (Weeks 1–7) · ~80% commitment (4–5 days/week) - Design the data warehouse architecture — schemas, security model, data tiering, and the AI-ready data layer - Build the transformation...

MUST HAVE:

5+ years in data engineering or data warehousing - 3+ years with dbt Core — must have designed dbt projects from scratch, not just inherited them - Strong PostgreSQL — schema design, partitioning, roles/RLS, performance tuning Dimensional modeling — Kimball star schema, SCD Type 2, fact/dim design - Advanced SQL — window functions, CTEs,...

Khác: Full project documentation — extensive deliverable docs and UML diagrams of the current system, integration architecture, table schemas, and business logic. You won't be starting blind.