Data Engineering Intern

East Penn Manufacturing Co.

Posted about 22 hours ago

Internship

Pittsfield Charter Township, Michigan

In Person

Smart Summary

Responsibilities

The intern will design, build, and maintain ETL/ELT pipelines to move data from various enterprise systems into a central data warehouse. They will also optimize SQL queries and support the implementation of data models to power analytics and reporting in Power BI.

Qualifications

You are currently pursuing a Bachelor's degree in a related technical field and possess strong SQL skills. You have familiarity with ETL/ELT concepts, data warehousing fundamentals, and at least one scripting language like Python.

Must Have Skills for ATS

SQL

SQL Server

PostgreSQL

MySQL

Oracle

Python

PowerShell

SharePoint

Jira

Power BI

Power Query

DAX

Git

Azure

Fabric

OneLake

Databricks

Snowflake

API

REST

JSON

ERP

MES

Job Description

Get to know East Penn!

Navitas Systems LLC, a leader in comprehensive energy storage solutions, was formed in 2011 with the merger of MicroSun Innovative Energy Storage Solutions and MicroSun Electronics, and the acquisition of lithium battery company A123 Systems’ Government Solutions Group. In 2019, East Penn Manufacturing, one of the world’s leading battery manufacturers, acquired majority interest in Navitas Systems. In SEVEN remarkable decades, East Penn has grown from a one-room shop with a product line of five automotive batteries to one of the world’s leading battery manufacturers with over 10,500 full-time employees, 515 product designs, operations around the world, and hundreds of awards for industry excellence.

At our Navitas facilities we engage in the research, design, development, and manufacture of advanced lithium cells and energy storage products and systems for both commercial customers and U.S. Government/military customers. We invest in our people, they are and always will be the heart of this company. Are you ready to join a family-owned enterprise committed to honoring the contributions of everyone? Then Navitas is the right place for you.

Overview

We are seeking a curious and technically strong Data Engineering Intern to join our BIS (Business Intelligence & Systems) team. The intern will help build and maintain the data pipelines, integrations, and warehouse infrastructure that power analytics, reporting, and decision-making across Navitas.

This is a hands-on opportunity to work directly with enterprise systems and contribute to the foundation of a modern data platform being built from the ground up. The intern will gain real-world experience in SQL development, ETL/ELT design, data modeling, and integration patterns in a fast-paced manufacturing environment.

Working hours will be scheduled around the intern's class schedule, but must be the same days and hours each week. The intern is expected to confirm their weekly schedule with their manager within two weeks of their start date.

Responsibilities

  • Assist in designing, building, and maintaining ETL/ELT pipelines that move data from source systems (ERP, MES, CRM, SharePoint, Excel) into the central data warehouse.
  • Write, optimize, and troubleshoot SQL queries, stored procedures, and views against SQL Server databases.
  • Support the design and implementation of star schema models, data marts, and semantic layers that feed Power BI and downstream consumers.
  • Help connect and integrate enterprise systems (Expandable ERP, Ignition MES, Salesforce, Dayforce, Jira) into the central data platform.
  • Build and run validation checks to ensure accuracy, completeness, and consistency of data flowing through pipelines.
  • Contribute to scheduled jobs, refresh cadences, and automation efforts that reduce manual data movement and reporting overhead.
  • Assist in monitoring pipeline health, identifying failures, and resolving data issues in partnership with IT and BIS team members.
  • Document data sources, transformations, schemas, and lineage; contribute to data governance and metric standardization efforts.
  • Use Jira to manage work items and SharePoint to publish documentation; collaborate with BI developers, analysts, and business stakeholders.

Qualifications

Required

  • Currently pursuing a Bachelor's degree in Computer Science, Data Engineering, Information Systems, Software Engineering, or a related field.
  • Strong working knowledge of SQL (joins, aggregations, subqueries, window functions) against relational databases.
  • Familiarity with SQL Server or comparable RDBMS (PostgreSQL, MySQL, Oracle).
  • Understanding of ETL/ELT concepts, data warehousing fundamentals, and relational data modeling.
  • Proficiency in at least one scripting language (Python preferred; PowerShell or similar acceptable).
  • Familiarity with Microsoft SharePoint for collaboration and documentation.
  • Familiarity with Jira (or similar work management tools) for tracking tasks and stories.

Preferred

  • Exposure to Power BI (semantic models, Power Query, DAX basics).
  • Familiarity with star schema / dimensional modeling (Kimball methodology).
  • Experience with Git and version control workflows.
  • Exposure to cloud data platforms (Azure, Fabric, OneLake, Databricks, Snowflake) or on-premises data lake/lakehouse concepts.
  • Familiarity with APIs, REST, JSON, and integration patterns between SaaS systems.
  • Exposure to MES, ERP, or manufacturing data environments.
  • Understanding of data governance, lineage, and metadata management concepts.
  • Coursework or projects involving data pipelines, distributed systems, or large-scale data processing.

East Penn Manufacturing Co.

A PASSION TO EMPOWER As a family-owned company, our mission is to help make lives better, one battery at a time. We are proud to have a significant impact by operating the largest single-site battery manufacturing facility in the world – and we’ve only just begun! In 1946, we started out as a family-owned company and that hasn’t changed since. As a family of employees, we’re making the products that are helping to empower people’s lives. Our business model has been highly focused on recyclability and the conservation of natural resources, which has enabled us to be a good neighbor and successfully build products with sustainability in mind.
Runway Icon
Boost Your Interview Chances

With Runway

See Your Fit for This Role

1-5 min

Your Score

?

Top Applicants

90%

Your Job Search Advantage

Key Gaps & Next Steps:

Address these in your resume & Interview

Top Strengths For This Role

Highlight these in your cover letter & interview

Your Interview Guide

A Personalized Interview Strategy

Freshest Opportunities

Never Miss a Good Fit

Get notified when jobs mach your criteria