Responsibilities:
T
The Vendor Managed Inventory (VMI) Analyst plays a pivotal role in integrating and preserving accurate data from various systems to support consistent product availability across distributor warehouses and the broader supply network. This position is responsible for overseeing daily file management, ensuring the accuracy and efficiency of planning models, managing and supporting EDI transactions, building process monitoring systems, and upholding data integrity throughout all related processes. The VMI Analyst collaborates closely with the VMI Planning Team and cross-functional departments to develop and enhance streamlined, scalable processes that support a best-in-class VMI program. As our business continues to evolve, adaptability is key-this role requires a willingness to learn on the fly, embrace change, and bring a strong desire for continuous learning and improvement.
Key Responsibilities:
* Design, write, and optimize SQL queries for data extraction, transformation, and reporting
* Build and maintain Power BI dashboards and reports to provide actionable insights to business users
* Build robust Excel models and tools with advanced formulas, pivot tables, and Power Query
* Develop and maintain automated solutions using Python, Power Automate, or other scripting languages
* Ensure data integrity, quality, and system integration across platforms.
* Identify and automate manual processes across departments.
* Collaborate with business users to understand data needs and develop effective solutions.
* Maintain EDI integrity through monitoring and building more robust processes
* Develop analytical tools and benchmarks to evaluate the performance of the VMI program and identify areas for continuous improvement.
* Create and refine processes and reporting methods to support best-in-class performance
* Identify opportunities to improve efficiency with inventory monitoring and customer service delivery.
* Establish clear priorities, communicate roles and responsibilities effectively, and maintain effectively with other teams
* Partner with management to identify skill development opportunities, participate in training initiatives, and support long-term career planning.
Qualifications:
Minimum Qualifications:
* Bachelor's degree in Information Technology, Computer Science, Data Analytics, Supply Chain, or a related field (or equivalent experience).
* 2+ years of experience in IT, data analysis, customer service, or automation roles.
* SQL competency (building views/ tables, rewrite/ compile data, etc.)
* Proficiency in Microsoft Excel with business acumen, including:
* Advanced formulas (e.g., nested formulas, array functions, etc.)
* Pivot tables and Power Query
* Data validation and dynamic dashboards
* Hands-on experience with Power BI including DAX, data modeling, and data visualization.
* Programming or scripting knowledge (e.g., Python, Power Automate, etc.).
* Solid understanding of data integration and business process automation.
* Strong analytical and organizational skills with attention to detail.
* Excellent verbal and written communication skills.
* Proven ability to work both independently and in a team environment.
* Ability to quickly learn and adapt to new systems and processes.
* Ability to communicate effectively with all levels of the organization.
Preferred Qualifications:
* Willingness to travel as needed.
#LI-TH1
#Hybrid
Share this job:
Share this Job
