Libraries

Load the following libraries, you may need to install a few

library(tidyverse) library(readxl) library(tidytext) library(wordcloud2) library(janitor)

There is a bug in wordcloud2 which prevents it from knitting more than 1 wordcloud, so we want to install wordcloud2 using devtools from here. just do this once. if you don’t have devtools installed install it first then install wordcloud2 like this.

devtools::install_github(“gaospecial/wordcloud2”)

Setup

Part 1. Analyze MSBA2020 Jobs

1. Import

  1. Create jobs dataframe by using read_excel() to read in MSBA20JobDescriptions.xlsx
  2. I recomend piping it to clean_names() to deal with column names
  3. Print the first 5 jobs to make sure your import works.
title firm job_description
Financial Analyst Lockheed Martin

This position is responsible for accounting, financial planning and analysis tasks. These tasks include preparation of journal entries, account reconciliations, maintain and set up of cost accounting master data, analysis of financial information, support of month end and year end close, budget planning, forecast and trend analysis of indirect cost. This position will develop and maintain relationships with functions across the enterprise and work special projects as assigned.

Must be a US Citizen. This position is located at a facility that requires special access

Basic Qualifications Bachelor’s Degree from an accredited college Intermediate user of MS Office (Excel emphasized)

Desired skills Bachelor’s Degree in Finance or Accounting SAP system experience Presentation / Communication skills Forecasting and analysis skills Ability to multi-task Ability to meet deadlines Self-motivated Able to work in teams / work with others

As a leading technology innovation company, Lockheed Martin’s vast team works with partners around the world to bring proven performance to our customers’ toughest challenges. Lockheed Martin has employees based in many states throughout the U.S., and Internationally, with business locations in many nations and territories.
Business Advisory Consultant EY

The opportunity EY’s Advisory Consultant Program (ACP) is a great way to start your professional journey if you are interested in a career as a consultant. As part of the ACP, the Business Advisor Program (BAP) is a 2-3 year development program offering participants the opportunity to serve diverse clients, while engaging in learning, experiences, and coaching to develop core business consulting skills. Once you have developed a strong foundation, we will work with you to determine a more specific area of concentration for the next phase of your career journey.

What to expect At EY we solve big, complex issues. Whether it’s assisting clients in pursuit of profitable growth, risk management, cost reduction, or organizational transformation, our goal is to help our clients improve their business and reach their potential. Our BAP professionals evaluate processes and functions, and recommend opportunities for greater efficiency related to Finance, Supply Chain, Strategy, and Customer.

We focus on a variety of industries including, but not limited to: automotive, government and public sector, consumer products, media and entertainment, oil and gas, power and utilities, and technology clients. Additionally, we have built a dominant position and focus on financial services through our Financial Services Organization (FSO). Candidates electing to join the FSO will focus exclusively in financial services and will have opportunities to serve leading investment banks, retail and commercial banks, insurers, and investment managers. Those who join our FSO may also be deployed on engagements across our Financial Services Risk Management practice where we assist our clients with the measurement, mitigation, management and monitoring of financial and operational risks. Whether you choose to join the FSO or pursue broader industry focus, you’ll build fundamental consulting skills that will provide the foundation for a long career.

Your key responsibilities may include: · Growing lasting relationships with our clients, understanding their needs and consistently delivering quality client services · Understanding and documenting clients’ business processes and requirements, performing root cause analyses, developing business cases, and gathering information · Monitoring progress, managing risks and ensuring key stakeholders are kept informed about progress and expected outcomes · Strong focus on building a reputation as an authoritative expert in your area by constantly updating your understanding of current business and industry trends · Taking full responsibility for tasks including consistent self-review of work to identify and improve an approach for producing high quality work products, while working under supervision

To qualify for the role you must have · A bachelor’s or master’s degree in a relevant business discipline: Accounting, Finance, Business Economics, Statistics, MIS (emphasis on Business), Supply Chain, Operations Management, Health Administration, Public Administration, or Public Health · Desire to work in consulting demonstrated by relevant course work, interest or internship experience · The flexibility and willingness to travel as well as work in excess of standard hours when necessary · The understanding that travel is an essential function of the job and is estimated at 80% · Proficiency with MS Office, including MS Excel, MS Word and MS PowerPoint · Willingness and ability to learn and work independently with minimal supervision · Demonstrated project management, teaming, organizational, analytical, and problem-solving skills · Excellent interpersonal, written and verbal communication skills · Effective organization and time management skills with the ability to work under pressure and adhere to project deadlines · Integrity within a professional environment · A driver’s license valid in the U.S. · Candidates interested in the Government & Public Sector focus must have sole U.S. citizenship and be able to obtain and maintain a secret clearance or higher, within the designated time frame, which will be determined by the engagement requirements for a security clearance.

