Business Analytics Intern

MCNAUGHTON-MCKAY ELECTRIC CO • Madison Heights, MI

8d • Onsite

About The Position

Business Analytics Intern About McNaughton McKay Group: McNaughton McKay Group (MMG) is a 100% employee-owned distributor of electrical and PVF (pipes, valves, and fittings) solutions, serving the industrial, commercial and construction markets. Our portfolio of trusted brands operates from more than 60 branches across nine states and Germany. At MMG, we do more than deliver products. We build lasting partnerships—backed by deep inventory and local expertise—to keep your projects moving and businesses growing. Our empowered team provides the support, insight and scalable solutions needed to navigate today’s demands and solve our customers’ most complex challenges. Overview: The Business Analytics Intern supports the Category Management team by providing data-driven insights to enhance vendor relationships, optimize product category performance, and support strategic decision-making. This role works closely with category managers, vendor partners, sales, and marketing teams to analyze product performance, pricing trends, and supplier activity. Through training and hands-on projects, you will gain exposure to vendor coordination processes, product lifecycle management, and category strategy. You will build relationships across departments and develop both technical and business skills by working on real-time analytics initiatives that directly impact category growth and vendor alignment. As a Business Analytics Intern, you will:

Requirements

• Strong analytical and problem-solving skills with a data-driven mindset.
• Ability to interpret data and translate insights into actionable business recommendations.
• Strong communication skills, both verbal and written, with the ability to present findings clearly.
• Familiarity with SQL, Excel (pivot tables, VLOOKUP/XLOOKUP), or other data analysis tools.
• Detail-oriented with strong organizational and follow-up skills.
• Ability to manage multiple tasks and work independently with minimal supervision.
• Completed sophomore-level coursework.

Nice To Haves

• Experience with Power BI or similar visualization tools is a plus.
• Interest in supply chain, vendor management, or category strategy is preferred.

Responsibilities

• Collect, clean, and analyze internal and external data related to product categories, vendors, pricing, and sales performance.
• Support category managers in evaluating vendor performance, product assortment, and category profitability.
• Identify trends, gaps, and opportunities within product categories to support strategic planning and vendor discussions.
• Assist in preparing data-driven reports, dashboards, and presentations for internal stakeholders and vendor meetings.
• Collaborate with category management, purchasing, sales, and marketing teams to align on product strategies and initiatives.
• Support vendor coordination efforts, including tracking performance metrics, managing product data, and assisting with vendor communications.
• Contribute to pricing and promotional analysis to support category growth and competitiveness.
• Develop an understanding of supplier relationships, product portfolios, and industry trends relevant to assigned categories.
• Proactively research analytics tools and methods to improve data visibility and reporting efficiency.

What This Job Offers

• Career Level: Intern
• Education Level: No Education Listed