Business Analytics Intern - Sales Data (Year-round | On-site)

Brose•Auburn Hills, MI

15d•Onsite

About The Position

As a successful family-owned company on a path to global growth, the Brose Group offers challenging responsibilities and exciting career opportunities to performance-driven, skilled specialists with solid professional knowledge and proven career expertise who wish to contribute to our company’s success.

Requirements

Currently pursuing a degree in: Industrial Engineering, Business Analytics, Data Analytics, Finance, or related field
Strong proficiency in Microsoft Excel preferred: VBA / Macros, Pivot Tables, Power Query / Power Pivot., Data visualization (charts, dashboards)
Experience with automating recurring reports or processes is highly preferred
Analytical mindset with strong attention to detail
Ability to work independently and improve existing processes

Nice To Haves

Experience working with sales or financial data
Exposure to Power BI or other visualization tools
Internship or project experience involving data automation

Responsibilities

Develop and automate recurring sales reports using advanced Excel tools (VBA, macros, Power Query).
Analyze and structure sales data to improve reporting efficiency and accuracy.
Create automated dashboards and visualizations (pivot tables, charts) to support business decisions.
Maintain and enhance existing Excel-based reporting tools and databases.
Support the sales team with data-driven insights, including pricing, cost breakdowns, and customer trends.
Assist in data entry, validation, and cleanup to ensure high-quality reporting.
Collaborate with cross-functional teams (sales, controlling, engineering) to streamline reporting processes.
Identify opportunities to reduce manual work through automation and process improvement.