Salary Data Analysis Tool

Video Overview

Project Description

This project was completed as part of the UVA Development Hub's summer internship program. As an employee of the Development Hub, I oversaw code organization, assigned tasks to interns, taught concepts, and helped to debug code. Much of the project's code was written by the interns (Juliette Laburthe, Vinny Peng, I Jung , and Philip Hart), though significant chunks were written by me.

This project was inspired by the 2019 and 2021, AskAManager.org salary surveys which asked readers of the AskAManager blog to provide a variety of personal and demographic information related to their work and career. The surveys gathered data on age, industry of employment, job title, location, and annual salary, among other things. The 2019 and 2021 surveys garnered roughly 35,000 and 26,000 responses, respectively.

The purpose of this project was to provide an online tool which could be used to quickly analyze and extract information from the two datasets. Users are able to compare their own salary to those in similar positions and with similar backgrounds. The tool may be useful to people when entering salary negotiations or simply for gaining a better understanding of a field in which they work or plan to work.

Technologies Used

• React.js - frontend design, layout, and functionality
• Python, Pandas Library - data cleaning scripts.
• NodeJS - running backend REST API
• MongoDB - data storage and aggregation
• Express - REST API server framework
• Google Geocoding API - extracting latitude and longitude values from location data provided by survey respondants
• Google Maps Javascript API - plotting and displaying map pins to mark response locations
• Heroku - backend server hosting
• Netlify - frontend server hosting