Business Intelligence & Data Analytics Intern- OH

Mum Industries; Mentor (OH); On-site; USD 23,000 - 32,000; Full time

Job summary

MUM Industries in Mentor, OH is seeking a BI & Data Analytics Intern (college student or recent grad) to gain hands-on experience with Power BI, SQL, ERP systems, and advanced Excel tools. This internship offers exposure to dashboards, data integration, and reporting solutions that support manufacturing and operational excellence.

You will help develop interactive Power BI dashboards, build SQL queries, validate data, and document data sources while collaborating with cross-functional teams.

Qualifications

• Currently pursuing a Bachelor's degree in Information Systems or a related field; junior or senior standing preferred, or a recent graduate.
• Interest in data analysis, technology, and business process improvement.
• Strong analytical and problem-solving skills.
• Comfortable working with data and learning new software applications.
• Eagerness to learn, ask questions, and contribute to meaningful projects.
• Ability to work independently while collaborating with a team.

Responsibilities

• Develop and maintain interactive Power BI dashboards and reports used by leaders across the organization.
• Assist with data integration, system implementations, and migration projects.
• Create meaningful data visualizations, scorecards, and KPI dashboards for informed decision-making.
• Validate data accuracy and investigate reporting discrepancies to ensure reliable insights.
• Extract, organize, and analyze data from ERP systems, SQL databases, and other applications.
• Build and modify SQL queries to support reporting and analytics; document sources and rules.

Skills

Business Intelligence

Data Analytics

Data Visualization

Problem Solving

Communication

Critical Thinking

Process Documentation

Independent work

Education

Bachelor's degree in Information Systems / Data Analytics

Tools

Power BI

SQL

Excel

ERP Systems

Pivot Tables

Power Query

Job description

Job Details: Level: Entry, Job Location: Headquarters - Mentor, OH, Position Type: Internship, Education Level: 4 Year Degree, Salary Range: $20.00Hourly, Job Shift: Day, Job Category: Manufacturing, Business Intelligence & Data Analytics Intern (College Student or Recent Graduate)

Turn Data Into Decisions. Build Insights That Drive Business Success.

Are you passionate about technology, data, and solving real-world business challenges? We're looking for a motivated Information Systems student, junior-level college student, or recent graduate who wants hands-on experience working with business intelligence tools, data analytics, and reporting solutions that support manufacturing and operational excellence.

This is an excellent opportunity to apply what you've learned in the classroom while gaining practical experience with industry-leading technologies such as Power BI, SQL, ERP systems, and advanced Excel tools.

What You'll Learn & Do

Business Intelligence & Reporting

• Help develop and maintain interactive Power BI dashboards and reports used by leaders across the organization.
• Assist with data integration, system implementations, and migration projects.
• Create meaningful data visualizations, scorecards, and KPI dashboards that help teams make informed business decisions.
• Validate data accuracy and investigate reporting discrepancies to ensure reliable business insights.

Data Analytics & Database Support

• Extract, organize, and analyze data from ERP systems, SQL databases, and other business applications.
• Build and modify SQL queries to support reporting, analytics, and operational improvements.
• Document data sources, report requirements, and business rules to support consistent reporting practices.
• Identify trends, patterns, and opportunities within business data to support continuous improvement initiatives.

Technology & User Support

• Assist team members in utilizing reporting and analytics tools effectively.
• Help troubleshoot data and reporting issues while learning best practices in business analytics.
• Collaborate with cross-functional teams to understand business processes and data needs.

Skills You'll Develop

• Business Intelligence & Analytics
• Microsoft Power BI
• SQL Query Development
• Data Visualization & Dashboard Design
• ERP System Reporting
• Microsoft Excel (Pivot Tables, Power Query, Advanced Formulas)
• Data Validation & Quality Control
• Process Documentation
• Business Process Analysis
• Problem Solving & Critical Thinking
• Professional Communication

What We're Looking For

• Currently pursuing a Bachelor's degree in Information Systems, Business Analytics, Computer Information Systems, Data Analytics, Computer Science, or a related field (Junior or Senior standing preferred), or a recent graduate.
• Interest in data analysis, technology, and business process improvement.
• Strong analytical and problem‑solving skills.
• Comfortable working with data and learning new software applications.
• Eagerness to learn, ask questions, and contribute to meaningful projects.
• Ability to work independently while collaborating effectively with a team.

This role provides valuable real-world experience that can lead to careers in:

• Business Intelligence Analyst
• Data Analyst
• Business Systems Analyst
• ERP Analyst
• Reporting Analyst
• Data Engineer
• Power BI Developer
• IT Business Analyst

About MUM Industries:

We are always looking for driven, talented people to join our team.

Founded in 1996, MUM Industries, Inc. is the parent company to a diverse group of industrial product manufacturers: Integra Enclosures, EMF MFG, and StrongBox. With seven locations across the globe, MUM Industries provides the products and services how our customers need it, where they need it and when they need it.

We believe in empowering and nourishing our employees with the tools, skills, and knowledge needed to grow and succeed. We are committed to meeting and exceeding our customer's expectations by providing world-class products and service through continuous improvement and innovation.

When you join MUM Industries, you join a family devoted to achieving the highest standards of success together. We support the development and empowerment of our employees through an environment fostering open communication, integrity, and respect. Our collaborative and rewarding atmosphere gives us the opportunity to work with and continuously learn from our intelligent, skilled colleagues.