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
Privacy Notice - Active Candidates: https://www.aptiv.com/privacy-notice-active-candidates
Aptiv is an equal employment opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, national origin, sex, gender identity, sexual orientation, disability status, protected veteran status or any other characteristic protected by law.
Top Skills
What We Do
Aptiv is a global technology company that develops safer, greener and more connected solutions enabling the future of mobility. #ItsOurMove
