- Experience supporting Snowflake-based data platforms
- Robust understanding of data ingestion patterns (raw/bronze layers)
- Familiarity with enterprise data governance and security [mandatory] ? Experience of Fivetran SaaS and HVR
- Experience supporting DBT (DBT Cloud or DBT Core) production workloads
- Ability to operate in regulated / financial services environments
In respect of the DBT Support responsibilities will be:
- Monitor DBT job executions and platform health
- Investigate and resolve DBT job failures (model execution, dependency failures)
- Execute controlled re-runs of failed jobs in line with agreed procedures
Support backfill and reprocessing activities as directed Identify recurring failure patterns and raise problem records The vendor is responsible for operational support [as below] of ingestion and transformation pipelines.
Ownership of access management remains with the DBA function, and ownership of data quality rules and definitions remains with the Data Governance function. The vendor will support incident triage and resolution but will escalate data quality issues to the appropriate governance teams.
Triage incidents related to: o Data ingestion failures (Fivetran/HVR)
DBT job failures and dependency issues
Perform root cause analysis including: o Upstream ingestion impacts o Transformation job failures