Skip to content

Elizabeth-CJ/NovaTech

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

21 Commits
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

NovaTech Systems

Employee Attrition Analysis

Client Background

NovaTech Systems is a US-based mid-size technology company founded in 2012, specializing in enterprise software solutions, cloud infrastructure, and AI-powered data analytics platforms. Headquartered in Austin, Texas, NovaTech serves over 400 enterprise clients across North America, Europe, and Asia-Pacific. Over the past decade, the company has grown from a 200-person startup into a 1,480-employee organization, driven by rapid product expansion and three strategic acquisitions.

In recent years, NovaTech has faced increasing competition for technical talent as the enterprise software market tightens. The company's rapid headcount growth has not been matched by a proportional evolution of its compensation structure or career development frameworks, creating the retention vulnerabilities explored in this report.

Reporting to the Head of Operations, the People & Culture team conducted an in-depth exploration of NovaTech's employee attrition data to surface trends and to understand what the data reveals about the underlying drivers of turnover.

Executive Summary

Attrition at a Glance

NovaTech HR Dashboard

πŸ“„ Power BI Report

What the Data Reveals

Area Finding
Compensation 69% of all departing employees earned under $5,000/month. The relationship between pay and attrition is consistent and striking β€” the lower the salary band, the higher the exit rate.
Age & Career Stage The 26–35 age group is the largest exit segment across the organization. Employees at the early-to-mid point of their careers are leaving at a disproportionate rate.
Tenure Attrition spikes sharply in the first year of employment and again near year five β€” two distinct points where NovaTech is losing employees before they are fully integrated, and when they hit a growth ceiling.
Concentration Attrition is not evenly spread. The data reveals a significant concentration of exits within a specific salary tier, age band, and tenure window β€” pointing to a structural gap rather than a broad cultural issue.

Insights Deep-Dive

01 β€” Compensation

The most striking pattern in the attrition data is the relationship between salary and departure rate. Employees in the lowest salary band leave at dramatically higher rates than those earning more β€” a pattern that holds consistently across every department and role examined.

Monthly Salary Band Departures % of Total Attrition Retention Signal
Up to $5,000 ~164 ~69% πŸ”΄ Critical β€” primary driver across all roles
$5,000–$10,000 ~47 ~20% 🟑 High β€” below market for experienced tech talent
$10,000–$15,000 ~20 ~8% βšͺ Moderate β€” approaching competitive range
$15,000+ ~7 ~3% 🟒 Low β€” competitive compensation retains talent

Key Takeaway

  • Employees earning $15K+/month exit at roughly 1/23rd the rate of sub-$5K earners.
  • NovaTech's average salary of $6.50K/month sits just above the highest-attrition band β€” a large portion of the workforce is clustered dangerously close to the departure threshold.
  • Replacing one employee costs 50–200% of their annual salary. Raising pay for the sub-$5K cohort is almost certainly cheaper than replacing them.

02 β€” Age & Tenure

The age and tenure breakdowns reveal a clear profile β€” early-to-mid career employees in their first years at the company are disproportionately represented in the departure data.

Attrition by Age Group

Age Group Departures % of Total Attrition Risk Level
26–35 ~90 ~38% πŸ”΄ Critical
36–45 ~52 ~22% 🟑 High
18–25 ~48 ~20% 🟑 High
46–55 ~38 ~16% βšͺ Moderate
55+ ~10 ~4% 🟒 Low

Attrition by Tenure

Tenure Window Pattern Implication
Year 0–1 Sharp spike β€” highest exit point Employees leaving before full productivity is reached; recruitment and onboarding investment is lost
Years 2–4 Relative dip Employees who stay past year one do settle in β€” temporarily
Year 5 Secondary peak Stagnation point β€” no promotion, no salary adjustment β€” and employees exit

Key Takeaway

  • The year-one spike and year-five plateau point to two distinct retention failure modes.
  • Both align with the compensation findings: underpaid new hires leave quickly, and underpaid experienced employees eventually run out of patience.

03 β€” Concentration

Company-wide averages obscure where attrition is actually occurring. Filtering the data by department and role reveals that exits are heavily concentrated in one area of the business.

DeptAttritionsmall

R&D department accounts for 56% of attrition

Attrition by Department

Metric R&D Department Company Average
Employees 967 (65% of headcount) 1,480
Attrition Count 133 238
Attrition Rate 14% 16%
Avg Monthly Salary $6.28K $6.50K
Sub-$5K departures 83% 69%

