Business Intelligence Analyst

Palm Bay International • New York, NY

16h • Hybrid

About The Position

Palm Bay International, a dynamic family-owned company, offers one of the nation’s most comprehensive portfolios of imported wines and spirits, including over 50 suppliers from around the globe. Among Palm Bay’s most valued assets is its remarkable network of long-term partnerships with the foremost wholesale companies in all 50 states, as well as the Caribbean, Mexico, and Central America. With the crucial collaboration of these partners, Palm Bay’s portfolio meets the needs of every level of the industry, from independent restaurants and retail stores, to chain accounts, supermarkets, hotels, airlines, cruise ships, duty-free accounts and U.S. military bases. This impressive roster of brands, accounts, and relationships positions Palm Bay as a major source of fine wines and spirits and an industry leader in the U.S. marketplace. For more visit: www.palmbay.com . Location: NYC office (4-day Hybrid, M-Th) Position Overview: The Business Intelligence Analyst will support data strategy, build capabilities, and uncover insights to enhance brand performance. This role will provide analytical support and craft executive level summaries to ensure cross-departmental alignment and help drive category management strategies to assist with achieving company profitability goals.

Requirements

• Bachelor’s Degree required.
• Minimum of 5 years professional sales analyst and/or category insights experience in the alcohol beverage experience preferred.
• Expert in Excel with regards to Data Management, Reporting, and Data Analysis.
• Ability to read, interpret and garner insights using syndicated data.
• Strong communication, both written and verbal.
• Superior organizational skills, detail oriented, must be able to manage multiple priorities and meet deadlines.
• Demonstrates initiative, flexibility, teamwork, maturity under pressure, and anticipates and resolves problems.
• Self-starter, passion to challenge the status quo, curiosity, desire, and ability to think beyond surface level, dive deeper into financials and strategic thinking.

Nice To Haves

• Candidates with experience using of VIP, IDig, Karma and Circana preferred
• Experience with PowerBI, PowerQuery, Excel VBA and relational databases is a plus.

Responsibilities

• Administer sales systems including creating, running, and streamlining reports, creating and/or cascading goals, and account management.
• Work with VIP and syndicated data platforms (Circana) to generate data and business insights supporting brand and sales teams as well as supplier partners.
• Create and manage KPI scorecards by category and brand utilizing a combination of internal sales data along with syndicated data sources.
• Analyze sales data at all points within the 3-tier system, including shipments, depletions, sell-through data, and inventory positions.
• Utilize Chain specific proprietary systems and tools inclusive of our distributor partners to report and evaluate display penetration and ad execution.
• Examine and drive shelf-set standards through brand team direction and collaboration.
• Provide insights, analysis, recommendations, and tools to business groups and other departments.
• Conduct distribution gap analysis to ensure customer/item efficiency.
• Proactively evaluate existing strategies, track key deliverables, and recommend changes when appropriate.
• Work directly with Brand and Sales Leadership on the management and execution of strategic initiatives and new concepts to enhance state, brand, and category performance and profitability.
• Consolidate and distribute reports from internal and external sources ensuring data integrity and ease of use, aligning brands with suppliers.
• Assist in Budget and Forecast process – including long range planning and analysis.
• Perform maintenance of data dimensions and routine updating of tracking tools to promote accuracy and accountability.
• Develop ideas within a team environment regarding data organization and sales reporting.
• Additional related duties may be assigned, as required.

Benefits

• Palm Bay offers a competitive compensation package including medical, dental, vision, life insurance, 401(K), paid vacation, personal time off and 11 paid company holidays.
• Palm Bay International is an equal opportunity employer.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level