Internship Data & Analytics - Back-end Google Cloud

Job description

What will you do? Support the improvement of data governance across our analytics platform by documenting key datasets in BigQuery, enriching metadata, improving business definitions, and helping maintain a clear and usable data dictionary. Help classify data assets and contribute to better visibility of data lineage, ownership, and usage , so teams can find and trust the right data more easily. Contribute to data quality and observability initiatives by helping define checks for freshness, completeness, schema changes, and failed transformations in dbt and related pipelines. Assist in setting up or improving alerting and monitoring for critical data pipelines and analytical datasets, so issues can be detected earlier and followed up more consistently. Analyze pipeline and warehouse usage to identify opportunities for cost management and performance optimization in BigQuery and dbt, for example around model design, materialization choices, and query efficiency. Support the team in improving visibility of operational metadata such as run results, failures, and freshness indicators, and help make this information more actionable for reporting and support processes. Help review legacy...