Results
The new tool reduced analysis time from weeks to just a few minutes, allowing gender pay differences to be identified faster and more accurately. Analyses are more flexible and consistent, making the tool easier to use. This supports ING in actively promoting gender equality and transparency. Learn more in the gender pay gap analysis, and in the ING annual reports. This project aligns with our mission “Data for a Better Future” by promoting gender equality at work. It contributes to a fairer and more transparent workplace, which is an important part of broader societal progress and sustainable business practices.
The Process
Analyze
Together with the business owner, we identified the value of investing in understanding and reducing the gender pay gap. We reviewed the existing tool and found areas for improvement, such as creating a direct database connection, validating and cleaning data, and improving statistical analysis to generate accurate and actionable insights.
Strategy
Working with the HR Analytics team, we identified use cases and designed a modular system with clear components and strong analytical capabilities. We explored new statistical methods to improve analysis and planned for future needs.
Execute
We rewrote the script into an object-oriented version, applied best practices like logging and hypothesis testing, and documented the entire process. This made the tool reliable, easy to use, and added functionality for hypothesis testing. HR Analytics could now run simulations to determine the best ways to reduce the gender pay gap.
Maintain & Scale
The new system supports command-line options for hypothesis testing and includes Power BI dashboards. Its modular, object-oriented design makes it easy to adjust, maintain, and run analyses, with clear knowledge transfer and governance for the future.
The Technology
What the client says
"I was consistently impressed with his exceptional analytical skills, attention to detail, and ability to work collaboratively with other members of the team."
"He managed to deliver the agreed feature for our product within timeline & handover his work & knowledge to the team. He streamlined the old codebase into a new scalable one adding required documentation. He is very curious and challenges the choices and decision instead of following the requirements in a blindfold way."
"Floris demonstrated an exceptional level of expertise and dedication in the field of data science. His contributions were instrumental in achieving the project's objectives and provided invaluable insights into gender pay gap within our organization."