Tenant-Aware HR Master Data Harmonization: A Logical Bronze-Silver-MDM-Gold Workflow for Multi-Tenant HCM Data
DOI:
https://doi.org/10.57159/jcmm.5.5.261468Keywords:
Human Resources Analytics, Master Data Management, Tenant-Aware Harmonization, Entity Resolution, Data Quality, Logical Data WorkflowAbstract
Enterprise human resources (HR) systems often apply inconsistent labels to shared employee master-data attributes. This study evaluates an ordered, tenant-aware harmonization workflow represented by Bronze, Silver, master data management (MDM), and Gold logical layers; it does not claim an implemented transactional lakehouse platform. Four synthetic HR datasets contribute 3,000 core employee records. A fixed-seed simulation creates four tenants and introduces controlled categorical corruption, missingness, and duplicate identifiers while retaining independent canonical labels. Exact, normalized, synonym, and bounded fuzzy matching run in sequence, and unresolved nonmissing values are referred for manual review. At a fuzzy cutoff of 0.82, the study records 8,842 nonmissing field values, 8,731 canonical assignments, and 8,480 correct assignments, giving 98.74% assignment coverage, 95.91% recall under the study definition, and an F1 of 0.9651. Field-level denominators reconstructed from the method-by-field matrix allow independent arithmetic checking and identify 251 erroneous assignments across all four matching tiers. In the deduplicated employee classification population, department and job-title vocabularies shrink from 228 raw labels to 37 mastered labels. The downstream comparison gives mixed point estimates: ROC-AUC rises by 0.0321 and PR-AUC by 0.0005, while F1 falls by 0.0181. Because paired confidence intervals and counterfactual harmonizer runs are not available, the downstream benefit is inconclusive and the robustness of the threshold is not established. Interpretation is limited to one simulation and one held-out split. The contribution is a documented logical integration protocol with an arithmetically auditable, single-cutoff synthetic benchmark result.
References
[1] M. Armbrust, A. Ghodsi, R. Xin, and M. Zaharia, "Lakehouse: A new generation of open platforms that unify data warehousing and advanced analytics," in Proceedings of the 11th Annual Conference on Innovative Data Systems Research (CIDR), (Online), 2021.
[2] D. Orescanin and T. Hlupic, "Data lakehouse: A novel step in analytics architecture," in 2021 44th International Convention on Information, Communication and Electronic Technology (MIPRO), pp. 1242-1246, 2021.
[3] A. A. Harby and F. Zulkernine, "Data lakehouse: A survey and experimental study," Information Systems, vol. 127, p. 102460, 2025.
[4] A. Haug, A. M. Staskiewicz, and L. Hvam, "Strategies for master data management: A case study of an international hearing healthcare company," Information Systems Frontiers, vol. 25, no. 5, pp. 1903-1923, 2023.
[5] I. P. Fellegi and A. B. Sunter, "A theory for record linkage," Journal of the American Statistical Association, vol. 64, no. 328, pp. 1183-1210, 1969.
[6] V. Christophides, V. Efthymiou, T. Palpanas, G. Papadakis, and K. Stefanidis, "An overview of end-to-end entity resolution for big data," ACM Computing Surveys, vol. 53, no. 6, pp. 127:1-127:42, 2021.
[7] P. Christen, "A survey of indexing techniques for scalable record linkage and deduplication," IEEE Transactions on Knowledge and Data Engineering, vol. 24, no. 9, pp. 1537-1555, 2012.
[8] C. Batini, C. Cappiello, C. Francalanci, and A. Maurino, "Methodologies for data quality assessment and improvement," ACM Computing Surveys, vol. 41, no. 3, pp. 16:1-16:52, 2009.
[9] L. Ehrlinger and W. Wöß, "A survey of data quality measurement and monitoring tools," Frontiers in Big Data, vol. 5, p. 850611, 2022.
[10] R. Miller, H. Whelan, M. Chrubasik, D. Whittaker, P. Duncan, and J. Gregório, "A framework for current and new data quality dimensions: An overview," Data, vol. 9, no. 12, p. 151, 2024.
[11] M. Janssen, P. Brous, E. Estevez, L. S. Barbosa, and T. Janowski, "Data governance: Organizing data for trustworthy artificial intelligence," Government Information Quarterly, vol. 37, no. 3, p. 101493, 2020.
[12] M. D. Wilkinson, M. Dumontier, I. J. Aalbersberg, G. Appleton, M. Axton, A. Baak, N. Blomberg, J.-W. Boiten, L. Bonino da Silva Santos, P. E. Bourne, J. Bouwman, A. J. Brookes, T. Clark, M. Crosas, I. Dillo, O. Dumon, S. Edmunds, C. T. Evelo, R. Finkers, A. Gonzalez-Beltran, A. J. G. Gray, P. Groth, C. Goble, J. S. Grethe, J. Heringa, P. A. C. 't Hoen, R. Hooft, T. Kuhn, R. Kok, J. Kok, S. J. Lusher, M. E. Martone, A. Mons, A. L. Packer, B. Persson, P. Rocca-Serra, M. Roos, R. van Schaik, S.-A. Sansone, E. Schultes, T. Sengstag, T. Slater, G. Strawn, M. A. Swertz, M. Thompson, J. van der Lei, E. van Mulligen, J. Velterop, A. Waagmeester, P. Wittenburg, K. Wolstencroft, J. Zhao, and B. Mons, "The FAIR guiding principles for scientific data management and stewardship," Scientific Data, vol. 3, p. 160018, 2016.
[13] M. Herschel, R. Diestelkämper, and H. Ben Lahmar, "A survey on provenance: What for? What form? What from?," The VLDB Journal, vol. 26, no. 6, pp. 881-906, 2017.
[14] A. Boufassil, F. Bouhafer, M. Cherradi, and A. El Haddadi, "Data catalog: Approaches, trends, and future directions," in 2023 17th International Conference on Signal-Image Technology and Internet-Based Systems (SITIS), pp. 369-376, 2023.
[15] A. Rafique, D. Van Landuyt, and W. Joosen, "PERSIST: Policy-based data management middleware for multi-tenant SaaS leveraging federated cloud storage," Journal of Grid Computing, vol. 16, no. 2, pp. 165-194, 2018.
[16] R. Kumar, "Multi-tenant SaaS architectures: Design principles and security considerations," Journal of Software Engineering and Simulation, vol. 6, no. 5, pp. 28-41, 2020.
[17] J. Hu and C. M. Bowen, "Advancing microdata privacy protection: A review of synthetic data methods," WIREs Computational Statistics, vol. 16, no. 1, p. e1636, 2024.
[18] A. Raza, K. Munir, M. Almutairi, F. Younas, and M. M. S. Fareed, "Predicting employee attrition using machine learning approaches," Applied Sciences, vol. 12, no. 13, p. 6424, 2022.
[19] D. Avrahami, D. Pessach, G. Singer, and H. Chalutz Ben-Gal, "A human resources analytics and machine-learning examination of turnover: Implications for theory and practice," International Journal of Manpower, vol. 43, no. 6, pp. 1405-1424, 2022.
[20] R. S. Rana, "Employee/HR dataset (all in one)." Kaggle dataset, CC0: Public Domain. https://www.kaggle.com/datasets/ravindrasinghrana/employeedataset, 2023. Accessed 4 October 2026.
[21] H. He and E. A. Garcia, "Learning from imbalanced data," IEEE Transactions on Knowledge and Data Engineering, vol. 21, no. 9, pp. 1263-1284, 2009.
[22] S. M. Lundberg and S.-I. Lee, "A unified approach to interpreting model predictions," in Advances in Neural Information Processing Systems, vol. 30, pp. 4765-4774, 2017.
[23] L. Breiman, "Random forests," Machine Learning, vol. 45, no. 1, pp. 5-32, 2001.
[24] scikit-learn developers, "Permutation feature importance." scikit-learn user guide, Section 5.2. https://scikit-learn.org/stable/modules/permutation_importance.html, 2026. Accessed 4 October 2026.
Downloads
Published
How to Cite
Issue
Section
Categories
License
Copyright (c) 2026 The Author(s)

This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.
Articles published in the Journal of Computers, Mechanical and Management are licensed under a CC BY-NC 4.0 license. Authors retain copyright of their work and grant the journal a non-exclusive license to publish, distribute, and archive the article. Full terms are on the Copyright and Licensing page.