We are seeking a highly analytical and detail-oriented Data Analyst to support Aptiv’s Sales Distribution and Commercial Vehicle Sales team. This role will play a key part in driving data-driven decision-making by managing pricing models, sales trends, and distributor data. The ideal candidate will bring strong analytical skills, expertise in data management tools, and a proactive approach to improving sales operations.
Key Responsibilities:
Data Management & Cleansing
- Update and cleanse Point-of-Sale (POS) files from distributors, ensuring accuracy and consistency.
- Incorporate “Roll Up Name” into POS files and publish finalized versions.
- Post final POS files to relevant stakeholders.
Pricing Management
- Manage and update the distribution pricebook, including publishing updated versions to distributors and account managers.
- Investigate and ensure accuracy of price, plant, MOQ (Minimum Order Quantity), and standard pack in the SAP system.
- Review pricebook OI models and customer pricing models to provide actionable recommendations.
- Generate and maintain spot buys in SAP and handle strategic pricing adjustments.
Ship & Debit Program Management
- Oversee the Master Ship & Debit (S&D) list and maintain a database for tracking and reporting.
- Validate ship and debit claims, including POS record checks for duplicates and comparison to the S&D Master file.
- Submit, monitor, and close out all Ship & Debit PRTs (Pricing Request Tickets).
Sales Analytics
- Analyze distribution sales trends to identify insights and provide strategic recommendations to leadership.
- Develop and maintain sales funnel reporting tools for enhanced leadership visibility.
System Maintenance & Reporting
- Collaborate with manufacturing plants to ensure accurate updates in SAP systems for MOQ and standard packs.
- Regularly incorporate and update pricing data from the PRT system into SAP.
- Generate comprehensive sales reports and track performance metrics to support sales strategies.
Qualifications:
- Bachelor’s degree in Business Analytics, Data Science, or a related field.
- 3+ years of experience in data analysis, sales operations, or pricing management.
- Proficiency in SAP and data visualization tools such as Power BI or Tableau.
- Strong Excel skills, including advanced functions for data cleansing and analysis.
- Excellent attention to detail with the ability to manage large datasets.
- Strong communication skills to collaborate with cross-functional teams and present insights.
Traits We Seek
- Excellent communication skills
- Team oriented and self-driven, ability to network & collaborate with multiple stakeholders
- Ability to solve problems analytically, creatively and collaboratively
- A mindset to develop safety electronics to enhance driving safety
- An entrepreneurial mindset that’s driven by hands-on experimentation
- Seeing every challenge as a learning opportunity and invitation to grow
#LI-PG