Business Analytics and Reporting Intern (Summer 2027)

Merrill Manufacturing Company; Storm Lake (IA); Hybrid; USD 21,000 - 30,000; Full time

Job summary

Merrill Manufacturing Company in Storm Lake, IA invites applications for the Business Analytics & Reporting Intern to support data-driven decision making by analyzing business data, generating reports, and identifying trends.

You will collect, clean, and analyze data, build dashboards, present findings to leaders, and collaborate with cross-functional teams to improve data workflows.

Qualifications

• Must be a sophomore or higher pursuing a bachelor's degree in Business Analytics, Data Management Technology, Management Information Systems, Statistics, Business/Management Quantitative Methods, Accounting, or Finance

Responsibilities

• Collect, clean, and analyze operational, financial, and customer data
• Build and maintain dashboards and reports that track KPIs and other business metrics
• Identify trends, anomalies, and opportunities for process improvement
• Collaborate with cross-functional teams to support ongoing analytics projects
• Present findings and recommendations to business leaders
• Assist in automating recurring reports and improving data workflows
• Perform other related duties as necessary or assigned by direct supervisor

Skills

Analytical skills

Excel

Effective communication

Education

Bachelor's degree in Business Analytics / Data Management / MIS / Statistics / Finance

Tools

Microsoft Office

Job description

Description

ABOUT US

Merrill Manufacturing is North America's leading manufacturer of parts and accessories to the water well and water system industries. We are a family-owned company known for our incredible service, quality products, and diverse selection. Our values guide everything we do. Our team at Merrill strives to do the right thing, shares our passion for all we do, has a can-do, will-do attitude, thinks of we before me, and is willing to solve problems together.

JOB SUMMARY

The Business Analytics & Reporting Intern will support the organization’s data-driven decision-making by analyzing business data, generating reports, and identifying trends. This role is ideal for a student who enjoys working with data, solving problems, and communicating insights clearly to stakeholders.

WORK RESPONSIBILITIES & DUTIES

• Collect, clean, and analyze operational, financial, and customer data
• Build and maintain dashboards and reports that track key performance indicators (KPIs) and other business metrics
• Identify trends, anomalies, and opportunities for process improvement
• Collaborate with cross-functional teams to support ongoing analytics projects
• Present findings and recommendations to business leaders
• Assist in automating recurring reports and improving data workflows
• Perform other related duties as necessary or assigned by direct supervisor

Requirements

QUALIFICATIONS AND EDUCATION REQUIREMENTS

• Must be a sophomore or higher pursuing a bachelor's degree in Business Analytics, Data Management Technology, Management Information Systems, Statistics, Business/Management Quantitative Methods, Accounting, or Finance

PREFERRED SKILLS AND EXPECTATIONS

• Must have exceptional analytical skills and be able to work with complex sets of data
• Detail oriented with ability work with speed and accuracy
• Results focused, acts decisively, displays initiative
• Effective communication skills with the ability to interact with various levels and departments within the organization
• Excellent problem solving and critical thinking skills
• High proficiency in Microsoft Office, specifically Microsoft Excel

PHYSICAL DEMANDS

This position requires performing tasks that involve constant sitting and keyboarding. This means you'll be working at a computer for extended periods, so maintaining good posture and taking regular breaks to stretch and move around will be important.

WORKING CONDITIONS

The work environment for this position is consistently indoors. This means your daily tasks will be performed in an office setting or similarly controlled environment.