About the role#
The Power BI & Analytics Intern will join the Business Intelligence & Systems (BIS) team to build, maintain, and optimize dashboards and reports. This role supports internal stakeholders across manufacturing, supply chain, finance, quality, and operations by turning data into actionable insights. You will work directly with the BIS team to gain hands-on experience in data visualization, business analysis, and ETL development.
What you'll do#
- Design and develop interactive Power BI dashboards, reports, and visualizations.
- Clean, transform, and analyze large datasets from sources including SQL Server, Excel, SharePoint lists, and other enterprise systems.
- Collaborate with business units, IT, and BIS team members to gather requirements and clarify data needs.
- Develop data models, DAX measures, and standardized business metrics.
- Contribute to data pipelines, ETL processes, and automation efforts.
- Perform data validation, reconciliation, and troubleshooting on existing reports to ensure accuracy.
- Document datasets, business logic, and processes.
- Use Jira to manage work items, track progress, and collaborate with the team.
What you'll need#
- Currently pursuing a Bachelor's degree in Computer Science, Information Systems, Data Analytics, Business Analytics, Engineering, Mathematics, Statistics, or a related field.
- Working knowledge of Power BI Desktop and Service, including report creation and data modeling.
- Basic knowledge of SQL Server with the ability to write SELECT queries, joins, filters, and aggregations.
- Strong proficiency in Microsoft Excel, including formulas, pivot tables, and Power Query.
- Familiarity with Microsoft SharePoint and Jira.
- Effective written and verbal communication skills.
- Strong analytical and problem-solving skills with attention to detail.
Location & details#
- Location: Ann Arbor, Michigan
- Term: Summer 2026
- Modality: On-site
- Employment: Full-time and paid
- Schedule: Working hours will be scheduled around class commitments but must remain consistent each week.
About East Penn Manufacturing Co.
East Penn Manufacturing Co. is a family-owned business founded in 1946. It specializes in the manufacture of batteries for motor vehicles. The company operates the largest single-site battery manufacturing facility in the world. Based in Bowers, Pennsylvania, it employs over 10,000 people and focuses on product recyclability.
How to get in at East Penn Manufacturing Co.
Securing an internship at East Penn Manufacturing Co. requires staying ahead of the competition. Because early applicants are often reviewed before the candidate pool becomes unmanageable, using Intern Insider helps by sending an instant alert the moment a role is published. This allows you to submit your materials among the first candidates.
Once you have identified an open position, you should try to connect with the people managing the hiring process. Intern Insider surfaces the recruiters behind the company's roles, which allows you to reach out directly. Asking a specific question about the role or inquiring about a referral can materially improve your response rates compared to a standard application.
