Building a Customized Data Pipeline

Top Health Insurance Provider Masters the Momentum of Technology

User-experience and member outreach are business critical in any industry, but especially for insurance providers. Our customer needed to build a reporting platform within their AWS tech stack to improve member data accuracy across three main Lines of Business (LOB) to customize outreach and inform user preferences.

Building a Member Preference Center Platform

Elevating the Member Experience

Our customer is a national health insurance provider that supports its members' entire health journeys. Managing a whole-health approach is a significant responsibility, so modernized reporting platforms are critical to enhance data availability, improve the refresh rate and build a delta processing pipeline for member data in their Preference Center. 
 
The result? Improved user experience, better communication preferences and increased health assessment participation. Identifying and understanding user outreach preferences also ensures they’re reaching the people who need those services most. Their ultimate goal? Supply the Chief Experience Officer’s (CXO) team with data on demand for Commercial, Medicare and Enterprise LOB to make informed outreach decisions.

Improving Data Availability and Refresh Rate

Informing the CXO of Trends and Opportunities

Working in collaboration with our customer, the TEKsystems Global Services (TGS) team road mapped a strategy to create a reporting and analytics solution within the Member Preference Center Platform. Our goal was to create a seamless and agile experience by modernizing their monolithic on-premises business capabilities to AWS cloud. With the use of modern cloud platforms, TGS developed repeatable, automated processes for designing databases and moving data.

Establishing Agile processes enabled consistent momentum and improved efficiency, delivering data and analytics to the CXO’s team so they can plan operational improvements. Our team used the customer’s existing technology tools to schedule automated weekly data updates, fine-tuning job performance in a memory-constrained environment.

Adding a Delta Processing Pipeline for Reporting

Automatically Gathering Data Across Three Lines of Business

To achieve everything our customer outlined in their original plan, we focused on developing and delivering automated data pipelines for use in self-service reporting. This pipeline solution, developed in the customer’s AWS tech stack, improve data availability.

As a result, the CXO team could receive data on demand for Commercial, Medicare and Enterprise members across over 3,300 fact scenarios, while reducing the cost of updating and distributing spreadsheets and freeing employees up for more complex tasks.

Real-World Results

Our customer’s CXO team now receives consistent, weekly updated aggregate data on 19 different member attributes ranging from communication preferences to results from health risk assessments. This enables marketing strategy development informed by data and centered around personalization. The customer will be able to reduce their time-to-market and lower the risk rate for trial-and-error for their campaigns, while ensuring that members receive critical health information.