What working at EY offers We offer a competitive compensation package where you’ll be rewarded based on your performance and recognized for the value you bring to our business. In addition, our Total Rewards package includes medical and dental coverage, both pension and 401(k) plans, a minimum of three weeks of vacation plus ten observed holidays and three paid personal days, and a range of programs and benefits designed to support your physical, financial and social wellbeing.

Plus, we offer · Support, coaching and feedback from some of the most engaging colleagues around · Opportunities to develop new skills and progress your career · A rewards package tailored to your unique needs
Consultant FTI Consulting

FTI Consulting, Inc. is a global business advisory firm dedicated to helping organizations protect and enhance enterprise value in an increasingly complex legal, regulatory and economic environment. With more than 4,400 employees located in 26 countries, FTI Consulting professionals work closely with clients to anticipate, illuminate and overcome complex business challenges in areas such as investigations, litigation, mergers and acquisitions, regulatory issues, reputation management, strategic communications and restructuring. Our professionals are some of the most experienced leaders in their fields including: certified turnaround professionals, forensic accountants, corporate investigation specialists, intellectual property specialists, former political leaders, former chief executives, Nobel Laureate economists, banking and securities professionals, certified public accountants, e-discovery professionals, corporate, financial and crisis communications specialists, chartered financial analysts and industry experts. Since our founding in 1982, clients have turned to us for high-stakes issues that require specialized expertise. FTI Consulting was engaged to work on some of the biggest news stories of the last two decades including the Bernie Madoff investment securities scandal, the Stanford Financial Group investigation, the 2010 Gulf oil spill crisis, the Major League Baseball steroid investigation, and high profile corporate restructurings including Lehman Brothers, General Motors and CIT, just to name a few.

FTI Consulting does not accept unsolicited resumes from external firms or agencies. FTI Consulting will not be responsible for placement fees associated with unsolicited resumes.

FTI Consulting is an equal opportunity employer and does not discriminate on the basis of race, color, national origin, ancestry, citizenship status, protected veteran status, religion, physical or mental disability, marital status, sex, sexual orientation, gender identity or expression, age, or any other basis protected by law, ordinance, or regulation.

PRIMARY DUTIES:

Responsible for day-to-day activities of a project including interaction with other team members, professionals from other firms involved in the engagement and client personnel; Identify, research, and organize information to assess the appropriateness and sufficiency of available data to facilitate effective data access and analysis; Apply business, accounting, finance, and analytical skills to various client situations and practice disciplines including, but not limited to, reviewing and analyzing financial statements and projections, assessing business plans, financial modeling, accounting treatment in financial statements to determine appropriateness under generally accepted accounting principles, reviewing and understanding ratio and comparable company analysis, and creating work product that is flexible, understandable, and usable by others; Analyze and interpret historical financial, operational, and transactional data; Investigate and critique assertions, analyses, and work product of other experts, consultants and attorneys; Participate in investigations by interviewing subjects, analyzing information and summarizing observations; Assist with preparation of reports, written analyses, presentations, quantitative exhibits, and other client deliverables regarding project scope and/or results of work performed; Maintain detailed working paper records reflecting assumptions, methodologies, and information sources employed during the performance of all analytical tasks; Participate in client meetings to review results of work performed; and Maintain professional image within the company and project the same to those outside of the company.

BASIC QUALIFICATIONS:

Pursuing a Bachelor’s Degree in Business related field of study Permanent US work authorization PREFERRED SKILLS:

Ability to work both independently and as part of a team in a fast-paced, multi-task environment with a strong attention to detail; Ability to interface with team members and client personnel in demanding, deadline-driven situations; Excellent communication (both written and verbal), mathematical, and organizational skills; Flexibility with respect to assigned tasks and engagements due to challenging deadlines, changing deliverables and evolving task priorities; General knowledge of corporate finance and accounting principles and terminology; Familiarity with internet-based financial research resources for corporate information, SEC filings, competitive data and other data sources; Proficiency with PC environment and related software, including Microsoft Office applications; and Strong work ethic, eagerness to learn, and motivation to succeed.
Technology Advisory Program EY

EY’s Advisory Consultant Program (ACP) is a great way to start your professional journey if you are interested in a career as a consultant. As part of the ACP, the Technology Advisor Program (TAP) is a 2-3 year development program offering participants the opportunity to serve diverse clients, while engaging in learning, experiences, and coaching to develop core business consulting skills. Once you have developed a strong foundation, we will work with you to determine a more specific area of concentration for the next phase of your career journey.