R&D Attrition by Job Role

Job Role Departures % of R&D Attrition
Research Scientist 56 42.1%
Human Resources 32 24.1%
Sales Representative 23 17.3%
Laboratory Technician 19 14.3%
Manufacturing Director 3 2.3%

Deeper Dive

Research Scientist Role

Filtering to the role level confirms what the department data suggests. Attrition is not spread evenly across R&D. It is concentrated in a single job title, in the same salary band and age cohort identified above.

Metric Research Scientist R&D Dept Company
Headcount 578 967 1,480
Attrition 100 133 238
Attrition Rate 17% 14% 16%
Avg Age Leaving 36 37 37
Sub-$5K departures 69% 83% 69%

Age Group

The age breakdown reveals a clear profile. The 26 to 35 cohort accounts for the largest share of departures at every level of the data, pointing to a consistent early to mid career retention gap across the organization.

Age Group RS Departures % of RS Attrition Risk Level
26–35 50 50% πŸ”΄ Critical
36–45 21 21% 🟑 High
18–25 20 20% 🟑 High
46–55 9 9% βšͺ Moderate
55+ ~0 <1% 🟒 Low

Job Satisfaction Analysis

If compensation alone were driving exits, we would expect most departing employees to report dissatisfaction. The data is more nuanced β€” and more instructive.

Satisfaction Score RS Departures % of RS Total What It Signals
1 β€” Very Dissatisfied 31 31% Role design, management, or workload issues
2 β€” Dissatisfied 19 19% Engagement and culture concerns
3 β€” Neutral 29 29% Passively waiting for a better offer to arrive
4 β€” Satisfied 21 21% Happy at NovaTech β€” but paid more elsewhere

Key Takeaway

  • 21 satisfied employees still resigned. This is not a culture problem β€” it is a market pricing problem.
  • NovaTech cannot engage its way out of a compensation gap.
  • The Score 1–2 cohort (50% of departures) does respond to engagement and culture work β€” but those efforts will be undermined if the underlying compensation gap is not addressed first.

Recommendations

01 β€” Compensation Audit & Market Alignment

Critical 0–30 days

Conduct a full compensation benchmarking exercise for all employees earning under $7,500/month, prioritizing roles where the sub-$5K attrition pattern is strongest.

  • Raise the sub-$5K cohort to a minimum of $6,500–$7,000/month through immediate band adjustments
  • Implement a real-time counter-offer protocol for resignation conversations, with pre-approved budget authority for managers
  • Introduce a transparent salary band framework so employees can see their growth ceiling without needing an outside offer to discover it

02 β€” 90-Day Onboarding & Early Retention Program

High 30–60 days

The year-one attrition spike is the most expensive exit point in the business. Design a structured first-year experience that closes the gap between hire and full integration.

  • Assign a senior employee as mentor to every new hire through month six
  • Schedule a 60-day check-in and 90-day performance and compensation review as standing policy
  • Track 90-day satisfaction scores separately from annual engagement surveys as an early-warning flight risk indicator

03 β€” Career Progression Framework for the 26–35 Cohort

High 60–90 days

The 26–35 cohort is leaving at the stage of their careers when growth visibility matters most. A structured advancement framework gives this group a reason to stay.

  • Introduce tiered career levels with defined competency expectations, project ownership milestones, and associated salary bands
  • Cap time between levels at 18–24 months for high performers, with manager-driven promotion reviews
  • Introduce a $1,500–$2,500/year skills development budget per employee

04 β€” Exit Intelligence Program for Satisfied Leavers

Ongoing Continuous

~22% of all departing employees rated their satisfaction at the highest level and still resigned. NovaTech has no systematic way to understand what triggered these departures.

  • Commission structured exit interviews specifically targeting Score 4 leavers
  • Determine whether a counter-offer was made and, if not, what prevented it
  • Feed exit intelligence directly into the next compensation review cycle and total rewards benchmarking process

Expected Impact

If all four recommendations are implemented within 90 days, the following outcomes are projected over the subsequent 12-month period:

Metric Current 12-Month Target Primary Lever
Company attrition rate 16% 12–13% Compensation adjustment
Year 0–1 departures ~35–38 <15 90-day retention program
Sub-$5K band exits ~164 <80 Salary band adjustment
26–35 cohort attrition ~38% <25% Career ladder + compensation
Satisfied leavers (Score 4) ~52 <20 Counter-offer protocol + exit intel

About

HR data analysis exploring employee attrition trends for a mid-size tech company.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors