Data Engineering and Analytics

Business Challenges

40+ data sources needed to be integrated with varied formats & layouts

11 critical business use cases, addressing pain points and defined future state

Data was not readily available for business consumption.

Solution Approach

Implemented medallion architecture (Bronze, Silver, and Gold enrichment layers.

Used Agile model and integrated teams for project execution.

Integrated diverse data sources including CSC (Member/Claims), Sales Force Marketing Cloud (Email Interactions), SFIS & Site Core (Web interactions), MyChart & Enterprise Audit (Portal Interactions), Census (Survey).

Build Power BI dashboard and Integrated Customer MDM.

Outcomes

Migrated 80+ reports from Qlik Sense platform to BI

Data activated from 8 sources & made available for end use

Established 30+ members hybrid team across US, India who are now being leveraged for additional tasks and projects as we have been able to instantiate client knowledge base across the team