The HCA team traditionally relied on a data warehouse to generate and disseminate insights. That data warehouse was no longer adequate for analytics because investments in SaaS-based applications like Workday, Microsoft 365, and online employee survey tools disconnected from the data warehouse. Furthermore, an insatiable demand for self-service analytics required the HCA team to rethink how to enable the broader organization to generate insights with reliable data.

An unusable data warehouse coupled with an endless demand for reliable data led to many challenges for the HCA team:

1. Analysts within the HCA team spent inordinate amounts of time manually aggregating employee-related data in siloed analytical applications that resulted in poor data quality and reusability issues

2. HR organization could not stay competitive to attract and retain talent in a competitive market because it could not personalize employee experience and growth path within the company.

3. The HCA team wanted to go to the Cloud to build a new data warehouse, but the Cloud was not certified by HR yet. Therefore HCA wanted an on-premises solution in the near term that could potentially move to the Cloud mid-to-long-term with little impact.

4. The HCA team did not have the skill sets to create a data warehouse using modern data platform principles transferrable to the Cloud that adhere to best practices and emerging enterprise investments in data governance and master data tools and processes.

5. COVID-19 further cemented the urgent need to allow the entire organization to understand employee sentiment and morale as employees started working remotely.

The goal was to get an initial (foundational) version of the data warehouse up and running in weeks rather than months as the days of taking six months to a year to build a data warehouse can no longer be justified. Therefore, the immediate action was to identify the core business processes and use cases that could dictate the initial scope of the data warehouse.

Productive Edge (P/E) applied its 5-Week Modern Data Execution Assessment service that provided HCA with an execution-ready blueprint architecture for a new data warehouse, including clear priorities, roadmap & costs. Through a series of remote workshops (due to COVID-19), PE brought together a wide variety of teams across the business and IT to:

• Define business processes and critical data needs

• Prioritize key data sources

• Define master data needs

• Define the scope for data governance focused on data quality and data catalog

• Define data security and access requirements

Using outputs from the workshops, Productive Edge:

• Created a data ingestion/cleansing plan for each data source

• Outlined an on-premise solution architecture blueprint leveraging Microsoft SQL Server and an on-premises data lake

• Prescribed a cloud “lift and shift” solution architecture blueprint using Azure services

• Created a crawl, walk, run execution strategy

• Defined the data governance, data security, and access process and solution

• Created DataOps processes and tooling to support Continuous Integration (CI) and Continuous Development (CD)

Following the initial planning phase, Productive Edge rapidly built the first core aspects of the data warehouse within eight weeks to support COVID-19 employee sentiment analysis needs as the primary use case.