What to expect

At EY we solve big, complex issues that help deliver better working outcomes that grow, optimize and protect businesses, now and in the future. Technology is at the center of business transformation and provides opportunities to improve performance, manage risks, and drive innovation. Our TAP professionals help our clients to better understand specific areas and issues such as mobile payments, cybersecurity, data analytics, robotic process automation, systems implementation, cloud computing, and IT transformation.

We focus on a variety of industries including, but not limited to: automotive, government and public sector, consumer products, media and entertainment, oil and gas, power and utilities, and technology clients. Additionally, we have built a dominant position and focus on financial services through our Financial Services Organization (FSO). Candidates electing to join the FSO will focus exclusively in financial services and will have opportunities to serve leading investment banks, retail and commercial banks, insurers, and investment managers. Whether you choose to join the FSO or pursue broader industry focus, you’ll build fundamental consulting skills that will provide the foundation for a long career.

Your key responsibilities may include:

Growing lasting relationships with our clients, understanding their needs, and consistently delivering quality client services Helping clients drive business-led and technology-enabled transformation across a broad range of business issues Understanding and documenting clients’ business processes and requirements, performing root cause analyses, developing business cases, and gathering information Monitoring progress, managing risks and ensuring key stakeholders are kept informed about progress and expected outcomes Developing specific skills with software packages from leading enterprise application vendors Taking full responsibility for tasks including consistent self-review of work to identify and improve an approach for producing high quality work products, while working under supervision Constantly updating your understanding of current business and industry trends.

Qualifications A bachelor’s degree in a relevant business or technology discipline, i.e. MIS, Computer Science, Statistics, Math, IT Security, Operations Research, Accounting or Finance (with a specific concentration in MIS), Information Systems, Information Technology, Technology Risk, Computer or other related Engineering Desire to work in consulting demonstrated by relevant course work, interest or internship experience The flexibility and willingness to travel as well as work in excess of standard hours when necessary The understanding that travel is an essential function of the job and is estimated at 80% Proficiency with MS Office, including MS Excel, MS Word and MS PowerPoint Willingness and ability to learn and work independently with minimal supervision Demonstrated project management, teaming, organizational, analytical and problem-solving skills Excellent interpersonal, written and verbal communication skills Effective organization and time management skills with the ability to work under pressure and adhere to project deadlines Integrity within a professional environment A driver’s license valid in the U.S. Candidates interested in the Government & Public Sector focus must have sole U.S. citizenship and be able to obtain and maintain a secret clearance or higher, within the designated time frame, which will be determined by the engagement requirements for a security clearance. Compensation
Healthcare Business Analyst Wellnecity

Help us change the rules of healthcare and create the future! Help us outpace other innovators in healthcare to deliver better care to patients, decrease cost, and improve population health. Are you strong with data? Do you enjoy structuring problems that can be solved through data analytic methods? Are you intrigued by an environment with an ever-growing list of business problems that can now be solved through sound data analytics?

We are looking for strong data analysts to complement and support a business analyst team.

Responsibilities include:

Use statistical methods to analyze data and generate useful business insights Create models to identify trends and track changes across time Work with management team to structure an analytic environment that supports ongoing problem solving leveraging expanding data tied to people and healthcare Identify, source, and support cleansing new data sources improving our ability to decrease costs and improve care for individuals and groups

Experience and skills required: Master’s degree in data analytics or similar degree; or MBA with data analytics job experience Demonstrated success in team environments Strong written and verbal communication skills Detailed analytical abilities demonstrated either through coursework or job experience Strong and proven understanding of data cleanup challenges, data management strategies, logical database design, databases (e.g., MySQL), and SQL Amazon Web Services (AWS) skills a plus Power BI skills a plus SQL skills a plus Experience in the healthcare industry a plus, but not required Prior experience with Management Consulting firm a plus Practical application ability with Microsoft Office Suite

Task 1 – Job Description Term & Bigram Frequency Analysis

Task 1a.Create a table of term frequencies

The following steps will help you make your term_frequency table need to make your first wordcloud.

  1. make a vector called excludes <- c(“key”, “clients”, “chicago”)
  2. pipe jobs into unnest_tokens(word, job_description)
  3. pipe into anti_join(stop_words, by = c(“word” = “word”)) this will remove common words
  4. pipe into filter(!word %in% excludes ) this will remove excluded words
  • remove “key”, “clients”, “chicago” and any other words you think make sense
  1. pipe into filter(!str_detect(word,“^\d”)) this will remove digits
  2. group_by(word)
  3. summarise(n=n())
  4. arrange(desc(n))
  5. create a term_frequency table
  6. finally, print out the the top 20 terms using top_n()
