Data Annotation

[hodsonjames]

Hi Honghao,

We'd like to be able to see more granular details about the types of jobs and company structures for the companies we are analysing. So, we need to annotate some of the job title data to allow us to see these features more consistently.

1. For each industry of focus (tech, banking, Pwc/Deloitte), could you group the top 1,000 job titles by frequency. Then for each of these job titles, assign a department where it makes sense and one is not already present.

2. For each of these job titles, please go through and assign the following labels to allow comparison of seniority within/across firms: [Entry-level/Junior - 1, Experienced - 2, Team Management - 3, Middle Management - 4, Top (Regional/Departmental/Executive) Management - 5].

We would then like to add plots by seniority and department, to see how these firms are changing along these dimensions over time.

Thanks! James

[c-forrest]

Hi James,

I have uploaded the checked job titles. Please find it here. Please let me know if you have any problem on that. If not, I will then add plots to the summary statistics.

I also apologize for my mistake that I wrongly added this file to the master branch. Please remove this commit.

Best, Honghao

[hodsonjames]

Thanks Honghao. Yes, please show the plots by company for the hierarchy over time--that would be very helpful.

Best, James

[hodsonjames]

Just to check--these are only the tech job titles, or also the top 1k for each of the other industries?

[c-forrest]

Hi James,

Thanks for your reply. I will do them soon.

As for your question, they are for all three industries contained in different sheets of the same spreadsheet.

Best, Honghao

[c-forrest]

@hodsonjames Hi James,

Please find the summary statistics updated with hierarchy changes as follows:

• D&P - accounting and auditing; (Updated)

• D&P - other positions;

• Small banks;

• Big banks - banking and financing; (Updated)

• Tech - software engineering. (Updated)

Let me know any question.

Best, Honghao

[hodsonjames]

Thanks Honghao,

This looks good. Only one thing is that the tech file doesn't show the final plot. All the other seem reasonable though.

[c-forrest]

@hodsonjames Hi James,

Thanks for your reply. Sorry that I do not get what is the "final plot" you referred to. I think all three updated files should have the same structure. Please clarify this.

Thanks, Honghao

[hodsonjames]

It seems to be fixed now, so no worries! Perhaps it just took a while for the notebook to render. Thanks!