Inventory Procurement Analyst

Inventory Procurement Analyst

Type : Full-Time, Remote

Working Hours : Monday to Friday 8 AM - 5 PM EST

Compensation : $3,500-$4,500 / month

The Role

We are seeking an accomplished Inventory Procurement Analyst to lead the design, execution, and ongoing refinement of our data-driven inventory and procurement strategy. Leveraging Microsoft Dynamics GP (Great Plains 2018), SQL, and advanced Power BI modeling, you will deliver real-time, actionable insights to maintain a 100% fill rate for owned inventory, while preventing overstock and optimizing warehouse space utilization.

This role blends deep technical acumen with practical supply chain strategyproviding procurement guidance at the SKU level that directly impacts operational performance and profitability.

Key Responsibilities

Data Architecture & Modeling : Design, build, and maintain a centralized Power BI data model and dashboard suite integrating Dynamics GP ERP data through SQL and ETL processes.

Inventory Monitoring & Forecasting : Deliver insights on current stock levels, inventory changes, and demand forecasts, with DAX-driven metrics like days of coverage, reorder alerts, and fill-rate projections.

Space Utilization Analysis : Assess warehouse capacity constraints and SKU storage footprint to optimize space allocation and reduce congestion.

PO Pipeline Visibility : Track and analyze the purchase order pipelineincluding lead times, supplier performance, and expected receiptsto identify risks and opportunities.

Procurement Decision Support : Weekly delivery of recommendations on SKUs to order, hold, or shift to drop-shipbalancing service level objectives with working capital efficiency.

Continuous Improvement : Identify data gaps, process bottlenecks, and reporting opportunities; propose enhancements to ERP configurations and data collection methods.

Cross-Functional Collaboration : Partner with procurement, operations, and finance teams to ensure analytics translate into actionable, aligned decisions.

What We're Looking For

Bachelor's degree in Supply Chain Management, Business Analytics, Data Science, or related discipline.

3+ years of experience in inventory management, procurement analytics, or supply chain analysispreferably in food distribution, FMCG, or related sectors.

Advanced SQL skills, including building queries, stored procedures, and ETL workflows.

Proven experience with Microsoft Dynamics GP 2018 data structures (inventory, purchasing, vendor management modules).

Expertise in Power BI (data modeling, DAX, dashboard design, forecasting functions).

Strong analytical, problem-solving, and decision-making abilities.

Excellent written and verbal communication skills, with a track record of presenting complex data to non-technical stakeholders.

Why Join Us?

Be part of a growing company modernizing its technology and operations.

Work hands-on in a fast-paced environment where your impact is visible.