Business Data Analysis Intern

Scope

• Facilitate a year around internship for graduate or undergraduate students in the field of business analysis, management, and planning.

Objective

• To provide students with real-world experience for real-world problems in data analytics and its application in business planning and provide Stoneridge with fresh talent and ideas to support on-going business challenges.

Structure

• Total of two students per year
• The student would work a flexible schedule averaging 20hours per week during school year
• Students would go full time for the summer (May, Jun, July, Aug).
• Hybrid schedule

Position Summary:

• At Stoneridge, we’re revolutionizing the automotive, commercial vehicle, agriculture and off-highway industries. Our technologies are aligned with industry megatrends and are making vehicles intelligent, safer and secure, and more efficient.
• The Stoneridge Internship Program offers an invaluable experience for any student that wants to jump start their career. We ensure that our interns receive a well-rounded experience – from mentorship, the opportunity to collaborate on global programs, and the ability to work with like-minded, innovative professionals.
• The intern would engage in support activities for forecast management and reporting activities, new business quotes, coordination with Product Line Management and Sales teams, market research, product line profitability, developing the communication stream and management of both new and carry-over business awards, how the volumes and supply chain planning process connect, and improve the coordination with program launch cross-functional teams and the manufacturing facilities.

Major Responsibilities

• Engage with cross-functional teams including Sales, Product Line Management, Operations, Finance, Purchasing, and Engineering to develop, implement, and manage data analysis strategies.
• Use data tools including Campfire (Forecasting), JDE (ERP), PowerBI (Analysis), and S&P Global (outside 3rd party market data) to analyze data, draw conclusions, and develop actions for the cross-functional team.
• Under the guidance and support of team leaders, assist in the development and communication of Business Process improvements between Sales, Product Team Lead and Project Management.
• Support real-time business operations including bookings, product line profitability, new business opportunity management, and pricing analysis

Qualifications:

• Must be a full-time student at an accredited University pursuing a minimum of a bachelor’s degree
• Maintain a 3.0 GPA or better, and complete a minimum of two years of Postsecondary education or first year if master’s degree
• Data analytics, business analytics, business administration, supply chain management, or industrial engineering concentration preferred.
• Proficient with MS Office tools. Intermediate Excel skills a must. Must know how to make charts, pivot tables, use formulae such as VLOOKUP, XLOOKUP, index functions, etc. Move it up to point 4 on the list.
• Available to work 40 hours a week during summer, 20hours per week during school
• Available to work in a hybrid setting out of Novi headquarters
• Must be detail oriented and a self-starter
• Familiarity with data mining tools such as Power BI, power query, VBA, SQL, or Python preferred
• Must be able to interpret and explain data analyzed to technical and non- technical audiences alike.
• Good communication skills, willingness to interact with global, cross-functional teams regularly.