Analyze resumes with HeadHunter. Who earns how much and in which industries he works
Recently, the Petamelon hackathon came into our hands with a dataset with ~ 6,000,000 CVs from NN. Naturally, there were no personal data and contacts, but there were many other interesting things: the expected salary, age, gender, approximate address, education and industries in which a person is looking for work. It was decided to try to use this data in our project about the choice of schools . The idea was to determine in which industries school graduates work and how much they earn. But I, of course, could not resist and built a bunch of other useless, but cool tables and graphs.
The distribution of resumes by age has an interesting form and seems to be divided into two parts: before graduation and after:
In Moscow, with age, the expected salary goes to a plateau of ~ 50,000 rubles:
In the data, instead of the floor, there were zeros and ones. The unit was slightly larger. Probably these are girls, I thought:
')
And when I looked at the distribution of the sexes by industry, there was no doubt: 1 - just girls.
Could not resist and checked who has more salary expectations in Moscow. In women, this is naturally explained by the fact that the distribution by industry differs: salaries are lower in hospitals and schools.
In addition to resumes, we also had vacancies, so it was interesting to compare supply and demand. In general, everything is logical: the interns are more than necessary; specialists in IT, marketing and banking are not enough:
To make it clearer who is in which categories, here is the handbook:
Then an attempt was made to compare the regions of Russia by expected salaries and popularity of industries. Surprisingly, the highest expectations are not in Moscow, but in the Far East. Why so, who knows?
Distortions in industries are sometimes expected and sometimes strange:
Then the same thing was done for Moscow universities. For some reason, I didn’t see almost any signal on the expected salary, for all universities the result is approximately the same:
And according to the specialties the expected results were obtained. Graduates of technical universities want to work as programmers and engineers, I can’t say anything about the other universities. If your university is in the picture, see if it’s a normal result or not.
For almost all Moscow schools, we namainili from VC in which universities their graduates enter . Therefore, knowing the distribution of industries for universities, we can estimate the distribution of industries for schools. If your school is in the picture, please validate the result:
The distribution of resumes by age has an interesting form and seems to be divided into two parts: before graduation and after:
In Moscow, with age, the expected salary goes to a plateau of ~ 50,000 rubles:
In the data, instead of the floor, there were zeros and ones. The unit was slightly larger. Probably these are girls, I thought:
')
And when I looked at the distribution of the sexes by industry, there was no doubt: 1 - just girls.
Could not resist and checked who has more salary expectations in Moscow. In women, this is naturally explained by the fact that the distribution by industry differs: salaries are lower in hospitals and schools.
In addition to resumes, we also had vacancies, so it was interesting to compare supply and demand. In general, everything is logical: the interns are more than necessary; specialists in IT, marketing and banking are not enough:
To make it clearer who is in which categories, here is the handbook:
- Sales - Sales Manager, Sales Assistant, Sales Representative, Customer Relationship Manager, Sales Assistant at Euroset Communications Salon, Merchandiser, Salesman, Cashier, Sales Clerk, Agent of National Companies, Store Manager, Sales Manager, Specialist sales manager, salesperson, customer service specialist, sales assistant at Euroset communications salon, wholesale sales manager, supervisor, regional manager, service sales manager;
- Information technology, Internet, telecom - system administrator, 1c programmer, sales manager, programmer, analyst, web programmer, 1c programmer, php programmer, software engineer, technical support specialist, regional sales manager, web developer, java - developer, web-designer, systems analyst, service engineer, php programmer, technical support engineer, php developer, frontend developer;
- Banks, investments, leasing - an operator for sales of bank products, a specialist in a bank, a specialist in collecting overdue debts, an operator for sales of banking products, a manager for collecting overdue debts, a loan officer, an operator, a loan manager, a loan manager, a loan specialist, Financial Products Sales Manager, Credit Expert, Banking Products Consultant, Banking Products Sales Specialist, Customer Relations Manager, Credit Expert, sultant, Cashier, Sales Manager, Banking Specialist;
- And ~ 30 more categoriesConstruction, real estate - Pto engineer, realtor, real estate agent, estimator engineer, chief engineer, real estate specialist, realtor, welder, sales manager, customer service manager (in Sochi), real estate sales manager, manager project, foreman, design engineer, real estate sales manager, real estate sales manager, chief power engineer, surveyor, specialist in working with elite clients (in Sochi), lead manager in working with VIP clients (in Sochi)
Transport, logistics - storekeeper, forwarding driver, warehouse specialist, order picker, loader driver, logistics manager, driver, e category driver, warehouse manager, stock picker, goods manager, taxi driver, picker loader, logistics specialist, bus driver , bus driver (category d), dispatcher, sticker picker, warehouse manager, logistics
Production - design engineer, process engineer, purchasing manager, process engineer, labor protection engineer, electronics engineer, production manager, miller, chief engineer, chief process engineer, agronomist, electrical engineer, chief mechanic, chief power engineer, site foreman , Technical Director, Environmental Engineer, Engineer, Controller, Engineer, Engineer
Administrative staff - office manager, call center operator, secretary, PC operator, assistant manager, courier, operator, telephone operator, administrator, office administrator, receptionist with knowledge of English at a hotel 5 * UAE, Qatar, Bahrain, Oman, secretary-assistant, assistant manager, cleaner with knowledge of English on a cruise liner, driver-courier, clerk, secretary-clerk, secretary at the reception, personal assistant manager, personal assistant manager
Medicine, pharmaceutics - medical representative, nurse, general practitioner, pharmacist, pharmacist, pediatrician, obstetrician-gynecologist, otorhinolaryngologist, neurologist, local district physician, pediatrician, pharmacist, ophthalmologist , ultrasound doctor, regional representative, sales manager, anesthesiologist-resuscitator, general practitioner, veterinarian, functional diagnostics doctor, cardiologist
Workers - loader, turner, handyman, packer, electrician, seamstress, electrician, worker in an agricultural complex, janitor, worker of loading and unloading works, electrician, turner boring machine, electric gas welder, car mechanic, berry collector (Krasnodar Territory), seamstress, assembler, maintenance worker, grinder, loader-pickler
Accounting, management accounting, enterprise finance - accountant, chief accountant, economist, deputy chief accountant, payroll accountant, financial manager, cashier, profit protection specialist, assistant accountant, cashier controller, accountant for primary documentation, accountant cashier , financial analyst, accounting calculator, senior accountant, lead accountant, auditor, financial controller, financial manager (Podolsk, Moscow region), leading economist
Tourism, hotels, restaurants - waiter, cook, tourism manager, chef, waiter with knowledge of English on an American cruise liner, pastry chef, bartender, baker, restaurant manager, hot cook, universal cook, cook (trainee) in restaurant in France, waiter with knowledge of English in a restaurant in the UAE, Qatar, Oman, Bahrain, a waiter (trainee) with knowledge of English in a Thai restaurant, receptionist (trainee) in a hotel in France, a chef of a cold shop, sous-chef, a cook, a hostess, sushi chef
Marketing, advertising, PR - marketer, internet marketer, client manager, advertising manager, secret buyer, sales manager, designer, content manager, marketing analyst, merchandiser, copywriter, pr manager, smm manager , marketing manager, brand manager, marketing and advertising manager, marketing director, head of marketing, advertising specialist, marketing specialist
Personnel management, training - head of NPP agency, personnel manager, agent network development manager, recruitment manager, assistant manager, personnel recruitment specialist, personnel specialist, recruiter, personnel director, training manager, HR management specialist , hr manager, business coach, HR specialist, hr-generalist / head of HR, HR specialist, Regional HR Specialist, Sales Director, Inspector HR Department, HR Officer
Early career, students - promoter, secret buyer, receptionist (trainee) with knowledge of English in a US hotel, merchandiser, intern at a hotel, Vancouver, Canada, credit specialist, sales manager, bartender, novice specialist, agent NGF, cook (trainee) to a french restaurant, waiter - trainee (with knowledge of English) to Thailand, waiter (trainee) with knowledge of English at a Thai restaurant, call center operator, online store operator, trainee to a hotel, Vancouver, Canada , call center operator, manager for working with the cli ntami, business Merchandiser, Customer Service Specialist
Science, education - teacher of English as a foreign language abroad, teacher of English, teacher of English for a child in China, author of scientific works (theoretical mechanics), author of scientific works (instrument making and optotechnics), author of scientific works on logistics, author of scientific works (hotel business), author of scientific works (machine parts), author of scientific works in the specialty “analysis of economic activity”, author of scientific works (management of an organization), author of scientific works (medicine), author of scientific works (and automation of technological processes), author of scientific works (electronics, electrical engineering, radio engineering), author of scientific works (aviation and rocket and space technology), author of scientific works (vehicles), author of scientific works (technological machines and equipment), author of scientific works ( metrology), author of scientific works (banking), author of scientific works (automation and control), author of scientific works (geodesy)
Lawyers - lawyer, legal advisor, assistant lawyer, leading legal adviser, head of legal department, leading lawyer, author of legal disciplines, general counsel, senior lawyer, head of legal department, regional lawyer, regional lawyer (in the Rostov region), senior legal advisor, legal assistant, agent of the recovery department, general counsel for court and claim work, lawyer, regional lawyer (Podolsk, Moscow region), corporate lawyer, junior lawyer
Automotive business - car mechanic, sales manager, car sales manager, auto mechanic, car washer, master inspector, car electrician, car washer, car electrician diagnostician, tire changer, mechanic, auto parts sales manager, auto parts sales manager, car mechanic, locksmith car repair, transport specialist, car sales assistant, master of the fitting of the fitting shop, additional equipment installer, fixer
Security - security guard, agent on field debt collection at the pre-trial stage to the field collection management, safety and safety engineer, auditor, debt collection specialist, sales area controller, security specialist, security officer, car dealership, security controller , internal affairs officer, specialist of the collection department, head of the security service, specialist of the economic security service, controller, security inspector, and a specialist in the collection Kaniyu debt / collector, video surveillance operator, leading specialist of the department of economic security, information security specialist
Art, entertainment, media - designer, photographer with knowledge of English on a cruise liner, graphic designer, photographer on a cruise liner, photographer, photographer with a knowledge of English on an American cruise liner, sound / light operator on a cruise liner, journalist, proofreader , editor, correspondent, interior designer, designer furniture, copywriter, croupier, clothing designer, visual merchandiser, dancer / dancer, videographer, web designer
Top management - commercial director, agent network development manager, branch director, financial director, executive director, general director, department head (franchisee), branch manager (Eruda village), cluster director, regional representative / director of the region, development director, director of the agency, director of the representative office, manager of the kitchen studio group, chief accountant, director of marketing, technical director, director of sales and marketing, director, manager th network pharmacies
Sports clubs, fitness, beauty salons - universal hairdresser, nail service master, hairdresser, massage therapist, hair stylist, beauty salon administrator, cosmetologist, manicure and pedicure master, administrator, sales manager, esthetician cosmetologist, work consultant / administrator with clients (beauty industry), manicurist, gym instructor, Perukar, group program instructor, cosmetologist, manicure and pedicure master, client manager, application processing administrator (sent e-Services of beauty salons)
Insurance - NPA agent, insurance agent, agent network development manager, active sales manager, corporate sales specialist, manager (sales manager), insurance specialist, financial consultant, sales director, agent group manager, customer relations manager , head of sales department, medical expert, head of NPP agency, insurance manager, sales manager, emergency commissioner, customer service specialist, head of agency group, expert appraiser
Extraction of raw materials - engineer-geodesist, machinist psm, engineer pto (technology), engineer pto (electrician), machinist pdm, head of well repair and overhaul, master of installation and commissioning section (concrete heating), drilling fluid engineer, engineer drilling, tunneling engineer, telemetry engineer, installer of process equipment and related structures, engineering supervisor for general construction and welding, a local underground geologist, a local underground surveyor, the head of the red / yellow section, chief Department - Chief Surveyor (Yamalo-Nenets), engineer - technologist of drilling mud driver MTA Chief Geologist
Purchases - purchasing manager, purchasing specialist, category manager, purchasing manager, purchasing manager, purchasing specialist, purchasing manager, public procurement specialist, purchasing manager, service center manager, senior buyer (indirect), specialist Procurement, Specialist of the Logistics Department, Technical Procurement Specialist, Head of Procurement Department, Procurement Manager, Leading Procurement Specialist, Assortment Manager, Specialist Tenders, Assistant Purchasing Manager
Consulting - agent network development manager, business analyst, project manager, business coach, project manager, project manager, project manager, team leader, office opening team leader, sales development project manager, customer relationship manager, promoter, analyst, project manager, real estate expert, project leader, lean production coordinator in the Moscow region (lean manufacturing coordinator), leading business analyst, project manager (Sakhalin), analyte ir business processes
Installation and service - service engineer, head of maintenance and repair of agricultural equipment, service engineer for the repair of ATMs, locksmith Kipia (electronics), installer of communication equipment, engineer for computer repair, engineer, technical support engineer, repair engineer of office equipment, master service center , computer repair technician, service center engineer, mechanic (metal cutting equipment), mobile phone repair technician, tachograph installation and maintenance specialist, service technician etsialist master equipment repair, maintenance engineer, maintenance technician ATM / service engineer, service manager
Domestic staff - maid, maid on a cruise liner, nanny, housekeeper / housekeeper, housekeeper, personal driver, housekeeper / housekeeper, chopper, caregiver, cook, nurse, caregiver assistant, married couple, nanny-tutor, housekeeper / housekeeper, family chef, family driver, gardener, kindergartener, family couple in a country house
Then an attempt was made to compare the regions of Russia by expected salaries and popularity of industries. Surprisingly, the highest expectations are not in Moscow, but in the Far East. Why so, who knows?
Distortions in industries are sometimes expected and sometimes strange:
- In the Moscow region from somewhere skewed into transport;
- In Voronezh - in insurance;
- In the Krasnodar region there is a bias in tourism, but in the Crimea there;
- In Moscow and St. Petersburg, there is less “raw material extraction” at the expense of other areas.
Then the same thing was done for Moscow universities. For some reason, I didn’t see almost any signal on the expected salary, for all universities the result is approximately the same:
And according to the specialties the expected results were obtained. Graduates of technical universities want to work as programmers and engineers, I can’t say anything about the other universities. If your university is in the picture, see if it’s a normal result or not.
For almost all Moscow schools, we namainili from VC in which universities their graduates enter . Therefore, knowing the distribution of industries for universities, we can estimate the distribution of industries for schools. If your school is in the picture, please validate the result:
Source: https://habr.com/ru/post/271407/
All Articles