Returning Candidate?

Data Analyst Intern (AZ)

Data Analyst Intern (AZ)

# of Openings 
Job Locations 
Posted Date 

More information about this job


FMI Corporation's Compensation Group is seeking a data analyst intern to support the Data Services Team. The intern will respond to customer inquiries, and assist with the maintainance of the compensation database by cleaning and processing pay data files. The ideal candidate will possess strong technical and organizational skills, and a desire to contribute positively to a team of data professionals.


This full-time, paid internship requires a commitment of 40 hours per week for 8-12 weeks over the summer, and will be based in our North Scottsdale, Arizona office.


  • Ensuring consistency in queries, business rules logic, and throughout the ETL process
  • Identifying discrepancies between the database and the collection instrument
  • Working with the Data Services Team to clean and process raw data files, reconcile missing metadata, and prepare the data for upload to the database
  • Supporting the Data Services Team in liaising with clients regarding data archive issues
  • Performing other duties as assigned


  • Bachelor’s degree in-progress (rising juniors, seniors, or post-graduate students only) from an accredited college or university
  • Proficiency in MySQL database query language, data warehousing, data architecture, data quality processes, table structure, fact and dimension tables, database design, data modeling, reporting process metadata, and ETL processes
  • Proficiency in Microsoft Excel required
  • Basic understanding of statistics
  • Demonstrated integrity and the ability to handle a superior level of confidentiality concerning employee information
  • Excellent time management, interpersonal, communication, presentation, organization, decision-making, analytical and planning skills
  • The ability to perform in an entrepreneurial environment, both individually and as a team player