Internship Data Analysis Excel Jobs in Wisconsin

Any salary estimation specified in this job board may or may not be aligned with our organization’s pay philosophy. Apply to connect with a Talent Acquisition Partner who can provide you more details!

Cleaver-Brooks is seeking a Manufacturing Pricing & Inventory Data Analyst to support pricing and inventory decision-making within our Aftermarket parts business in Milwaukee, WI. This role focuses on developing analytics that improve pricing competitiveness, inventory availability, and proactive decision-making. The analyst will help modernize analytics currently performed using Excel and Access-based reporting, transitioning them into scalable solutions using Python, SQL, centralized data models, and Power BI. This role reports into the Genuine Parts organization and works closely with Pricing, Inventory, and Digital Solutions teams. The position also participates in the broader ALM Analytics Center of Excellence (COE) to ensure analytics are sustainable and reusable.

The level of this role (Data Analyst II or III) will be determined based on experience and demonstrated technical capability.

This position is an in office position located in Milwaukee WI

Essential Functions:

Pricing Analytics

• Develop analytics to monitor pricing competitiveness and market alignment.

• Create alerts and notifications when pricing deviates from benchmarks or when PPV risk increases.

• Analyze the impact of pricing changes on sales volume, margin, and market performance.

• Replace manual Excel-based pricing analyses with automated, repeatable solutions.

• Provide data-driven insights to support pricing decisions.

Inventory & Demand Analytics

• Build SKU-level demand and sales-velocity analytics.

• Create alerts for accelerating demand, stockout risk, and slow-moving inventory.

• Support decisions related to stocking strategies and target inventory levels.

• Analyze year-over-year and seasonal demand trends.

• Partner with inventory and supply chain teams to translate analytics into actions.

Data Modeling & Analytics Foundations

• Help transition analytics from Access databases and Excel reports to a centralized data model.

• Design and maintain structured tables, views, and datasets to support pricing and inventory analytics.

• Improve data quality, consistency, and usability for reporting and analysis.

Automation & Advanced Analytics

• Use Python to clean, transform, and analyze pricing and inventory data.

• Automate recurring analyses, alerts, and data refreshes.

• Store analytics outputs in database tables for consistent reporting and reuse.

• Collaborate with Digital Solutions and the ALM Analytics COE to support production-ready analytics.

Reporting & Visualization

• Build and maintain Power BI dashboards that present pricing and inventory insights clearly.

• Develop semantic models and data marts to support consistent reporting.

• Ensure dashboards align with business needs and decision-making workflows.

Key Outcomes

• Timely pricing and inventory alerts that support proactive decision-making.

• Reduced reliance on manual Excel and Access-based reporting.

• Improved visibility into SKU demand, pricing alignment, and inventory performance.

• Scalable, reusable analytics aligned with ALM Analytics COE standards.

Work Authorization Requirement

• Candidates must be authorized to work in the United States on a permanent basis without the need for current or future employer sponsorship. Applicants who require sponsorship now or in the future are not eligible for this position.

Required Qualifications

• 3+ years of experience in a Data Analyst, Business Intelligence Analyst, or similar role.

• Strong experience with:

• Python for data analysis and automation

• SQL and relational databases

• Power BI or similar BI tools

• Experience working with structured datasets and analytics workflows.

• Strong analytical, problem-solving, and communication skills.

Preferred Qualifications

• Experience with pricing, inventory, supply chain, or aftermarket analytics.

• Familiarity with pricing systems such as IFS; Zilliant experience is a plus.

• Experience modernizing legacy reporting environments (Excel, Access).

• Exposure to statistical analysis, forecasting, or demand modeling.

• Experience working in a data or analytics COE environment.

Benefits of Being a Cleaver-Brooks Employee:

• Competitive salary
• Comprehensive benefits, including medical, dental, vision, maternity support program, discounted virtual physician visits, voluntary medical benefits (Critical Illness, Hospital Care, and Accidental Injury), FSA, HSA, life insurance, short term and long-term disability
• Cash matching 401(k) plan
• Employee assistance program (EAP)
• Pet insurance
• Employee discount program
• Tuition assistance
• Paid time off and 11 paid holidays

Who is Cleaver-Brooks:

Cleaver-Brooks is the market leader in providing fully integrated boiler and burner systems. We lead the boiler/burner industry due to our unmatched distribution network’s ability to deliver the knowledge, service, training, and support that are essential to long-term performance. Our customers will tell you that we are the only equipment provider that manufactures boilers, burners, controls, and a full array of ancillary and aftermarket products. They will also mention that our unique single-source capability means that we can deliver fully integrated boiler room solutions that reduce overall costs and optimize space. It is our focus on products that deliver the most efficient, reliable, safe, and environmentally sustainable solutions that differentiate us in the marketplace. Cleaver-Brooks continues a 90+ year legacy of providing the customers we serve with extraordinary products designed to deliver unsurpassed performance through the power of commitment.

This description indicates the general nature of the tasks and responsibilities required of positions given this classification. It is not intended as a complete list of specific duties and responsibilities. Nor is it intended to limit or modify the right of management to assign, direct, and control the specific duties of individuals performing this function. The Company reserves the right to change, modify, amend, add to or delete from any section of this document as it deems, in its judgement, to be proper.

By applying for this job and providing your mobile number, you consent to receive an initial text message from a Cleaver Brooks Talent Team member. You will have the option to opt out upon receiving the message. Messages may include updates on your application, scheduling initial screenings or interviews, and similar communications. Standard message and data rates may apply, and message frequency may vary.