Workforce Data Analytics (feat. LinkUp Job Postings)

Revelio Labs provides workforce intelligence analytics. We absorb and standardize hundreds of millions of public employment records to create the world's first universal HR database, allowing us to see workforce composition and trends of any company, public or private. We’ve created a standard structure to unify occupations and job titles, skills and activities, and companies and other organizations. Our team of data scientists, economists, and engineers use the latest methods in statistical research to remove sampling bias, and anticipate lags in reporting to create a comprehensive and current understanding of workforce dynamics in every region and across every industry. Our data provides insights on company composition, hiring and attrition trends, geographic composition, career transitions, diversity, and more.

Our data is extremely configurable. Check out our data dictionary for an overview of our standard data sets, and please reach out to us if you have a use case that doesn't fit cleanly into our standard offerings. We can probably create a dataset that works for you!

Here are some of the key tables we can generate:

Workforce Dynamics (Geography, Demographics, Roles, Skills)
Sentiment (Employee Review Trends, individual Reviews, sentiment analysis)
LinkUp Job Postings (posting dynamics, individual job postings)
Transitions (Inflows, Outflows)
Individual Level (Position history, user level skill, education)
Company Reference

Key data fields include:

1. Company Reference table:
- rcid (unique revelio company identifier)
- company
- ticker
- exchange_name
- cusip
- sedol
- isin
- naics_code
- lei
- cik
- linkedin_url
- website

2./3. Employee Review Trends/Individual Reviews table:
- rating_overall
- rating_career_opportunities
- rating_compensation_and_benefits
- rating_culture_and_values
- rating_diversity_and_inclusion
- rating_senior_leadership
- rating_work_life_balance
- rating_business_outlook

4. Job Posting Dynamics table:
- job_category
- start_date
- active_posting
- new_posting
- removed_posting
- active_salary_avg
- filling_time_avg

5. Individual Job Postings table:
- company
- job_category
- mapped_role
- state
- post_date
- remove_date

5./6. Transition Inflow & Outflow tables:
- prev_company
- prev_seniority
- prev_salary
- new_company
- new_seniority
- new_startdate
- new_salary

7. Workforce Dynamics: Demographic Breakdown table
- company
- gender
- ethnicity
- month
- count
- inflow
- outflow
- salary

8. Workforce Dynamics: Geographic Breakdown table
- company
- region
- country
- state
- msa (metropolitan statistical area)
- count
- inflow
- outflow
- salary

9. Workforce Dynamics: Role Breakdown table
- job_category
- role_k50
- role_k150
- count
- inflow
- outflow
- salary

10. Workforce Dynamics: Skills table
- company
- seniority
- job_category
- skill
- month
- count
- inflow
- outflow

11. Individual Positions table (full position history)
- location - region, country, state
- startdate, enddate
- job_category
- mapped_role
- seniority (predicted)
- salary (predicted)

12./13./14. Individual User/Skill/Education tables
- predicted gender/ethnicity
- skill
- skill_mapped
- campus/school
- degree
- field

Full schemas for each dataset can be found in our data dictionary: https://www.data-dictionary.reveliolabs.com/

搜集汇总

背景与挑战

背景概述

该数据集整合数亿条就业记录形成标准化人力资源数据库，覆盖企业人员构成、招聘动态、地域分布及职业流动等多元维度，包含11类核心数据表（如职位发布、员工评价、技能分析等），支持深度定制化分析。