## `summarise()` ungrouping output (override with `.groups` argument)
## Selecting by n
word n
business 126
data 122
skills 98
experience 62
ability 60
team 47
analytics 46
management 46
client 44
strong 44
financial 42
information 42
job 41
develop 39
environment 37
including 36
opportunities 34
analysis 33
degree 32
services 32
understanding 32

Task 1b.

  1. create a wordcloud with all of the terms, using wordcloud2()
## Selecting by n

Task 1c.

  1. create a wordcloud for the terms that start with the letter “a”
## Selecting by n

Task 2, Words after DATA

Data is clearly an important word so what words come after data?

Task 2.1 - Words AFTER “data” …

  1. pipe jobs

  2. into: unnest_tokens(bigram, job_description, token = “ngrams”, n = 2, n_min = 2), what does bigram do?

  3. separate bigram into two words: separate(bigram, c(“word1”, “word2”), sep = " ")

  4. filter for “data” filter(word1 == “data”)

  5. remove junk words on word2 : anti_join(stop_words, by = c(“word2” = “word”))

  6. unite word 1 and 2 together: unite(word, word1, word2, sep = " ")

  7. group_by(word)

  8. summarise(n=n())

  9. arrange(desc(n))

  10. save data_term_frequency

  11. print top 10 terms

## `summarise()` ungrouping output (override with `.groups` argument)
## Selecting by n
word n
data analytics 8
data analysis 7
data sources 7
data sets 6
data driven 4
data management 4
data quality 4
data analyst 3
data science 3
data solutions 3

Task 2.2 - Create a word cloud of data + term combinations

Task 2.3 - Create a bar chart of the top 15, data + term combinations

## Selecting by n

Task 3, Technology Term Analysis

Analyze Technology Terms

Create Word & Bi-Gram Frequencies - Jobs

  1. Filter the term_frequency table based on the technology_terms provided, tech_term_freq
  2. Filter the bigram_frequency table based on technology_bigrams provided, tech_bigram_freq
  3. Smash the results together into technology_term_frequency using using bind_rows()
word n
data 122
analytics 46
excel 20
analyze 17
sql 12
python 6
tableau 6
cloud 2
java 2
spss 2
aws 1
hive 1
sas 1
spark 1
data science 3

Task 3b. Make a Wordcloud of Techology Terms

Task 4. Your Resume

Task 4 - getting started

  1. save/print your resume as PDF, it needs to be PDF format for this to work.
  2. install pdftools and load the libraru(pdftools)
  3. use pdf_text to read your resume into a table. for example heres how i read my resume in

resume <- pdf_text(“/Users/mikames/Downloads/Michael Ames Resume_CurrentJan2019.pdf”)

note: this makes a character vector of your resume, we need to tidy it up and get it into a table.

Task 4.2 - Parse your resume, filter out the common words, digits, and any excludes

Your resume is now a character vector, you’ll need to perform the following 1. as_tibble(resume) will convert it to a data frame 2. parse text into words, using unnest_tokens(word, value) 3. remove words you want to exclude 4. remove numbers 5. group by words and count the words up. to make a resume_word_freq table.

## Warning: `as.tibble()` is deprecated as of tibble 2.0.0.
## Please use `as_tibble()` instead.
## The signature and semantics have changed, see `?as_tibble`.
## This warning is displayed once every 8 hours.
## Call `lifecycle::last_warnings()` to see where this warning was generated.

Task 4.3 - Create a word cloud of the remaining words in your resume

## Selecting by freq

Task 4.4 filter for technology_words and technology_bigrams

to do this you’ll need to Bigram Freq. your resume, hen filter for technology_bigrams

Task 4.4 Steps: Bigram Freq. your resume, filter for technology_bigrams

  1. as_tibble(resume) pipe into
  2. unnest_tokens(word, value, token = “ngrams”, n = 2, n_min = 2) to make bigrams
  3. filter(word %in% technology_bigram ) for specific bigrams
  4. group_by(word)
  5. summarise(n=n())
  6. arrange(desc(n))
  7. make a resume_bigram_freq
## `summarise()` ungrouping output (override with `.groups` argument)

4.4 finally SMASH resume_word_freq & resume_bigram_freq together

  1. use bind_rows() to do this.

TASK 4.4a - make a bar chart of combined technolgy term frequencies

TASK 4.4b - make a wordcloud of combined technolgy term frequencies

Task 5 Rinse Repeat with your choosen jobs

