Back to Jobs

Financial Systems and Data Analyst

Hotaling & Co. • San Francisco, California, United States • Full-time

$80,000

per year

FP&A Data Analyst Financial Analyst commercial operations Artisanal Spirits

Job Description

Company Description

A born and bred San Francisco original, Hotaling & Co. is the leading distiller and importer of artisanal spirits and cocktail essentials. Our dedication to artisanal spirits first started 30 years ago under the name Anchor Distilling Company - heralding the return to copper pot distilling in the U.S. with the original craft introductions of Junipero Gin & Old Potrero Straight Rye Whiskey. We carry on that pioneering legacy with the name Hotaling & Co. as a nod to the local legend A.P. Hotaling, who ventured West during the Gold Rush and quickly became one of the most reputable spirits dealers in the country and a notable figure in American drinking culture. Fueled by a passion for beverage expertise, education and hospitality, Hotaling & Co. carries on this tradition of artisanal excellence by bringing together a family of likeminded spirits that share our commitment to craft and care.

Today, Hotaling & Co.’s portfolio is synonymous with brands of unmatched quality and character, including Luxardo Liqueurs & Cherries, Nikka Whisky, Junipero Gin, HINE Cognac, Convite Mezcal, Severo Tequila, Kavalan Whisky, Denizen Rum, HIRSCH Selected Whiskeys, Writers' Tears Whiskey, Old Pulteney Whisky, Speyburn Whisky, Balblair Whisky, Arran Whisky, Old Potrero Rye Whiskey, and more. Visit www.HotalingandCo.com to explore our full range of brands.

Job Description

This Financial Systems and Data Analyst provides critical support to the FP&A and Commercial Operations groups in enabling regular reporting and commercial analytics while maintaining data integrity and system optimization.

Principal responsibilities:

Commercial Analytics

Partner with Director of FP&A, Director of Commercial Operations, and other business partners to structure the reporting and analysis of quantitative and qualitative data, including but limited to
- Shipment and Depletion data
- Distributor Allowances
- Category Analytics
- Advertising and Promotional Spend and Funds
- Maintain, design, develop, and distribute reports and dashboards using standard data definitions in support of financial and commercial analytics
Utilize Outputs from Commercial Systems to generate Price related accruals

Data Integrity and Maintenance

Item Master Data Maintenance
Subject Matter Expert for iDIG/VIP Suite of Tools (Industry Specific Reporting Platforms) and Data Reconciliation
Subject Matter Expert for Price 2.0 (Revenue Management Platform) and Data Reconciliation
Subject Matter Expert for Datarails (FP&A Reporting Platform)
Primary contact and coordinator for internal and external partners as it relates to above suites and their maintenance
Generating and maintaining key relation tables across databases

Ad hoc projects in support of Data Visualization and Accessibility, Data Aggregation and Analysis

Qualifications

BS or BA in Accounting, Finance, Economics, or Statistics
3+ years of direct, relevant experience in FP&A and/or core commercial areas (Brand, Customer & Channel Development, Planning & Analysis) preferred
Proven system, database, and data agility; Microsoft Office 365 Suite, Microsoft Dynamics, Datarails, PowerBI, Tableau and/or similar tools preferred
Familiarity with SQL and DAX languages
Development and presentation of financial and commercial information that aid and improve the day to day decisions
Strong communication skills (written, verbal, and presentation) and detail orientation
True team player and self-starter with a keen sense of urgency, who likes to see the big picture and focuses on details
3+ year experience within a CPG industry preferred ( U.S. beverage alcohol segment is a plus)