Case Study: The Energy Authority achieves faster, automated data quality validation with SentryOne

A Faster Way to Validate Data Quality and Eliminate Manual Data Testing

The Energy Authority, a Jacksonville-based utility and trading organization, was building a new enterprise data warehouse and needed a faster, more reliable way to validate data quality than manual testing. Using SentryOne’s LegiTest, BI engineer Cameron Hunt and his team tackled challenges with slowly changing dimension loads, daily operational data feeds, and regression testing for stored procedures, all of which had been time-consuming and error-prone.

SentryOne’s automated data testing helped The Energy Authority catch bugs earlier, identify failing data feeds by 6am, and compare staging and procedure results across environments. The results were significant: daily issue resolution dropped from about 6 hours to roughly 1 hour, and regression testing time was reduced by an average of 6 hours before business testing, while improving confidence in code quality and lowering troubleshooting costs.

The Energy Authority

Cameron Hunt

Business Intelligence Engineer