LOA Analytics Intern: Data-Driven Workforce Insights

TikTok

San Jose (CA)

On-site

USD 44,000 - 60,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Benefits offered by this job

Health insurance

Life insurance

Well-being benefits

Paid holidays

Paid sick time

Housing allowance

Job summary

TikTok is seeking a Campus Intern in LOA Data Analytics to conduct descriptive, diagnostic, and predictive LOA analyses and to build dashboards that translate insights into actionable recommendations for policy improvements. You will collaborate with HR, payroll, and tech teams to integrate LOA data into HRIS, using SQL, Tableau/Power BI, and Excel; familiarity with FMLA and leave policies is a plus.

Interns receive day‑one health and life insurance benefits and housing allowance where

Qualifications

Pursuing Undergraduate or Masters in Data Science, Statistics, HR Management, Business Analytics, or a related field.
Proficiency in SQL or HQL to extract LOA data from HRIS/payroll systems.
Experience with Tableau, Power BI, or Power‑Query and advanced Excel (PivotTables, VLOOKUP, macros).
Basic knowledge of statistical analysis and data cleaning techniques.
Understanding of leave‑of‑absence types and relevant labor laws such as FMLA.
Knowledge of HR operations to contextualize LOA data insights.

Responsibilities

Conduct descriptive, diagnostic, and predictive analysis on LOA data.
Descriptive: track key LOA metrics such as total LOA cases per quarter, average leave duration by type, department‑wise leave rate, and approval/rejection rate.
Diagnostic: investigate anomalies such as spikes in medical leave and identify root causes (stress, illness, policy gaps).
Predictive: forecast future leave demand to support workforce planning.
Analyze LOA impact on payroll costs and hiring temporary staff.