Auburn Hills
Business Analytics Intern - Sales Data (Year-round | On-site)
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.Your Tasks
- 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.
Your Profile
- 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 Have: Experience working with sales or financial data, Exposure to Power BI or other visualization tools, Internship or project experience involving data automation
Julia Edwards
(+1) 2483394059