HR Safe Space
Endpoints / load-j1yko-0036 / employees / EMP-0102224

Lucian A. Coelho

EMP-0102224 · Employee · projected from the master template

employee_id
EMP-0102224
seq
102,224
first_name
Lucian
last_name
Coelho
middle_initial
A
full_name
Lucian A. Coelho
work_email
lucian.a.coelho@tesseracourt.com
work_phone
+1-332-243-4393
home_address_line1
1706 Mill Pond Road
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
DE-BER
location_city
Berlin
location_region
Berlin
location_country
Germany
location_country_code
DE
location_timezone
Europe/Berlin
manager_id
EMP-0016353
manager_seq
16,353
direct_report_count
0
org_depth
8
employment_type
Intern
work_arrangement
Remote
employment_status
active
hire_date
2025-12-25
tenure_years
0.72
termination_date
—
termination_reason
—
termination_voluntary
—
leave_type
—
date_of_birth
1991-02-15
age
35
gender
Male
ethnicity
Black or African American
base_salary_cents
7,895,347
base_salary
$78,953
currency
EUR
bonus_target_pct
3%
bonus_target
$2,369
equity_units
0
compa_ratio
1.11
band_min_cents
4,756,000
band_mid_cents
5,800,000
band_max_cents
7,192,000
department_ordinal
10
location_ordinal
15
employment_status_ordinal
0
performance_rating
3
engagement_score
36
flight_risk_score
95
tenure_days
201

Compensation history (3)

compensation_event_idemployee_idemployee_nameeffective_dateevent_typereasonpercent_change
CMP-0102224-1EMP-0102224Lucian A. Coelho2026-05-14Retention awardExpanded scope of responsibility3.26%
CMP-0102224-0EMP-0102224Lucian A. Coelho2026-03-30Annual bonusPromotion to next level7.92%
CMP-0102224-2EMP-0102224Lucian A. Coelho2026-02-18Annual bonusContractual step increase4.63%

Leave balances (8)

balance_idemployee_idemployee_nameleave_type_codeleave_typeaccrued_daystaken_days
BAL-0102224-0EMP-0102224Lucian A. CoelhoPTOPaid time off110
BAL-0102224-1EMP-0102224Lucian A. CoelhoSICKSick leave5.50
BAL-0102224-2EMP-0102224Lucian A. CoelhoPARENTParental leave46.30
BAL-0102224-3EMP-0102224Lucian A. CoelhoBEREAVBereavement leave2.80
BAL-0102224-4EMP-0102224Lucian A. CoelhoJURYJury duty5.50
BAL-0102224-5EMP-0102224Lucian A. CoelhoUNPAIDUnpaid leave of absence16.50
BAL-0102224-6EMP-0102224Lucian A. CoelhoVOLVolunteer day1.10
BAL-0102224-7EMP-0102224Lucian A. CoelhoSABSabbatical16.50

Benefit enrollments (2)

enrollment_idemployee_idemployee_nameplan_codeplan_namecategorystatus
BEN-0102224-1EMP-0102224Lucian A. CoelhoDEN-FAMDental - FamilyDentalpending
BEN-0102224-0EMP-0102224Lucian A. CoelhoMED-HDHP-FAMHDHP + HSA - FamilyMedicalactive

Recent payslips (14)

payslip_idemployee_idemployee_namepayroll_run_idperiod_endpay_dategross_pay
PAY-0102224-0048EMP-0102224Lucian A. CoelhoRUN-00482026-07-132026-07-17$3,882
PAY-0102224-0047EMP-0102224Lucian A. CoelhoRUN-00472026-06-282026-07-02$3,290
PAY-0102224-0046EMP-0102224Lucian A. CoelhoRUN-00462026-06-132026-06-17$3,290
PAY-0102224-0045EMP-0102224Lucian A. CoelhoRUN-00452026-05-292026-06-02$3,290
PAY-0102224-0044EMP-0102224Lucian A. CoelhoRUN-00442026-05-142026-05-18$3,290
PAY-0102224-0043EMP-0102224Lucian A. CoelhoRUN-00432026-04-292026-05-03$3,290
PAY-0102224-0042EMP-0102224Lucian A. CoelhoRUN-00422026-04-142026-04-18$3,882
PAY-0102224-0041EMP-0102224Lucian A. CoelhoRUN-00412026-03-302026-04-03$3,290
PAY-0102224-0040EMP-0102224Lucian A. CoelhoRUN-00402026-03-152026-03-19$3,290
PAY-0102224-0039EMP-0102224Lucian A. CoelhoRUN-00392026-02-282026-03-04$3,290

See all 14 →