Vendor Monitored Inventory Analyst

Sazerac Company

$68K — $102K *
Technical Services
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • Bachelor’s degree in IT, Computer Science, Data Analytics, Supply Chain, or related field (or equivalent experience)
  • 2+ years in IT, data analysis, customer service, or automation roles
  • Proficient in SQL, including building views and tables
  • Advanced Microsoft Excel skills, including complex formulas, pivot tables, and Power Query
  • Hands-on experience with Power BI and understanding of DAX
  • Knowledge of programming or scripting languages (e.g., Python, Power Automate)
  • Strong analytical, organizational, and communication skills

Responsibilities

  • Collaborate with analysts in a dynamic, fast-paced environment
  • Design and optimize SQL queries for data extraction and reporting
  • Build and maintain Power BI dashboards for actionable insights
  • Create advanced Excel models with formulas and pivot tables
  • Develop automated solutions using Python and other scripting languages
  • Ensure data integrity and quality across platforms
  • Identify and automate manual processes for improved efficiency

Benefits

  • Comprehensive medical, dental, and vision coverage
  • 401K retirement savings plan
  • Paid time off
  • Hybrid work model
Full Job Description
Job Description/Responsibilities

The Vendor Monitored 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:

  • Collaborate with the analysts in a fast-paced environment, while adapting to changing business priorities.
  • 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/Requirements

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.

 

#LI-TH1

#Hybrid

 

Culture and Benefits

Culture and Benefits:

Sazerac offers a comprehensive compensation and benefits package that includes medical, dental, vision, 401K, paid time off, and more. These benefits may vary depending on location and work type. Learn more about how we support our employees here.

 

The annual salary range for this role is $68,257.70 - $102,386.59. Final compensation will be based on relevant experience, qualifications, geographic location, and internal pay equity considerations.

 

What’s Next:

After you apply, a recruiter will review your application and reach out to qualified candidates. Selected candidates will follow our interview process, which may include a phone screen, hiring manager interview, and panel interviews with business leaders. There may be additional steps or assessments throughout the process dependent on the position. Applicants who are not selected to move through the process, at any stage, will be notified via email.

 

 

Similar Jobs

More Jobs at Sazerac Company

More Technical Services Jobs

Find similar Vendor Monitored Inventory Analyst jobs: