Sr Data Engineer
Core
Build and own dbt transformation models (staging, core, marts) and tests for a governed data platform serving a multi-location franchise brand.
Role type
Senior IC analytics engineer (dbt/Snowflake)
Builds
Production data models, tests, and documentation for a layered Snowflake instance
Domain
Retail/Franchise data engineering
Deliverable
production ML models
Required skills
dbt (layered modeling, incremental models, snapshots, SCD Type 2, macros, Jinja, packages), Snowflake (roles, grants, warehouses, UDFs, Secure Views, masking policies), SQL (window functions, semi-structured data), customer identity resolution, survivorship rules, PII/consent handling, Git workflows
Preferred skills
dbt Cloud administration, CDC modeling (Snowflake OpenFlow, AWS DMS), Zoho CRM/GA4/POS familiarity, multi-location reporting, Power BI mart building, Terraform
Technologies
dbt, Snowflake, dbt Cloud, Git, Power BI, Terraform, Zoho CRM, Customer.io, GA4
Responsibilities
Build and own dbt models from ticket to production, translate business rules into testable logic, collaborate with SMEs for definition sign-off, write tests and model contracts, maintain CI environments, review pull requests, reconcile model output against sources, document attributes and runbooks
Seniority
Senior, hands-on IC