Programmer Analyst Intern Jobs in Detroit, MI (NOW HIRING)

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.

We are seeking a detail-oriented and analytical Power BI & Analytics Intern to join our BIS (Business Intelligence & Systems) team. The intern will assist in building, maintaining, and optimizing Power BI dashboards and reports that provide key business insights to internal stakeholders across manufacturing, supply chain, finance, quality, and operations.

This is an excellent opportunity for someone looking to gain hands-on experience in data visualization, business analysis, ETL development, and real-world data problem solving in a fast-paced manufacturing environment. The intern will work directly with the BIS team and collaborate with leaders across the company to deliver solutions that drive measurable business impact.

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.***Candidate must be lawful permanent resident or US Citizen and be able to work on site in Ann Arbor, MI

• Assist in designing and developing interactive Power BI dashboards, reports, and visualizations that surface key business metrics to internal stakeholders.
• Clean, transform, and analyze large datasets from various sources including SQL Server, Excel, SharePoint lists, and other enterprise systems.
• Collaborate with business units, IT, and BIS team members to gather requirements, clarify data needs, and deliver visualizations that drive decision-making.
• Support the development of data models (star schema), DAX measures, and standardized business metrics aligned to the company scorecard and metric glossary.
• Contribute to data pipelines, ETL processes, and automation efforts under guidance from senior BIS team members.
• Perform data validation, reconciliation, and troubleshooting on existing reports to ensure accuracy and reliability.
• Document datasets, transformations, business logic, and processes; contribute to best practices in dashboard design, data governance, and lineage tracking.
• Use Jira to manage work items, track progress, and collaborate with the team; publish documentation and updates to SharePoint.

• Currently pursuing a Bachelor's degree in Computer Science, Information Systems, Data Analytics, Business Analytics, Engineering, Mathematics, Statistics, or a related field.
• Must either be a US Citizen or have a valid green card
• Working knowledge of Power BI (Desktop and Service), including report creation, data modeling, and basic DAX.
• Basic knowledge of SQL Server and ability to write SELECT queries, joins, filters, and aggregations.
• Familiarity with Microsoft SharePoint for document management and collaboration.
• Familiarity with Jira (or similar work management tools) for tracking tasks and stories.
• Strong proficiency in Microsoft Excel (formulas, pivot tables, Power Query).
• Strong analytical and problem-solving skills with high attention to detail.
• Effective written and verbal communication skills; able to translate business questions into data requirements.
• Self-starter who can manage multiple priorities and work independently with guidance.

• Exposure to Power Query (M) and intermediate DAX measures.
• Familiarity with ETL concepts, data warehousing, and star schema modeling.
• Experience with Power Automate, Power Apps, or the broader Microsoft Power Platform.
• Exposure to MES, ERP, or manufacturing data environments.
• Coursework or projects involving data visualization, statistics, or business analysis.
• Understanding of data governance, lineage, and metric standardization concepts.