# Staff Data Warehouse Engineer
**Company:** [Together AI](https://hotfix.jobs/companies/together-ai)
**Location:** San Francisco, CA
**Salary:** $240K-$275K
**Skills:** SQL, dbt, Airflow, Python, Spark, Scd Type 2, Star Schemas, Data Quality Checks, Master Data Management, Dimensional Modeling
**Posted:** 2026-03-12
> Designs and operates medallion data warehouse (bronze/silver/gold) for product, usage, and billing data. Builds Airflow pipelines, dbt transformations, and analytics models using SQL, Python, and Spark while leading data governance and quality.
## Job Description
## Responsibilities
- Architect and operate a medallion/curated data warehouse stack (**bronze/silver/gold**) for product, usage, billing, and operational data.
- Build and maintain **Airflow** orchestrated pipelines and **dbt** transformation projects (modular, tested, documented).
- Design analytics-ready models: **SCD Type 2**, **star schemas**, and appropriate **normalization** for upstream canonical layers.
- Lead **Master Data Management (MDM)** patterns (golden records, reference data, deduping, identity resolution).
- Implement and automate **data quality checks** (freshness, nulls, referential integrity, distribution drift, anomaly detection).
- Establish data governance habits: **data stewardship**, ownership, SLAs, and clear definitions for "source of truth."
- Build and maintain a **business semantic layer** (consistent metric definitions, dimensions, and reusable logic) used by notebooks/BI.
- Partner with stakeholders (Product, Engineering, Finance, GTM, Ops) to translate questions into durable datasets and metrics.
- Use **SQL**, **Python**, and **Spark** where scale demands it; optimize for correctness, performance, and cost.
- Mentor engineers and contribute to standards (code review, design docs, runbooks), paving the path to tech lead.

## Requirements
- Strong warehouse fundamentals and production experience delivering trusted datasets and metrics.
- Expert **SQL** (window functions, dimensional modeling, performance tuning).
- Hands-on with **dbt** (models, tests, docs, snapshots, macros) and **Airflow** (DAG design, backfills, reliability).
- Solid **Python** for data tooling and automation; experience with **Spark** (PySpark/SQL) is a plus.
- Practical experience with **SCD2**, star schemas, and handling slowly changing business entities.
- Strong stakeholder management: you can drive alignment on definitions, tradeoffs, and delivery timelines.
- High standards for data quality, reliability, and maintainability.

## Compensation
We offer competitive compensation, startup equity, health insurance and other competitive benefits. The US base salary range for this full-time position is: $240,000 - $275,000 + equity + benefits. Our salary ranges are determined by location, level and role. Individual compensation will be determined by experience, skills, and job-related knowledge.
**Apply:** https://hotfix.jobs/jobs/staff-data-warehouse-engineer-at-together-ai-69002d9b-aff1-44c9-b6f9-0938abff8f45
**Canonical:** https://hotfix.jobs/jobs/staff-data-warehouse-engineer-at-together-ai-69002d9b-aff1-44c9-b6f9-0938abff8f45