🗃️

Data structure

Data columns

NameDescriptionExample
profile_number
Unique identifier or number associated with an individual's profile
sf81nabNyHzo1g80w9wIhg_0000north
user_location
Geographical location where the user is currently located
europe
url
URL associated with the user's profile
skills_and_expertise
Information about the user's skills
people due diligence, hr analytics, workforce analytics, people analytics, b2b data, data benchmarking, data visualization
job_company_industry
Most relevant industry the individual profile has worked
management consulting
job_i_summary
Descriptions of the profile’s job experiences (limited to first, second, and third experience)
Aura is a talent analytics platform built by my team at Bain.
job_i_company
Names of the company where the profile’s worked (limited to first, second, and third experience)
bain & company
job_i_dates
Start and end date of the profile’s job experiences (limited to first, second, and third experience)
jan 2021 - present
job_i_duration_str
Human-readable representations of the duration of each experience (limited to first, second, and third experience)
2 yrs 9 mos
job_i_location
Locations where each experience was held (limited to first, second, and third experience)
milan
job_i_title
Job title held during each experience (limited to first, second, and third experience)
product manager
degree_i_institution
Names of institutions where the profile earned their degrees (e.g., university names)
bocconi university
degree_i_field
Field of study (limited to first, second, and third degree)
economics
degree_i_type
Type/ level of degrees earned (limited to first, second, and third degree)
masters
degree_i_start_year
Start year of the degree program (limited to first, second, and third degree)
2018
degree_i_end_year
End year of the degree program (limited to first, second, and third degree)
2021
language_count
Number of languages the user has listed on their profile
5
language_i
Language listed by the individual (limited to first, second, and third language)
italian, english, mandarin
language_i_proficiency
Proficiency level in the listed language (limited to first, second, and third language)
native, proficient, advanced