Excel Pivot Table Consultant– NEW

Pivot Table Consultant – Freelance Project

Virtual Marketing Agency

Ref #950

Virtual Marketing Agency seeks Excel Pivot Table Consultant for freelance project. Ideal candidate is a freelancer/consultant with Excel Pivot Table experience. Will work with Raw Data from SurveyMonkey and convert data to pivot table chart. Survey results are widely distributed in the media. Analytical and quantitative skills are a must. Candidate must be able to work independently from start to finish. Must be available from 9/24 to 9/30/2021. 

Candidate must provide hourly billing rate and number of hours to accomplish the project as part of the application.

Qualifications and Necessary Skills:

  • Expert user in Microsoft Excel – Pivot Tables
  • Eager individual with strong attention to detail
  • Must be able to work on deadline and be able to accomplish the project between 9/24 to 9/30/2021
  • Strong analytical and quantitative skills — experience combining data sources and communicating results
  • Must have prior experience in SurveyMonkey to gather and analyze raw data
  • BA or BS in Business, Business Analytics, or Finance

Responsibilities

  • Work on salary survey report data analysis project 
  • Verify accuracy of raw data
  • Conduct calculations using Excel Pivot Table with approx. 1000 responding companies. Responses need to be analyzed incorporating:
    • 45 different job positions; by 7 different revenue size categories; Median salary reported for each 
    • Survey also includes 25 different questions by 20 industry types
  • Must be able to convert raw data to Excel within the timeline of 9/24 to 9/30/2021
  • Candidate must provide hourly billing rate and number of hours to accomplish the project as part of the application

To Apply: Forward your resume and samples. Please confirm your availability from 9/24 to 9/30/2021, your hourly billing rate, and the number of hours to accomplish this task to Lynn at lynn@lhazan.com. Refer to “Excel Pivot Table Consultant” in the header. www.Lhazan.c