← Back to portfolio

Data engineering and analytical storytelling

Anonymized Workforce Selection Analysis

A portfolio case study showing how a structured disclosure can become a validated, interactive decision experience while preserving privacy and clearly communicating statistical limitations.

PDF extractionData validationPrivacy thresholdsInteractive analyticsStatistical comparison

The analytical challenge

Turn a dense legal disclosure into clear, responsible evidence.

The source contained 829 anonymous employee records across 144 exact job titles. The workflow reconciled every row, defined the outcome carefully, grouped ages, calculated comparison rates and uncertainty, then removed granular records before publication.

Interactive cohort view

Workforce selection overview

Age-band selection changes the headline metrics and eligibility composition.

Listed

829

Eligible

158

Selection rate

19.1%

Listed employees

829

Complete population represented in the source disclosure.

Selected and eligible

158

Records meeting the disclosure's Eligible definition.

Selection rate

19.06%

Eligible records divided by all listed records in the selected scope.

Distinct source titles

144

Only five privacy-qualified groups are displayed below.

Eligibility composition

Eligible158

19.1% of the selected scope

Ineligible671

80.9% of the selected scope

Selection rate by age band

22-2911.4% · 5/44
30-3918.3% · 39/213
40-4919.0% · 51/268
50-5921.0% · 42/200
60+20.2% · 21/104

Selection rates by protected-age group

Under 4017.1% · 44/257
Age 40+19.9% · 114/572

Aggregate rate difference

Age 40+ minus under 40

+2.81 pts

Age 40+
19.9% (114/572)
Under 40
17.1% (44/257)
95% interval
-2.84 to 8.46 pts
Two-sided p-value
0.341

The observed aggregate difference is not statistically clear at the conventional 5% threshold.

Privacy-qualified job-title groups

Enterprise Platforms Product Manager36.0%
Senior QA Automation Test Engineer24.0%
Senior Application Development Engineer23.8%
Senior Business Systems Analyst20.7%
Application Development Engineer II18.5%

A title is displayed only when at least 10 employees are listed and both outcome cells contain at least five employees.

Selected title context

Senior Application Development Engineer

Listed

42

Eligible

10

Ineligible

32

Rate

23.8%

What this public dashboard excludes

  • • No names, employee identifiers, exact ages, source pages, or employee-level records.
  • • No employer name, original filename, source document, or unique job-title group.
  • • No title group with fewer than 10 listed employees or fewer than five people in either outcome.

These are descriptive aggregates from one decisional unit. They do not explain individual decisions or provide a legal conclusion.

Reconciled source

829 records reconcile to 158 Eligible and 671 Ineligible outcomes.

Public-safe grain

The published experience contains only aggregates. Exact ages and employee-level rows are excluded.

Interpretation boundary

Aggregate comparisons describe the listed population but do not explain individual decisions or establish a legal conclusion.