Resume analysis with HeadHunter. Who earns how much and in what industries

    Recently, at a Petamelon hackathon, we came across a dataset with ~ 6,000,000 CVs from NN. There, of course, there was no personal data and contacts, but there were many other interesting things: 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 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 reaches a plateau of ~ 50,000 rubles:


    in the data instead of gender, zeros and ones were indicated. There were a few more ones. Probably these are girls, I thought:


    And when I looked at the sex distribution by industry, there was no doubt: 1 - it’s for sure girls.


    I could not resist and checked who has more salary expectations in Moscow. For women below, this is naturally explained by the fact that the distribution by industry is different: in hospitals and schools, salaries are lower.


    In addition to the resume, we had vacancies, so it was interesting to compare supply and demand. In general, everything is logical: there are more interns than necessary; there are not enough specialists in IT, marketing and banking:


    To make it clear who is in which categories, here is a guide:
    • Sales - sales manager, sales consultant, sales representative, customer service manager, sales consultant in the Euroset communication salon, merchandiser, seller, cashier, cashier seller, NPF agent, store director, sales manager, specialist sales, salesperson, customer service specialist, sales consultant in the Euroset communication salon, wholesale sales manager, supervisor, regional manager, service sales manager;
    • Information technology, Internet, telecom - system administrator, 1s 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, system analyst, service engineer, php programmer, technical support engineer, php developer, frontend developer;
    • Banks, investments, leasing - a bank product sales operator, a bank specialist, a debt collection specialist, a bank products sales operator, a debt collection manager, a loan specialist, an operator, a loan manager, a loan manager, a loan specialist, financial product sales manager, lending expert, banking product consultant, banking product sales specialist, customer service manager, loan expert, sultant, Cashier, Sales Manager, Banking Specialist;
    • And ~ 30 more categories
      Construction, real estate - PTO engineer, realtor, real estate agent, estimate engineer, chief engineer, real estate specialist, realtor, welder, sales manager, customer service manager (in Sochi), real estate sales specialist, 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), leading VIP client (in Sochi)
      Transport, logistics - a storekeeper, a forwarding driver, a warehouse specialist, a picker, a forklift driver, a logistics manager, a driver, a category e driver, a warehouse manager, a storekeeper-picker, a merchandiser, a taxi driver, a picking loader, a logistics specialist, a bus driver , bus driver (category d), dispatcher, picker-sticker, warehouse manager, logistics
      Production - design engineer, process engineer, purchasing manager, technologist, labor protection engineer, electronic engineer, project manager production, milling machine operator, chief engineer, chief technologist, agronomist, electrical engineer, chief mechanic, chief power engineer, site foreman, technical director, environmental engineer, engineer, supervisor, 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 in a 5 * hotel in UAE, Qatar, Bahrain, Oman, assistant secretary, assistant manager, cleaner with knowledge of the English language on a cruise ship, courier driver, clerk, clerk, receptionist, personal assistant, personal assistant
      Medicine, pharmaceuticals - a medical representative, a nurse, a general practitioner, a pharmacist, a pediatrician, an obstetrician-gynecologist, an otorhinolaryngologist, a neurologist, a general practitioner, a local pediatrician, a pharmacist, an ophthalmologist , doctor of ultrasonic diagnostics, regional representative, sales manager, a physician anesthesiologist, a general practitioner, veterinary surgeon, doctor of functional diagnostics, cardiologist
      workers - the loader, turner, handyman, packer, elektromonta nickname, sewing, an electrician working in the agro, wiper, a work loading and unloading operations, electrician, turner borer, welder, mechanic, collector berries (Krasnodar), sewer tailor-assembling, maintenance worker, grinder, the loader-sorter
      Bookkeeping, management accounting, company finance - accountant, chief accountant, economist, deputy chief accountant, payroll accountant, financial manager, cashier, profit protection specialist, assistant accountant, cashier-accountant, primary accountant accountant, bookkeeper , financial analyst, accountant, calculator, senior accountant, leading 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 ship, pastry chef, bartender, baker, restaurant manager, hot shop chef, station wagon, cook (intern) in restaurant in France, a waiter with knowledge of English in a restaurant in the UAE, Qatar, Oman, Bahrain, a waiter (trainee) with knowledge of English in a restaurant in Thailand, a receptionist (trainee) in a hotel in France, a cook in a cold shop, sous-chef, cook, hostess, Sushi cook
      Marketing, advertising, PR - marketer, Internet marketer, customer care manager, advertising manager, mystery shopper, 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
      HR management, training - head of the NPF agency, HR manager, agent network development manager, HR manager, assistant manager, HR specialist, HR specialist, recruiter, HR director, training manager, HR management specialist , hr manager, business trainer, HR specialist, hr-generalist / HR manager, HR specialist, regional HR manager, sales director, inspector HR department, HR inspector
      Career start, students - promoter, mystery shopper, receptionist (trainee) with knowledge of English at a US hotel, merchandiser, trainee at a hotel, Vancouver, Canada, loan officer, sales manager, bartender, novice specialist, NPF agent, cook (trainee) to a restaurant in France, a waiter - trainee (with knowledge of English) to Thailand, a waiter (trainee) with knowledge of English to a restaurant in Thailand, a call center operator, an online store operator, a trainee in a hotel, Vancouver, Canada , call-center operator, manager for working with Kli ntami, business Merchandiser, Account Specialist with customers
      Science, education - teacher of English as a foreign language abroad, teacher of English, teacher of English for children in China, author of scientific papers (theoretical mechanics), author of scientific papers (instrumentation and optics), author of scientific papers on logistics, author of scientific papers (hotel business), the author of scientific papers (machine parts), the author of scientific papers in the specialty “analysis of economic activity”, the author of scientific papers (organization management), the author of scientific papers (medicine), the author of scientific papers (and automation of technological processes), the author of scientific papers (electronics, electrical engineering, radio engineering), the author of scientific papers (aviation and rocket and space technology), the author of scientific papers (vehicles), the author of scientific papers (technological machines and equipment), the author of scientific papers ( metrology),
      Lawyers - lawyer, legal adviser, assistant lawyer, leading legal adviser, head of the legal department, leading lawyer, author of legal disciplines, chief legal adviser, senior lawyer, head of the legal department, regional lawyer, regional lawyer (Rostov region), senior legal adviser, assistant legal adviser, agent of the collection department, chief legal adviser on litigation and claim work, lawyer, regional lawyer (Podolsk, Moscow region), corporate lawyer, junior lawyer
      Automotive business - auto mechanic, sales manager, automobile sales manager, auto mechanic, car wash, master receptionist, auto electrician, car washer, auto electrician-diagnostician, tire technician, mechanic, auto parts sales manager, spare parts sales manager, car mechanic, car mechanic car repair, transport specialist, automobile sales consultant, master-acceptor of the locksmith’s workshop, installer of additional equipment, armature
      Security - security guard, pre-trial debt collection agent at the exit collection department, labor protection and safety engineer, auditor, debt collection specialist, sales supervisor, security specialist, security officer, security guard in car dealership, security guard , internal affairs officer, collection specialist, security manager, economic security specialist, controller, security inspector, collection specialist debt management / collector, video surveillance operator, leading specialist of the economic security department, information security specialist
      Arts, entertainment, media - designer, English speaking photographer on a cruise liner, graphic designer, English speaking photographer on a cruise liner, photographer, English speaking photographer on an American cruise liner, sound / light operator on a cruise liner, journalist, corrector , editor, correspondent, interior designer, cabinet designer, copywriter, croupier, clothing designer, visual merchandiser, dancer / dancer, video operator, web designer
      Top management - commercial director, head of agent network development, branch director, financial director, executive director, general director, unit head (franchisees), branch head (nonsense village), cluster director, regional representative / region director, development director, Agency Director, Representative Office Director, Kitchen Studio Group Manager, Chief Accountant, Marketing Director, Technical Director, Sales and Marketing Director, Director, Managing Director th network pharmacies
      Sports clubs, fitness, beauty salons - universal hairdresser, nail service master, hairdresser, massage therapist, hairdresser-stylist, beauty salon administrator, cosmetologist, manicure and pedicure master, administrator, sales manager, esthetician cosmetologist, consultant / work 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 - NPF agent, insurance agent, head of agent network development, active sales manager, corporate sales specialist, manager (head of sales), insurance specialist, financial consultant, sales director, agent group manager, customer relations manager , head of sales, expert doctor, head of the NPF agency, insurance manager, sales manager, emergency commissioner, customer service specialist, agent group leader, expert appraiser
      Raw materials extraction - surveying engineer, PSM engineer, PTO engineer (technology), PTO engineer (electrician), PDM engineer, head of the workshop for well repair and overhaul, installation and adjustment department foreman (concrete heating), drilling fluid engineer, engineer for drilling, tunneling, telemetry engineer, installer of technological equipment and related structures, technical supervision engineer for civil works and welding, local underground geologist, local underground surveyor, head of the cattle section Department - Chief Surveyor (Yamalo-Nenets), engineer - technologist of drilling mud driver MTA Chief Geologist
      Purchasing - procurement manager, procurement specialist, category manager, procurement manager, procurement manager, procurement specialist, procurement manager, public procurement specialist, procurement manager, service center manager, senior buyer (indirect), department specialist procurement, specialist of the logistics department, technical procurement specialist, head of the procurement department, procurement manager, leading procurement specialist, assortment manager, specialist Tenders, Assistant Purchasing Manager
      Consulting - agent network development manager, business analyst, project manager, business trainer, project manager, project manager, project manager, team leader, office opening team leader, sales development project manager, customer relations manager, promoter, Analyst, IT project manager, real estate expert, IT project manager, lean manufacturing 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 the department of operation and repair of agricultural machinery, service engineer for repairing ATMs, locksmith kipia (electronics), installer of communication equipment, computer repair engineer, engineer, technical support engineer, office equipment repair engineer, service center master , computer repair technician, service center engineer, mechanic (metal-cutting equipment), mobile phone repair technician, installation and maintenance specialist for tachographs, 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, au pair, personal driver, housekeeper / housekeeper, inspector's assistant, caregiver, cook, nurse, assistant tutor, married couple, nanny educator, housekeeper / housekeeper, a cook for the family, a family driver, a gardener, a preschool teacher, a married couple in a country house


    Then an attempt was made to compare the regions of Russia by the expected salaries and popularity of industries. Surprisingly, the highest expectations are not in Moscow, but in the Far East. Why so who knows?


    Distortions across industries are sometimes expected, and sometimes strange:
    • In the Moscow region, the bias in transport is somewhere;
    • In Voronezh, insurance;
    • There is a bias in tourism in the Krasnodar Territory, but not in the Crimea;
    • In Moscow and St. Petersburg there is less “extraction of raw materials" due to other areas.



    Then the same thing was done for Moscow universities. For some reason, I did not see almost any signal on the expected salary; for all universities, the result is approximately the same:


    And in the specialties, the expected results were obtained. Graduates of technical universities want to work as programmers and engineers, I can not say anything about other universities. If your university is in the picture, see if the result is normal for it or not.


    For almost all Moscow schools, we have mined from VK to 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:

    Also popular now: