/Marketing-Job-Market-Analysis

Used python(numpy, pandas, matplotib, and seaborn) to analyze the data from h1bdata.info to understand the situation of H1B for marketing jobs.

Primary LanguageJupyter Notebook

Marketing-Job-Market-Analysis

Used python(numpy, pandas, matplotib, and seaborn) to analyze the data from h1bdata.info to understand the situation of H1B for marketing jobs.

Dataset Overview

This dataset is from h1bdata.info, where has the h1b disclosure data from the United States Department of Labor (DOL).

Research Questions:

  1. Which is the most popular marketing job?
  2. H1B issue amounts over years?
  3. Which marketing job gets paid the highest salary?
  4. H1B denial rate over years?
  5. Waiting days for H1B?
  6. Which states offer the most H1B?
  7. Which states offer the highest salaries?

Insights:

Limitation: All these data are disclosure date from h1bdata.info, so we don't know how many unpublished data out there. Therefore, we should have some degree doubt the numbers presented above.

  • Two most popular marketing jobs: Marketing Specialist(60%) & Marketing Analyst(35%)
  • The demand for Marketing Analysts is predicted to increase 20% by 2028.
  • Salary Rank by job title: SEO Strategist > Marketing Analyst > Marketing Specialist
  • Marketing H1B Average Waiting Days is 147 days. Don’t panic. It’s 30 days fewer than the average.
  • In-demand skills: Google Analytics > Excel > A/B Testing knowledge
  • New Trends: Data Science in Marketing ( Python > SQL > Machine Learning Knowledge )
  • Marketing Salary Rank by location: San Francisco > San Jose > Boston
  • Marketing H1B Issue Amount Rank by location: New York > San Francisco > Los Angeles