Student Intern - Data Analyst - Management Information Systems Department

Salary $17.91 Hourly Location Racine, WI Job Type Part-Time Department Information Systems Job Number 202200513 Job Description

Job Description

The City of Racine is restarting its Smart Cities Initiatives. There are many opportunities for Federal Funding with the ARPA and Infrastructure Bill. The city needs to collect, organize, map, and present a lot of information regarding Smart Cities. There are many opportunities for student involvement. This is very impactful work because the purpose of a Smart City is to improve the lives of a city's citizens and increase economic development through appropriate use of technology.

Expected Outcome for Student

Gather and analyze multiple types of data
Ability to explore data analysis as a career path
Increase in data analysis skills with hands-on experience
Experience working for a city government
Network with professions in the field
Gain confidence in classroom learning

Position Purpose:

Under the direction of the Chief Information Officer, this position takes current data and combines with newly gathered data to show where the need for smart city projects is in the city. Helps tell the story of what the problem is, what has been done and what the new solutions could improve.

Essential Duties

Essential Duties

  • Schedule, plan, and gather federal, national, state, and local data
  • Organize data and look for correlation or missing data
  • Collect metadata, document and summarize data
  • Assist in presentation of data
  • Create documentation for data gathering process so can be repeated in subsequent years
  • Research anything you don't know how to do and ask questions for guidance
  • Other duties as assigned around data analysis


  • Skills in SQL, database structure, and Microsoft excel
  • Prefer Python
  • Ability to think critically, visualize data, and analyze data for different purposes
  • Excellent time management skills, organization, attention to detail
  • Knowledge of how to gather data, organize, and ask critical question regarding possible missing data

Educational Requirements:

Undergraduate or graduate college student enrolled and intend to continue in school for the next semester. A full-time student shall consist of a minimum of 12 credits per semester and part-time student shall consist of less than 12 credits but more than 3 credits.
Currently attending a two or four year college/university
At least 2 courses in Data Analytics or 1 in Data Analytics and 1 in Statistics or similar course work Supplemental Information

Physical Demands of the Position
Sitting and typing at a terminal while viewing a computer screen.

Environmental/Working Conditions of the Position
Sitting at a desk in an air-conditioned/heated office or working from home.

Equipment Used
Telephones, computer with associated peripherals, and software.

Expected Work Schedule
Schedule will be determined after hiring. Applicant must be available to meet with City of Racine employees during the day from Monday - Friday 8:00a.m. - 5:00p.m.

Salary Range
$24,000.00 - $40,000.00
per Year
Salary range estimated by
salary estimation provided by zippia
Racine, WI, 53404, US