Our Daily QA Notification System sends daily emails to all admin users on the portal, providing details on ETL jobs/status and data quality check results.
The key benefits of these daily email notifications are ensuring that jobs are running as expected and reporting any anomalies within the data being processed. For example, if there is a zip code in the transactional data that does not exist within the master reference data, this email will contain an alert that a zip code is missing in the reference data. These alerts are as actionable as possible, containing details of exactly what is missing or unexpected in such a way as to suggest the resolution. While some anomalies are informational and age out after a certain number of days (ex: a market area description changed), others will persist until the issue is resolved (ex: duplicate keys in a table).