Overview
Version 2 represents a complete architectural redesign of the WARLAB HR Datamart. Built from a formal Workday HRDP (Human Resource Data Platform) specification, it implements a proper star schema with SCD Type 2 slowly-changing dimensions, 14-table source feed simulation, and a comprehensive QA evidence framework. The project demonstrates how AI agents can build enterprise-grade data warehouse solutions when given well-structured specifications.
Architecture
The V2 architecture introduces several improvements:
14 Workday HRDP Feeds: Simulating the full breadth of a real Workday integration including companies, cost centers, department hierarchies, grade profiles, job classifications, locations, positions, compensation, and worker data
Star Schema: Proper dimensional modeling with fact tables for headcount and movements, plus conformed dimensions
SCD Type 2: Slowly-changing dimensions tracking historical state changes with effective dating
QA Evidence Framework: Automated validation covering row counts, primary key uniqueness, foreign key integrity, SCD2 overlap detection, headcount restatement, and movement metric verification
Tools & Technologies
Key Artifacts
Governance Notes
All data in this project is synthetically generated using realistic but entirely fictional employee lifecycles. The Workday HRDP schema structure is based on publicly available documentation. No proprietary schemas or real employee data were used.