Precision Aviation Group (PAG) is a leading provider of products and value-added services to the aerospace and defense industries worldwide. With over 1.1 million square feet of sales and services facilities in the United States, Canada, Australia, Singapore, and Brazil – PAG’s 27 locations and customer-focused business model serve aviation customers through Supply Chain and Inventory Supported Maintenance, Repair, and Overhaul (ISMRO) services.
We have an opening for an Inventory Analyst position at our Atlanta Corporate Headquarters.

SKILLS:

• Advanced Excel Skills: Strong experience with pivot tables, VLOOKUP, INDEX/MATCH, data modeling, and financial analysis.
• SQL Proficiency: Ability to query and analyze large datasets from database systems.
• Power BI Experience: Capable of building dashboards and visualizing inventory trends to support decision-making.
• Strong Analytical Skills: Ability to interpret inventory data, forecast trends, and provide actionable insights.
• Cross-Functional Collaboration: Experience working with finance, accounting, and operations teams to align inventory goals with financial strategy.

PREFERRED QUALIFICATIONS:

• Experience working with large datasets and financial reconciliation processes.
• Experience with ERP Systems: Familiarity with Pentagon, Quantum, or other inventory management systems.
• Process Improvement Experience: Ability to streamline reporting and enhance inventory tracking processes.
• Industry Knowledge: Experience in Aviation MRO, manufacturing, or logistics is beneficial but not required.

JOB PURPOSE

The Inventory Analyst will play a critical role in optimizing inventory management, improving reporting capabilities, and enhancing financial analysis at PAG. This role requires a data-driven individual with strong analytical skills and proficiency in Excel, SQL, and Power BI. The ideal candidate will develop inventory efficiency reports, support financial reconciliations, and assist in vendor management initiatives. This position is essential in improving inventory planning, identifying cost-saving opportunities, and ensuring accurate financial reporting.

Additional Responsibilities:

• High-Demand Parts Planning: Work with stakeholders (e.g., Adam Fett) to forecast high-demand parts and improve inventory planning.
• Low-Demand Inventory Reduction: Identify strategies to reduce low-demand parts while minimizing financial impact.
• Market Price Analysis: Assess and track purchases of existing inventory where market prices have decreased, ensuring better procurement decisions.
• Part Tracking & Change Management: Monitor and report part modifications, including kitting, up-assembly, and substitutions.
• Intercompany Cost Analysis: Analyze cost differences across PAG locations to improve accuracy in intercompany pricing and financial reporting