Sql data analyst [h1.location_city]

Job Description

/ Responsibilities

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 / Requirements

Minimum Qualifications :

Preferred Qualifications :

#LI-TH1

#Hybrid

Culture and Benefits

A career at Sazerac offers you the opportunity to reach your full potential as part of a creative, decisive, high-performance team. Sazerac values the needs and wants of our team members and offers inclusive benefits to attract and retain the best talent. Our culture is built upon the values of hard work, diligence and personal responsibility.

Sazerac Team Members enjoy :

Benefits, salary range, and programs may vary by role or location. For roles within our commercial team - the Salary range refers to base salary only and does not include car allowance, annual bonus, fuel or cell phone reimbursement. Please ask your Talent Acquisition Partner for more information about our total rewards package. Sazerac is committed to equality of opportunity without regard to race, color, religion, national or ethnic origin, veteran status, age, gender, gender identity or expression, sexual orientation, genetic information, physical or mental disability or any other legally protected status.

Min

USD $66,269.64 / Yr.

Max

USD $99,404.46 / Yr.