- Design semantic layers and metadata, including descriptions, metric definitions, and business context, so AI tools can query data accurately.
- Own data quality tests, metric definitions, and documentation.
- Develop dbt models that turn raw data into reliable, documented datasets.
- Keep real-time Amplitude reporting consistent with exact Snowflake and dbt reporting.
- Build, run, and monitor ingestion pipelines that bring product, payments, marketing, and third-party data into Snowflake.
- Orchestrate pipelines in Airflow, with alerting and clear recovery paths.
- Design event tracking plans with product teams.
SQLApache AirflowSnowflake+2 more