About the Client
Our client is a premier, world-renowned specialty healthcare organization based in New York City, globally recognized for top-tier orthopedics and rheumatology. The organization is currently executing a multi-million-dollar enterprise transformation to fully leverage the massive amounts of data generated across the organization and deliver exceptional insights and next-generation automations. This project mandate is built on a core strategic principle: data first, use cases second. Rather than letting siloed software applications dictate organizational operations, the organization set out to construct a unified Databricks lakehouse spanning their core anchor platforms – Workday for ERP/HCM and Epic for EHR – ensuring the entire business is driven by centralized, trustworthy data. Rather than prejudging which data might be important to achieving this mission, the intention is to include as much data as possible to fully unlock future use cases that may not yet be conceived. Â
Challenge
The initial milestone of the client’s transformation required pulling all data from their primary source applications and landing it in Databricks, beginning with Workday. However, extracting data from Workday proved to be an significant technical hurdle that required Dispatch’s unique expertise:
- A Massive and Obscure API Ecosystem: Workday’s catalog spans more than 3,000 API methods, roughly 1,500 of which are dedicated solely to data collection. Identifying and isolating the exact endpoints needed was a major discovery effort.
- The Specialized Nature of Workday’s Data Model: While public Workday documentation implies a simple, plug-and-play extraction, native pipelines and integrators without deep Workday experience simply could not pull the client’s highly customized financial and organizational data models.
- Critical Financial Reporting Barriers: The organization’s most business-critical financial reporting could not be produced via native Workday API calls due to fundamental technical constraints.
- Healthcare-Grade Security & Governance: The scope of data involved highly sensitive financial records and personnel information. This required a deep, airtight security approach built to healthcare-grade compliance standards, where the client owned the overall governance framework while Dispatch ensured secure pipeline extraction.
Without a specialized advisory layer, manual workarounds and fragmented data pipelines threatened to stall platform adoption across executive leadership.
Solution
Dispatch stepped in as a specialized Workday advisor, working directly alongside the client’s internal data engineering teams and other partners. Bringing over a decade of deep Workday integration expertise, Dispatch was able to decomplexify Workday’s data models that off-the-shelf tools could not handle.
Operating within Databricks’ medallion architecture, Dispatch’s mandate was to land fully reconciled, trustworthy data into the Bronze layer, enabling the client’s engineering team to build out downstream reporting in the Silver and Gold layers (powered by Databricks SQL / Data Warehousing and Lakeflow):
- Rationalized and Documented the API Landscape: Reviewed roughly 1,470 Workday data-collection APIs and narrowed them down to approximately 490 core endpoints that reflected the exact finance and HR models of the business. For each endpoint, Dispatch provided complete technical documentation, parameter details, and sample XML.
- Engineered Custom Extraction Pipelines: Built fewer than 20 custom APIs / reports-as-a-service to pull complex data that native Workday APIs could not reach. This custom feed directly powered the client’s proprietary financial reporting engine, known internally as “X-Ray”.
- Designed the Refresh Architecture: To maximize platform efficiency and manage compute costs, Dispatch split endpoints by operational cadence—segmenting foundational and configurable data (loaded monthly or quarterly) from transactional data (scheduled daily via high-frequency syncs).
- Mapped and Enabled Lakehouse Data Linking: Walked the client’s data engineers through Workday’s internal primary keys, foreign keys, and reference IDs, enabling them to correctly join and link data across the Silver and Gold layers using native Databricks tools.
Value Delivered
Dispatch Workday expertise and approach helped accelerate time to value and unblocked access to critical enterprise data:
- Enterprise Data Architecture & Single Source of Truth: Data lands in the Lakehouse fully reconciled against the source Workday environment. Downstream teams gain complete trust in the numbers, allowing the organization to scale horizontally across new business units and vertically across deeper analytics far faster once the foundation is set.
- Financial Operations Transformation: The extraction pipeline feeds the client’s proprietary “X-Ray” financial engine on Workday ERP data inside Databricks. As highlighted by the client in their public industry summit presentation, this capability compressed their financial book close and board reporting cycle from ~90 days to just a few days.
- Executive Cultural Shift: The availability of reliable Lakehouse data triggered a cultural shift across leadership. Finance executives moved away from manual, spreadsheet-driven processes to becoming genuinely data-aware—now actively discussing lakehouse schemas, Gold reporting layers, and data architectures at the board level.
- Human Capital & Workforce Intelligence: High-frequency daily syncs keep the organizational and human capital models built in Databricks continuously updated. Sensitive personnel records remain fully protected to strict compliance standards, while the breadth of data retrieved establishes the foundation for Phase 2, which expands Lakehouse capabilities deeper into HR and HCM operations.
Summary
Workday’s data model is unique, and the breadth of API endpoints can be overwhelming. By combining deep Workday domain expertise with Databricks Lakeflow ingestion standards, Dispatch delivered the extraction architecture needed to provide a fully automated, secure data platform that powers board-level financial reporting, accelerates operational decisions, and establishes a scalable foundation for continuous healthcare innovation.