About the role#
The Business Intelligence & Systems team is seeking a Data Engineering Intern to support the development and maintenance of data pipelines, integrations, and warehouse infrastructure. This role involves working directly with enterprise systems to build the foundation of a modern data platform. Interns will gain experience in SQL development, ETL/ELT design, and data modeling within a manufacturing environment.
What you'll do#
- Design, build, and maintain ETL/ELT pipelines to move data from source systems into the central data warehouse.
- Write, optimize, and troubleshoot SQL queries, stored procedures, and views using SQL Server.
- Support the design and implementation of star schema models and data marts for downstream consumption.
- Integrate enterprise systems such as ERP, MES, and CRM into the central data platform.
- Monitor pipeline health, identify failures, and resolve data issues in collaboration with team members.
- Document data sources, transformations, and schemas to support data governance and metric standardization.
- Use Jira for task management and Microsoft SharePoint for documentation and collaboration.
What you'll need#
- Currently pursuing a Bachelor's degree in Computer Science, Data Engineering, Information Systems, Software Engineering, or a related field.
- Strong working knowledge of SQL, including joins, aggregations, subqueries, and window functions.
- Understanding of ETL/ELT concepts, data warehousing fundamentals, and relational data modeling.
- Proficiency in at least one scripting language, with a preference for Python.
- Familiarity with Microsoft SharePoint and Jira.
- Ability to work a consistent weekly schedule.
Location & details#
- Location: Ann Arbor, Michigan.
- Modality: On-site.
- Employment: Full-time, paid internship.
- Term: Rolling.
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.
