On-Site IT Intern - Summer 2026
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. What will you do? As part of the Enterprise System Team, you will be responsible for collaborating with various department managers across the business, and their staff members, to capture an inventory of their Excel ODBC reports. The following guidelines will be used to determine what reports should be rewritten using Power BI or a new reporting tool or simply retired. 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. About Fenner Precision Polymers Fenner Precision Polymers is a manufacturing company comprised of several preferred brands in the polymetric, metal and textile-based industries. Our solutions add recognized value to motion control, power transmission, and related applications. As a leader with a global footprint, our focus is on a variety of industrial niches where we deliver unique solutions and sustainable growth for our customers. Fenner Precision Polymers is a Michelin company backed by over 100 years of manufacturing, technical and commercial expertise in our industries. For more information, visit www.fennerppd.com or http://www.linkedin.com/company/fenner-precision-polymers , an Equal Opportunity Employer
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
- Identifying and categorizing company-wide Excel spreadsheets that use ODBC connections to the ERP System
- Assist with rewriting SQL statements in a new reporting tool to consolidate and secure these types of business reports
- Collaborating with various department managers across the business, and their staff members, to capture an inventory of their Excel ODBC reports
- 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.
What This Job Offers
Career Level
Intern
