- Build and maintain dbt models that transform source data into clean, tested datasets for analytics and reporting.
- Write SQL to investigate data issues, validate new sources, and answer stakeholder questions with accurate, reproducible logic.
- Implement data quality checks (dbt tests, freshness, reconciliations) and help resolve production data issues, including on-call rotation.
- Document models, metrics, and lineage so teammates and stakeholders understand definitions and dependencies.
- Partner with analysts and business teams to deliver production-ready data products—not just ad hoc queries.
- Use modern tooling—including AI-assisted frameworks—to move faster while keeping quality and review standards high.