Data wrangling is a critical process in data preparation that can significantly improve data quality. Effective data wrangling techniques, which consists of 6 steps i.e. Discovery, Structuring, Cleaning, Enriching, Validating, Publishing, can help Corporate Human Resource Division to ensure that their data is of high quality and ready for analysis. In this case study, we explore how effective data wrangling techniques can be used to improve data quality in employee data consolidation. We found employee data downloaded from various sources, captured incomplete, unreliable, or incorrect so that it could affect data analysis. Data wrangling seeks to remove that risk by ensuring data is in a reliable state before it’s analyzed and leveraged. We analyze a dataset from multiple sources of employee data and demonstrate how data wrangling techniques can be used to clean and transform the data to improve data quality and ready for analysis. Our study provides empirical evidence of the impact of data wrangling on data quality and highlights the importance of this process in employee data consolidation and provide workforce analytics.