On-Site IT Intern - Summer 2026

Fenner Precision Polymers•Lititz, PA

4d•Onsite

About The Position

Fenner Precision Polymers has an exciting internship opportunity with Fenner’s Information Technology Department, located in Lititz, PA. The successful candidate will be responsible for identifying and categorizing company-wide Excel spreadsheets that use ODBC connections to the ERP System and assist with rewriting SQL statements in a new reporting tool to consolidate and secure these types of business reports. This position is based on-site, 5 days a week in Lititz, PA.

Requirements

Listening and interactive skills
Verbal and written skills
Analytical Thinking
SQL Queries, Power BI, and Data Visualization
Microsoft Excel intermediate skill level
Critical thinking and problem-solving
Knowledge of technical environment
Understanding business processes
Understanding change management
Minimum of 2 years education towards a Bachelor of Science in Computer Science, Information Technology, Data Analytics, Business Intelligence or Data Science degree

Responsibilities

Create a master list of all Excel reports to track the disposition of each as they are being analyzed.
Identify the department, users, frequency of use, and the purpose of the reports.
Determine the age requirements of the data being reported; real-time, near-time, or periodic.
Assess whether any reports are duplicate or similar in nature and qualify for consolidated reporting.
Develop a systematic approach for prioritizing the reports that need to be rewritten versus retired.
Collaborate with IT personnel to rewrite and secure these reports using the appropriate reporting tool.
Ensure the rewritten reports meet or exceed the prior report output by working with the business users to thoroughly test and validate before deploying.
Create documentation that supports the evaluation process, the disposition of each report, and the report details such as owner and frequency of use.
Complete a knowledge transfer to internal staff so they can continue the report rewrite process.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume