Business Analyst

Job Title: Business Analyst 1 Job Location: Warren, MI (Hybrid – 3 Days ~ Tue, Wed, Thu / Remote – Mon & Fri) Pay Rate: $33.50 – $37.48 / hour on W2 Only Job Type: Contract - 12 months Job Description: Position Overview The Business Analyst 1 supports the Product Management team in driving profitable growth within propulsion and performance parts portfolios. This role leverages data analysis, reporting tools, and cross-functional collaboration to inform pricing, inventory, and product strategy decisions across engines, transmissions, and related components. The position follows a hybrid schedule with in-office presence required three days per week, aligned with organizational hybrid work expectations. Top Technical Skills (Ranked) • Advanced Excel (expert-level data manipulation and analysis) • Power BI dashboard development • Familiarity with AI tools for reporting and workflow efficiency Key Responsibilities • Data Analysis & Reporting • Perform advanced Excel-based data analysis to support operational and strategic decision-making. • Prepare and analyze backorder and availability reports in partnership with Supply Chain to identify root causes and recovery timing. • Develop and maintain Power BI dashboards to visualize business performance and communicate insights. • Product & Pricing Support • Support pricing initiatives, including price setting, adjustments, and competitive benchmarking. • Analyze sales performance, retention trends, margin, and competitive positioning to support portfolio decisions. • Assist with core management processes, including dealer returns analysis and issue identification. • Provide actionable, data-driven recommendations to Product Managers. • Operations & Stakeholder Engagement • Utilize sales and aftersales systems to retrieve, validate, and analyze data. • Collaborate with supply chain, logistics, warehouse operations, and field teams. • Communicate complex analyses clearly and concisely to cross-functional stakeholders. • Participate in and occasionally support meetings to align on priorities and action plans. Required Qualifications • Bachelor’s degree (completed or in progress) preferred; equivalent experience considered. • Advanced Excel skills (complex formulas, pivot tables, large dataset analysis, data cleansing). • Experience building and maintaining Power BI dashboards. • Familiarity with AI tools to enhance reporting and communication efficiency. • Strong time management skills and ability to manage multiple priorities. • Ability to translate complex data into clear, actionable insights. • Experience working in automotive, manufacturing, OEM, supplier, or dealership environments preferred. • Strong communication and presentation skills. Preferred Qualifications • Experience working with customer care, aftersales, or parts-related processes and systems. • Working knowledge of powertrain systems (engines, transmissions, performance components). • Experience with electronic parts catalogs or sales/aftersales systems. • Demonstrated ability to work effectively in cross-functional teams. Work Environment Hybrid work model (3 days onsite, 2 days remote). Balanced workload: approximately 50% independent analysis and 50% collaborative teamwork. Interaction with cross-functional partners including supply chain, logistics, and dealership operations. Participation in standard organizational shutdown days. Thanks & Regards Archit Sharma Senior Associate – Recruitment – EST 609-353-5246 archit.sharma@russelltobin.com 420 Lexington Ave, 30th FL. New York, NY 10170 www.russelltobin.com/