Business Data Analysis Intern

Stoneridge • Novi, MI

1d • Hybrid

About The Position

Since 1965, Stoneridge has designed and manufactured advanced, award-winning technologies including driveline and transmission actuation systems, vision systems, emissions control systems, safety systems, and security and monitoring systems for vehicle OEMs in the commercial vehicle, automotive, off-highway and agricultural vehicle markets. We’re focused on the areas of greatest market need – both today and tomorrow. Our core products and technologies are aligned with industry megatrends including safety and security, vehicle intelligence, fuel efficiency and emissions. Join the Stoneridge Team as we continue to build upon our strong history and reputation for quality products to deliver innovative products and systems that address a need, exceed our customers’ expectations, and motivate our team. 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.

Requirements

• 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
• 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.
• 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
• 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.

Nice To Haves

• Data analytics, business analytics, business administration, supply chain management, or industrial engineering concentration preferred.
• Familiarity with data mining tools such as Power BI, power query, VBA, SQL, or Python preferred

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

What This Job Offers

• Job Type: Part-time
• Career Level: Intern
• Number of Employees: 5,001-10,000 employees