Endpoints / load-j1yko-0039 / employees / EMP-0033724

Hamish Mendes

EMP-0033724 · Employee · projected from the master template

employee_id: EMP-0033724
seq: 33,724
first_name: Hamish
last_name: Mendes
middle_initial: —
full_name: Hamish Mendes
work_email: hamish.mendes@vertexhaven.io
work_phone: +1-917-241-4190
home_address_line1: 1898 Lantern Way
job_title: Junior Data Analyst
job_code: DAT-00-1
job_family: Data & Analytics
flsa_status: exempt
job_level: 0
job_level_name: Associate
job_level_code: IC1
is_people_manager: no
is_executive: no
department_code: DAT
department_name: Data & Analytics
department_function: Technology
cost_center: CC-1600
location_code: US-CHI
location_city: Chicago
location_region: Illinois
location_country: United States
location_country_code: US
location_timezone: America/Chicago
manager_id: EMP-0004663
manager_seq: 4,663
direct_report_count: 0
org_depth: 8
employment_type: Full-time regular
work_arrangement: On-site
employment_status: active
hire_date: 2025-08-11
tenure_years: 1.09
termination_date: —
termination_reason: —
termination_voluntary: —
leave_type: —
date_of_birth: 1975-03-01
age: 51
gender: Male
ethnicity: White
base_salary_cents: 8,012,069
base_salary: $80,121
currency: USD
bonus_target_pct: 3%
bonus_target: $2,404
equity_units: 0
compa_ratio: 1.202
band_min_cents: 4,756,000
band_mid_cents: 5,800,000
band_max_cents: 7,192,000
department_ordinal: 10
location_ordinal: 4
employment_status_ordinal: 0
performance_rating: 4
engagement_score: 92
flight_risk_score: 6
tenure_days: 311

Compensation history (3)

compensation_event_id	employee_id	employee_name	effective_date	event_type	reason	percent_change
CMP-0033724-2	EMP-0033724	Hamish Mendes	2026-06-11	Off-cycle adjustment	Benchmark below market P50	7.19%
CMP-0033724-0	EMP-0033724	Hamish Mendes	2026-06-04	Retention award	Promotion to next level	2.96%
CMP-0033724-1	EMP-0033724	Hamish Mendes	2025-10-23	Promotion	Retention risk identified by manager	4.15%

Leave balances (8)

balance_id	employee_id	employee_name	leave_type_code	leave_type	accrued_days
BAL-0033724-0	EMP-0033724	Hamish Mendes	PTO	Paid time off	14.1
BAL-0033724-1	EMP-0033724	Hamish Mendes	SICK	Sick leave	7
BAL-0033724-2	EMP-0033724	Hamish Mendes	PARENT	Parental leave	59.1
BAL-0033724-3	EMP-0033724	Hamish Mendes	BEREAV	Bereavement leave	3.5
BAL-0033724-4	EMP-0033724	Hamish Mendes	JURY	Jury duty	7
BAL-0033724-5	EMP-0033724	Hamish Mendes	UNPAID	Unpaid leave of absence	21.1
BAL-0033724-6	EMP-0033724	Hamish Mendes	VOL	Volunteer day	1.4
BAL-0033724-7	EMP-0033724	Hamish Mendes	SAB	Sabbatical	21.1

Benefit enrollments (5)

enrollment_id	employee_id	employee_name	plan_code	plan_name	category	status
BEN-0033724-2	EMP-0033724	Hamish Mendes	401K-STD	401(k) - 4% match	Retirement	active
BEN-0033724-0	EMP-0033724	Hamish Mendes	MED-PPO-EE	PPO Medical - Employee only	Medical	active
BEN-0033724-3	EMP-0033724	Hamish Mendes	LIFE-SUP	Supplemental life (3x salary)	Life	active
BEN-0033724-1	EMP-0033724	Hamish Mendes	DEN-STD	Dental - Standard	Dental	active
BEN-0033724-4	EMP-0033724	Hamish Mendes	COMMUTE	Commuter benefits	Wellbeing	active

Recent payslips (21)

payslip_id	employee_id	employee_name	payroll_run_id	period_end	pay_date	gross_pay
PAY-0033724-0048	EMP-0033724	Hamish Mendes	RUN-0048	2026-06-17	2026-06-21	$3,939
PAY-0033724-0047	EMP-0033724	Hamish Mendes	RUN-0047	2026-06-02	2026-06-06	$3,338
PAY-0033724-0046	EMP-0033724	Hamish Mendes	RUN-0046	2026-05-18	2026-05-22	$3,338
PAY-0033724-0045	EMP-0033724	Hamish Mendes	RUN-0045	2026-05-03	2026-05-07	$3,338
PAY-0033724-0044	EMP-0033724	Hamish Mendes	RUN-0044	2026-04-18	2026-04-22	$3,338
PAY-0033724-0043	EMP-0033724	Hamish Mendes	RUN-0043	2026-04-03	2026-04-07	$3,338
PAY-0033724-0042	EMP-0033724	Hamish Mendes	RUN-0042	2026-03-19	2026-03-23	$3,939
PAY-0033724-0041	EMP-0033724	Hamish Mendes	RUN-0041	2026-03-04	2026-03-08	$3,338
PAY-0033724-0040	EMP-0033724	Hamish Mendes	RUN-0040	2026-02-17	2026-02-21	$3,338
PAY-0033724-0039	EMP-0033724	Hamish Mendes	RUN-0039	2026-02-02	2026-02-06	$3,338

See all 21 →