Blog

4 Ways to Keep Insurance Data Quality Healthy

Yunus Burhani
Insurance Experts' Forum, July 22, 2014

“Know your customers” is the new data mantra for the 21st century. Clean, high-quality customer data gives insurers powerful marketing and service advantages and prevents expensive headaches. A well-conceived data warehouse is a good place to start, but as core insurance systems develop problems over time, data quality issues grow undetected in the data warehouse.

These problems usually only show up when reports are generated from the warehouse and business people question the validity of the data. By then it is too late, and correcting the problem will take much time and money.

So how do you avoid this problem? The answer lies in proactively finding small data problems before they get bigger. And once they’ve been found, fix them right away.

The same principles for running a great data warehouse apply to property/casualty, life and health insurers. All have complex challenges, but health insurers, which deal with patients, providers, employers and brokers, may face the biggest data challenges.

To avoid these data integrity issues, carriers should consider establishing a simple yet effective four-step program to good data health. 

1. Control totals. The standard approach is to keep track of the number of records in the file and make sure that same number ends up in warehouse. A good start, but take this concept further and use it with individual fields that are important for the business. For example, while loading patient data, we can get the control counts for male/female and match it with the membership system. Another example would be to get the control count based on age bands and make sure they match the membership system.

2. Aggregate data and check for trends. Your system should aggregate certain data to make sure that the percentage is as expected and lies within a trend. For example, in a typical month, 18 percent of members have claims. If it’s suddenly showing up as 8 percent or 28 percent, you know you probably have a data problem.

To track the change, calculate the percentage that matched up front and store it in the aggregate table. Storing of the aggregated data helps identify problems with the data quickly if normal trends change.

3. Set up automatic alerts. Your system should automatically issue alerts whenever it detects a problem: controls totals that do not match or a percentage that’s outside the range of expected results.

4. Build and empower data teams. Build a team whose job is to proactively identify the data quality issues. This team has to be knowledgeable about the business and understand trends. It should use the techniques outlined above to find problems and report them. Data quality team members should include representatives of various business departments and IT.

When any problems arise, the data quality team will report them to the data steward/governance team. The latter team is empowered to take prompt corrective action.

The key to making any data warehouse successful is to continually build trust and credibility in the data. Checking for data anomalies is not a one-time thing. It needs to be done continuously as part of a healthy data program.

Having a set of strategies to automate the checking of data quality helps maintain the trust in data over time. Building a support team that is vigilant about finding data quality issues is a must for ongoing data quality.

Yunus Burhani is a senior architect with X by 2, a technology consulting firm in Farmington Hills, Mich.

Readers are encouraged to respond to Yunus using the “Add Your Comments” box below. He can also be reached at yburhani@xby2.com.

This blog was exclusively written for Insurance Networking News. It may not be reposted or reused without permission from Insurance Networking News.

The opinions of bloggers on www.insurancenetworking.com do not necessarily reflect those of Insurance Networking News.

Comments (0)

Be the first to comment on this post using the section below.

Add Your Comments...

Already Registered?

If you have already registered to Insurance Networking News, please use the form below to login. When completed you will immeditely be directed to post a comment.

Forgot your password?

Not Registered?

You must be registered to post a comment. Click here to register.

Blog Archive

Wearables Poised to Reshape Insurer-Insured Relationship

Boosted by the impending release of the Apple Watch, wearable devices have received a fair amount of attention recently – and with good reason. This emergent technology has the potential to alter the way the health insurance industry operates on a fundamental level.

Core Transformation – The Ultimate Balancing Act

The core transformation journey requires companies to shift from reactive to proactive business models, incorporating maturing and emerging technologies, customizing and personalizing products, and accelerating speed to market while providing improved customer service.

Despite Valiant Efforts, Insurers' Consumer Ratings Drop

Insurers also are confronting waves of disruptive changes, including big data analytics, an aging population, ongoing economic uncertainty and the growing frequency and severity of natural disasters, which threaten to challenge and undermine businesses.

Why You Can't Take a Wrecking Ball to Your Legacy System

If you think of enterprises like collections of neighborhoods that need to be nurtured, you quickly see that architecture, not obliteration, is the key.

The Apple Bounce: Are Wearables Truly this Big?

I just don’t believe it; only 720,000 Androidwear watches were sold in 2014. Apple has been amazingly successful in so many markets. Were they always first? No, a lot of products before. Were they always best? Again, no, superior devices have fallen.

Ten Stats About Social, Mobile, Analytics, Big Data, Cloud and Digital

Deployment rates have grown in the year since Novarica’s last study on these topics.