Product Pricing & Administration Analyst

General Summary

The Pricing & Operations Analyst provides administrative and analytical support to the Product Planning team, with a primary focus on port-installed option (PIO) pricing, pricing analytics and management reporting. This role coordinates PIO pricing across stakeholder departments, including Sales, Finance, Parts & Accessories (P&A), and Product Planning, and supports department budget planning, Product Planning vehicle fleet management, and administrative operations. The position performs diversified duties that require a high level of confidentiality and is well suited for candidates seeking to build a career in Product Planning.

Essential Duties and Responsibilities

• Priority One – 30%
  • • Port-Installed Option Pricing and Cross-Functional Coordination.
• Priority Two – 30%
  • • Pricing Analytics, Competitive Assessment, and Management Reporting.
• Priority Three – 20%
  • • Department Budget Planning and Administration

• Priority Four – 20%
  • • Departmental Meeting and Administrative Support, including internal and external meeting coordination, department supplies management, and general administrative support
    • Product Planning Vehicle Fleet Tracking and Audit as well as Evaluation Support

Personally Performed Duties

• Manage the end-to-end pricing process for port-installed options (PIOs), including validating FOB costs, researching competitive accessory pricing, evaluating dealer and company profitability, and developing pricing recommendations aligned with market positioning and corporate profit objectives. Coordinate with Product Planning, Parts & Accessories, Sales Distribution, and Finance to confirm option codes, penetration assumptions, financial viability, and final approvals; maintain accurate pricing in the PIO database, vehicle price sheets, and EADs.
• Maintain the accuracy and integrity of the price-value competitiveness (PVC) database by reviewing KHQ-provided feature values, cross-referencing Kia model content against PRG data, and validating competitor specifications through reliable third-party sources. Identify and resolve data discrepancies, document material changes, and ensure vehicle features and assigned values are consistently reflected for dependable cross-carline and competitive analysis.
• Prepare, validate, and distribute recurring pricing and pipeline reports, including the Weekly Price Report, Monthly Pipeline Summary, Monthly Paint Pipeline Summary, and Monthly Pricing Analysis Report. Consolidate data from SAP, AutoPlanner, J.D. Power PIN+, and other approved sources; reconcile outputs, investigate variances, and deliver accurate, timely analysis that supports pricing decisions, inventory visibility, and management review.
• Support department budget management throughout the annual business-planning cycle and fiscal year by developing budget inputs, creating and tracking purchase requests, monitoring expenditures, reconciling actuals against approved budgets, and maintaining current forecasts. Prepare status updates and supporting documentation, coordinate periodic reviews with Finance, and proactively identify variances, funding needs, and required corrective actions.
• Manage the Product Planning vehicle fleet and associated VIN records, including vehicle assignments, periodic audits, inspection documentation, maintenance scheduling, transportation, and policy-compliance tracking. Coordinate short-term evaluations and vehicle movements, and support logistics and vehicle preparation for auto shows, competitive evaluations, and other departmental events.
• Provide event and administrative support for major departmental business meetings by coordinating schedules, facilities, agendas, presentation materials, audiovisual requirements, catering, and other logistics. Communicate with presenters and internal stakeholders, track deliverables and deadlines, and ensure meetings are organized and executed professionally.

Qualifications/Education

• Bachelor’s degree or equivalent combination of education and work experience required

Job Requirement

• Minimum of 3 years of analytical experience required
• 3+ years of experience in the automotive industry preferred

Specialized Skills and Knowledge Required

• Proficiency in Microsoft Office (Word, Outlook, Excel & PowerPoint)
• Advanced Excel skills or strong aptitude and ability to learn Excel and other analysis tools
• Working knowledge of SAP and SAS
• Strong organizational skills
• Excellent written and verbal communication skills
• Detail-oriented / Self-starter
• Self-motivated, with the ability to exercise sound judgement within defined levels of authority. Ability to solve problems, interpret data, and recommend solutions
• Ability to adapt to changing priorities
• Planning & Organizing - Effectively applies ideas and material resources by clarifying the priorities, activity sequences, and planning of projects/tasks
• Customer Focus - Clearly recognizes both internal and external customers and the impact that task performance could have on them
• Market Understanding - Understands business and market trends to meet changing customer needs with adequate timing; applies necessary information to task planning and crucial decision making
• Strategic Thinking - Fully understands the purpose and content of the organization’s strategic plan, and executes tasks in alignment with larger organizational objectives
• Coordination & Integration - Optimizes process for efficiency through evaluation of resources and conflicting factors