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: $80000 - $110000
Remote Work :
No
Employment Type :
Full-time