ZipRecruiter
Financial Systems Analyst - Commercial Finance Operations (On-site)
ZipRecruiter, San Francisco, California, United States, 94199
Job DescriptionJob DescriptionCompany 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
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) Proven system, database, and data agility; Microsoft Office 365 Suite, Microsoft Dynamics, Datarails, PowerBI, Tableau and/or similar tools Familiarity with SQL and DAX 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 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 (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 Company Meeting Paid Parental Leave Sick and Vacation hours 12 Paid Holidays Volunteer hours Salary Range:
$80,000 - $110,000
#J-18808-Ljbffr
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
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) Proven system, database, and data agility; Microsoft Office 365 Suite, Microsoft Dynamics, Datarails, PowerBI, Tableau and/or similar tools Familiarity with SQL and DAX 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 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 (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 Company Meeting Paid Parental Leave Sick and Vacation hours 12 Paid Holidays Volunteer hours Salary Range:
$80,000 - $110,000
#J-18808-Ljbffr