Intern - Data and Business Analytics

Primary Work Location :

50 Washington Street, Westborough, MA. Hybrid and remote work available.

Job Summary :

The University of Massachusetts President's Office, located in Westborough and Boston, MA, is offering a 20-hour-a-week internship for current UMass students the 2024 / 25 academic year.

This is a paid internship, and academic credit may also be available. The selected candidate (s) will intern directly with the Data Analytics and Business Associate functions within the Service & Quality function of the UPST.

Those selected for this internship will gain valuable knowledge of the inner workings of the University of Massachusetts.

Interns in the President's Office have the unique experience of working side-by-side with staff supporting various functions, including UITS, Employee Services, HR, Treasury, etc.

The objective of this internship will be to support the intern in building and solidifying their data analytics, programming, procurement, accounts payables, sourcing, contracts, and customer service skill set while supporting UPST daily activities.

Essential Functions :

Interns will be responsible for :

• Support the Data & Analytics function with the development of data models that support the creation of visually interactive and actionable dashboards using data visualization tools like Tableau, Power BI, and Looker.
• Analyze, understand data, and identify data issues and anomalies, document them, and work with IT professionals to put processes in place to correct them.
• Acquire data from primary or secondary data sources and maintain databases / data systems.
• Identify, analyze, and interpret trends or patterns in complex data sets.
• Filter and "clean" data by reviewing computer reports, printouts, and performance indicators to locate and correct code problems.
• Actively run data models in Python and assist the team with transaction forecasting.
• Provide phone, email, and online customer support to internal and external procurement, accounts payable, contracts, sourcing, and procurement technology.
• Work closely with the UPST Leadership and process owners in driving their strategic improvement initiatives concerning the impact on end-users.
• Work closely with the Director of Service and Quality and other team members to develop and implement customer engagement and satisfaction strategies.
• Research issues needing resolution and develop solutions that comply with all applicable UPST processes, procedures, and policies.
• Recognize pre-determined triggers for escalation as well as the ability to search the knowledge base and provide clear directions based on defined solutions

Minimum Qualifications (Knowledge, Skills, Abilities, Education, Experience) :

• Current UMass student who is enrolled in an undergraduate or graduate program of study within Communications, Marketing or General Business courses.
• GPA 3.0 or higher.
• Creative, eager to learn, motivated, and willing to take initiative on assigned projects / tasks.
• Reliable and detail-oriented with a strong ability to multi-task, stay organized, and meet deadlines.
• Ability to work independently and as part of a team.
• Must be well organized, detail-oriented, and possess good follow-up skills.
• Strong attention to detail and experience in proofreading / editing copy.

Preferred Qualifications (Knowledge, Skills, Abilities, Education, Experience) :

• Ability to multi-task across multiple systems.
• Strong working knowledge of MS Office with an emphasis on strong Excel and Pivot Table capabilities
• Extremely proficient with Tableau and comfortable in creating and modifying dashboards.
• Proficient in Python code and Predictive modeling.
• Great communication skills and adept in handling stressful situations.
• Knowledge of a CRM tool like Salesforce preferred.

Working Conditions :

Any offers of an internship within the President's Office is specifically conditioned upon the potential candidate consenting to and successfully completing a background review.