Business Analyst, Commercial Data & Reporting

About the role

The Business Analyst, Commercial Data & Reporting is an entry-level role responsible for supporting the company’s commercial analytics and reporting capabilities, with a primary focus on managing the accuracy and availability of VIP distributor sourced data as well as developing and optimizing reporting tools that focus on sales performance, program execution and evaluation. This role serves as a key owner of depletions, distribution, distributor inventory, distributor revenue and invoice adjustment-related data sourced from VIP, ensuring accuracy, consistency, and timeliness across commercial reporting. Working closely with the Director, Continuous Improvement & Commercial Analytics, this position is designed for individuals early in their careers or new to the wine industry who are eager to build expertise in distributor data, reporting, and modern business intelligence while pioneering applied AI.

Responsibilities

• Serve as the primary day-to-day resource for VIP data management, including depletion, distribution, distributor inventory, revenue, pricing, and related commercial data fields.
• Develop, maintain, and update Power BI Dashboards and Reports and data assets that support program execution, chain authorizations and out of stock monitoring, sales performance tracking, distribution tracking, and depletion analysis.
• Develop and monitor tools focused on ensuring data quality, availability and capacity efficiency of our commercial data assets in Fabric and Power BI
• Investigate and resolve data discrepancies related to distributor depletions, distribution, inventory, revenue, and invoice data by partnering with internal teams and distributor contacts as needed.
• Support distributor revenue and invoice adjustment reconciliation processes, helping ensure accurate visibility to commercial results and program spending.
• Assist in building and maintaining standardized reporting templates, scorecards, and recurring business reviews for Sales, Finance, and Commercial leadership.
• Monitor data quality and escalate issues proactively, ensuring timely and accurate reporting outputs for users across the business.
• Support annual planning, KPI tracking,