Data Analytics - Intern at IES Residential in Manitowoc, WI

Summary: IES is a national provider of industrial products and infrastructure services serving commercial, industrial, residential, and renewable energy markets. The Data Analytics Intern will collect, analyze, and present manufacturing and business data, develop reports and dashboards, identify trends, improve data accuracy, and provide insights that support operational and financial decision-making.

Responsibilities:
- Collect, organize, validate, and analyze data from manufacturing and business systems
- Assist in developing and maintaining reports, dashboards, and key performance indicators (KPIs)
- Use tools such as Microsoft Excel and Power BI to transform raw data into clear, actionable information
- Analyze manufacturing performance, including areas such as:
+ Production output and schedule attainment
+ Labor efficiency and productivity
+ Material usage and variances
+ Scrap, rework, and quality trends
+ Inventory levels and accuracy
+ Purchasing and budget adherence
+ Manufacturing costs and variances
- Identify trends, inconsistencies, and potential opportunities for operational improvement
- Assist with automating recurring reports and reducing manual data entry or manipulation
- Support data validation and cleanup efforts to improve the accuracy and reliability of business information
- Work with department leaders and subject matter experts to understand business processes and reporting needs
- Assist in documenting reporting processes, data sources, calculations, and standard procedures
- Participate in continuous improvement initiatives and special projects involving operational or financial data
- Present findings and recommendations in a clear, understandable format to both technical and non-technical audiences
- Perform other analytical and project-based assignments as needed

Required Qualifications:
- Collect, organize, validate, and analyze data from manufacturing and business systems
- Assist in developing and maintaining reports, dashboards, and key performance indicators (KPIs)
- Use tools such as Microsoft Excel and Power BI to transform raw data into clear, actionable information
- Analyze manufacturing performance, including areas such as: Production output and schedule attainment, Labor efficiency and productivity, Material usage and variances, Scrap, rework, and quality trends, Inventory levels and accuracy, Purchasing and budget adherence, Manufacturing costs and variances
- Identify trends, inconsistencies, and potential opportunities for operational improvement
- Assist with automating recurring reports and reducing manual data entry or manipulation
- Support data validation and cleanup efforts to improve the accuracy and reliability of business information
- Work with department leaders and subject matter experts to understand business processes and reporting needs
- Assist in documenting reporting processes, data sources, calculations, and standard procedures
- Participate in continuous improvement initiatives and special projects involving operational or financial data
- Present findings and recommendations in a clear, understandable format to both technical and non-technical audiences
- Perform other analytical and project-based assignments as needed

Required Skills: Microsoft Excel, Power BI, Data Analysis, Manufacturing Data Analysis

Benefits: Company 401K plan with Employer Contribution Match, Company Paid Time Off, Company Paid Life Insurance, Choice of Medical Coverage including Prescription and Short Term Disability Plans, Choice of Dental and Vision Coverage, Optional Long-term Disability, Critical Illness, Accident, Legal and Pet Coverage, Auto and Home Insurance Discount Programs