- Design, build, and maintain scalable data warehouse models using SQL and dbt.
- Develop transformation workflows that turn raw data from multiple sources into analytics-ready datasets.
- Build, maintain, and troubleshoot pipelines and integrations for data from APIs, databases, and third-party systems.
- Implement automated tests, validations, and monitoring to ensure data accuracy and reliability.
- Document data models, pipelines, business definitions, and transformation logic.
- Define, implement, and standardize business metrics such as revenue, bookings, and churn.
- Work with analysts, business stakeholders, and engineering teams to understand requirements and deliver data solutions.
- Optimize SQL queries, dbt models, and pipelines for performance, scalability, and efficient warehouse resource use.
PythonSQLSnowflake+3 more