title firm job_description location
Social Media Manager Shefit Comprehensive understanding and use of Facebook, Twitter, LinkedIn, Pinterest, Instagram, TikTok, YouTube, Google+, snap chat and other most important social media platforms and tools with knowledge and opinions as to new platforms and tools. Experience handling budgets and paid media across social platforms. Strong project management skills. NA
Analytics Specialist William Hill 3-4 years of experience analyzing, interpreting, and visualizing data into clean, clear, and digestible dashboards and reports. Experience with Web Analytics (Google Analytics), BI tools (PowerBI), and databases (Snowflake). Experience writing advanced analytics code statements, models, and macros. Experience debugging data issues in analytics tools including the ability to inspect the page behavior and understand the events being triggered. Understanding of and experience using analytical concepts and statistical techniques: hypothesis development, designing tests/experiments, analyzing data, drawing conclusions, and developing actionable recommendations for business units. Strong communication skills and capable of building strong relationships with colleagues and explaining complex topics in simple and influential terms. Ability to develop analyses to address ambiguous questions. Experience using analytics techniques to contribute to company growth efforts, increasing revenue and other key business outcomes. Strong problem solving, quantitative and analytical abilities. NA
Analytics QA Analyst CBS Interactive

CBS Interactive is looking for a talented Analytics QA Analyst to join its Measurement Operations team to help ensure world-class data quality. You’ll work closely with the tracking engineers to gather test requirements, execute test plans, and perform both manual and automated testing on a variety of new and existing applications on web, mobile, and OTT platforms.

Data plays a central role at CBS Interactive, and as part of the Data & Insights Group (DIG), our Measurement Operations team is a crucial part of our success. It drives business, product, and operational decisions by providing rich data, strategic insights and analytical products. We are looking for an Analytics QA Analyst who is passionate about data and entertainment, and who thrives in a dynamic and fast-paced environment. The position is anchored providing accurate and timely data quality assurance around our growing portfolio of products that offer CBS content on multiple access points, including its increasing Originals’ slate with shows such as Star Trek: Picard, The Good Fight, and Why Women Kill to name a few.

The ideal candidate should have the interest and ability to take on advanced QA projects related to the implementation of analytics platforms and data collection. 		NA
Implementation Specialist Arrowroot Capital Management Work with Account Executives and Client Success Managers to identify client needs and tailor reporting accordingly Complete thorough QA checks on reports prior to delivery via SQL and calculation review Produce and deliver PDF, Dashboard reporting, and all end-user deliverables that allow client to effectively utilize product(s) Present reporting and findings with expert insights on how to maximize sponsorship value by utilizing Hookit data Educate internal and external clients on the Hookit platform capabilities and functionality Act as the technical contact for the client during the implementation process to resolve issues, answer questions and ensure expectations and deadlines are met. Assist Client Success Managers with support and answering client questions Create objects and document all interactions in Salesforce NA
Reporting & Data Visualization, Product Analytics and Growth NBA 2- 3+ years of experience in a data visualization, product analytics and/or product growth/optimization role focused on digital experiences (mobile, web, video, commerce/subscription) Demonstrated ability to conduct data analysis, actionable insights, and work directly with product and business owners to implement and measure recommended actions Strong working-knowledge of Tableau with experience creating dashboards from scratch Working knowledge of SQL, database management and data automation Practical expertise with leading product analytics software tools, preferably Adobe Analytics, and a willingness and ability to combine internal and external methods to gather and analyze data Understanding of digital data architecture and work flows Experience working with premium and/or subscription products direct-to-consumer preferred Technology-savvy with an understanding of evolving media and content landscape and trends Excellent presentation and written communication skills Knowledge of basketball and a passion for the NBA and sports is helpful and preferred NA 
## `summarise()` ungrouping output (override with `.groups` argument)
## Selecting by n
word n
data 57
experience 41
business 34
product 27
analytics 18
ability 17
skills 15
digital 14
knowledge 14
requirements 14
insights 13
analysis 12
stakeholders 12
media 11
nba 11
process 11
tools 11
management 10
strong 10
communication 9
content 9
design 9
develop 9
growth 9
including 9
products 9
understanding 9 
## Selecting by n
## `summarise()` ungrouping output (override with `.groups` argument)
## Selecting by n
word n
data analysis 6
data sets 4
data visualization 3
data analyst 2
data analytics 2
data architecture 2
data collection 2
data driven 2
data modeling 2
data quality 2 
## Selecting by n

word n
data 57
analytics 18
excel 5
tableau 5
sql 3
analyze 2
ai 1
python 1
sas 1