Job Description

Please note: This position is based on-site in San Francisco, CA. At this time, Hotaling & Co. is not able to offer visa sponsorship.

The Financial Systems 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. This is an opportunity to be part of a small yet dynamic team in an organization with no dedicated IT department and partner with the Director of FP&A, Director of Commercial Operations, and other business partners, to help grow financial systems, tools, processes, and analytics. Principal responsibilities including, but not limited to:

Financial Systems Analysis:

• 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
• Subject Matter Expert for Price 2.0 (Revenue Management Platform) – reporting, reconciliation, and maintenance
• Subject Matter Expert for Datarails (FP&A Reporting Platform)

Data Analysis and Integrity:

• Item Master Data Maintenance
• Subject Matter Expert for iDIG/VIP Suite of Tools (Industry-Specific Reporting Platforms) – data reconciliation and reporting
• Generating and maintaining key relational tables across databases
• Primary contact and coordinator for internal and external partners related to above suites and their ongoing maintenance

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)

Additional Information

**Why work at Hotaling & Co. **

Number one, hands down… the people and the brands are unparalleled!

Great benefits:

• Medical, Dental, Vision,
• Car & Cell Phone Allowance
• FSA, 401k with Match,
• Life and AD&D, STD, LTD
• Employee Assistance Program
• Educational Assistance Program
• Annual National Company Meeting
• Paid Parental Leave
• Sick and Vacation hours
• 12 Paid Holidays
• Volunteer hours

Salary Range: $80,000 - $110,000