Inventory Procurement Analyst
Agent
full-time
Posted on:
Location Type: Remote
Location: Remote • 🇲🇽 Mexico
Visit company websiteSalary
💰 $3,500 - $4,500 per month
Job Level
Mid-LevelSenior
Tech Stack
ERPETLSQL
About the role
- 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 pipeline—including lead times, supplier performance, and expected receipts—to identify risks and opportunities.
- Procurement Decision Support: Weekly delivery of recommendations on SKUs to order, hold, or shift to drop-ship—balancing 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.
Requirements
- 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 analysis—preferably 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
Benefits
- Be part of a growing company modernizing its technology and operations
- Work hands-on in a fast-paced environment where your impact is visible
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SQLETLDAXdata modelingdashboard designforecastingdata analysisprocurement analyticsinventory managementdata visualization
Soft skills
analytical skillsproblem-solvingdecision-makingcommunication skillscollaborationpresentation skills