High Level Design

Overview

Understanding how the salary our company pays compares to what competing employers provide their employees in similar positions, in the same area or market, gives us insight into the competitiveness of our company as a potential employer and the level of temptation for existing employees to leave our company in favor of better paid jobs elsewhere. Companies want to ensure that they offer a salary that is fair and competitive on the one hand, while avoiding inflated salary costs on the other hand. Comparing our salary rate with those offered in the industry will provide these insights.

Dashboard Example (sample data)

Click on the image to open and interact with the dashboard:

Goals

Attract and retain talent by offering an attractive salary package to our employees.

Objectives

Offer our employees competitive salary which is between 5-10% above the industry averages.

KPI Architecture

Objectives KPIs Measures Data Source
Offer employees a competitive salary (between 5-10% above the industry averages) Salary Competitiveness Ratio (SCR)
Formula: Salary offered by our company / Salary offered by competitors
Number of Employees by Gender / Level
Formula: Count Employee ID.
fact_Employee_Salary,dim_Gender,dim_Positions
Our Avg. Salary compared to Competitors
Formula:
Average Employee Annual Salary,
Average Position Annual Salary.
fact_Employee_Salary, fact_Position_Benchmark_Vendors
Salary Distribution across our Departments

Formula: Minimum, first quartile, median, third quartile, and maximum of our Salaries

fact_Employee_Salary
Identify which covariate has significant impact on the probability to win a deal Win rate per dimension Average(Win Rate) per dimension’s value Survey Results; Client; Account Manager

Data Requirements

# Source Table Name Table Details (Type, # of Rows, Key field/s)
1 [ERP System] fact_Position_Benchmark_Vendors Contains annual salary data acquired from vendors providing industry HR data.
2 [ERP System] fact_Employee_Salary Contains our companies list of positions and payings across our departments, with history.
3 [ERP System] dim_Positions Contains the list positions, departments and level within the organization.
4 [ERP System] dim_Gender Contains the list of genders

Data Modeling (Elasticube Design)

Suggested data model for salary competitiveness analysis