Leave of Absence Analyst Project Intern (HROP) - 2026 Start (BS/MS)

TikTok; San Jose (CA); On-site; USD 44,000 - 60,000; Full time

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.

Skills

SQL/HQL

Tableau

Power BI

Power Query

Excel (PivotTables, VLOOKUP)

Statistical analysis

HR operations understanding

Understanding of FMLA

Education

Undergraduate or Masters in Data Science, Statistics, HR Management, Business Analytics or related field

Tools

Tableau

Power BI

Power Query

Excel

Job description

Responsibilities

The HR Lifecycle Operations team strives to continuously build and deliver a seamless and positive employee experience across the whole employee lifecycle. As a Benefits Specialist at TikTok you will support various employee benefits, including but not limited to Leave of Absence (LOA), healthcare benefits, and the 401(k) retirement plan. The role also requires a Leave of Absence Analyst to audit, analyze, and visualize LOA data (sick leave, parental leave, medical leave, unpaid leave) to provide data‑driven insights that optimize LOA policies, reduce leave risks, improve workforce scheduling and enhance employee well‑being.

LOA Data Analysis & Trend Identification

• 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 sudden spikes in medical leave or unusually long unpaid leave and identify root causes like workplace stress, seasonal illnesses, or policy gaps.
• Predictive: Forecast future leave demand to support workforce planning.
• Analyze LOA impact on business operations and quantify associated costs such as payroll for paid leave and hiring temporary staff.

Reporting & Visualization

• Develop regular LOA reports and dashboards using tools such as Tableau, Power BI, Excel, or SQL.
• Translate complex data insights into clear, actionable recommendations.
• Present analysis results in meetings and tailor communication to non‑technical audiences.

Policy Optimization & Compliance Support

• Evaluate the effectiveness of existing LOA policies using data metrics and employee feedback.
• Provide data support for policy updates to ensure alignment with labor laws and industry best practices.
• Collaborate with HRBP teams to communicate policy changes to employees and track adoption rates.

Cross‑Functional Collaboration

• Partner with payroll teams to integrate LOA data with payroll processes.
• Work with department managers to address team‑specific LOA issues and develop targeted solutions.
• Liaise with tech teams to enhance HRIS functionality for LOA data tracking.

Minimum Qualifications

• Currently pursuing an Undergraduate or Masters in Data Science, Statistics, Human Resources 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.

Preferred Qualifications

• Experience in HR analytics or workforce analytics focusing on leave management or payroll.
• Certification in data analytics (e.g., Google Data Analytics Professional Certificate, Tableau Desktop Specialist) or HR (e.g., SHRM‑CP, PHR).
• Experience working in a global organization with familiarity of U.S. and multi‑country leave policies.
• Familiarity with HRIS platforms such as Workday or ADP.

Equal Opportunity Employment

Qualified applicants with arrest or conviction records will be considered in compliance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. Criminal history may affect the following job duties and could lead to withdrawal of a conditional offer:

• Interacting and having unsupervised contact with internal/external clients and/or colleagues.
• Managing confidential, proprietary, and trade‐secret information and access to information technology systems.
• Exercising sound judgment.

Job Information

Compensation Description (Hourly) – Campus Intern

Hourly rate range: $25.00 – $25.00.

Benefits may vary. Interns receive day‑one access to health insurance, life insurance, well‑being benefits, 10 paid holidays per year, and paid sick time.

Interns not working 100% remote may be eligible for a housing allowance.

The company reserves the right to modify or change these benefit programs at any time, with or without notice.

By submitting an application for this role, you accept and agree to our global applicant privacy policy.