Business Intelligence Analyst

Palm Bay International; New York (NY); Híbrido; USD 85 000 - 125 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Medical

Dental

Vision

Life Insurance

401(k)

Paid vacation

Personal time off

11 paid company holidays

Resumo da oferta

Palm Bay International, a leading importer of wines and spirits, is seeking a Business Intelligence Analyst in NYC. You will support data strategy, build capabilities, and craft executive summaries to align cross‑department goals and drive profitability.

Responsibilities include reporting, KPI dashboards, and analysis of sales data across internal and syndicated sources to inform brand and sales strategies. A 5+ year background in alcohol analytics and strong Excel/PowerBI skills are required.

Qualificações

• Bachelor's degree required.
• Minimum 5 years as sales analyst or category insights in alcohol/beverage.
• VIP, IDig, Karma and Circana experience preferred.
• Excel expert in data management, reporting and analysis.
• Experience with PowerBI, PowerQuery, Excel VBA and relational databases a plus.
• Ability to derive insights from syndicated data and communicate them clearly.
• Strong written and verbal communication, organization, and multi-tasking.

Responsabilidades

• Administer reports, goals, and account management across sales systems.
• Work with Circana data to generate insights for brand and sales teams.
• Create KPI scorecards by category and brand using internal and syndicated data.
• Analyze shipments, depletion, sell-through, and inventory positions.
• Report on display penetration and ad execution with distributor data.
• Drive shelf-set standards in collaboration with brand teams.
• Provide insights and tools to business groups and departments.
• Support budget and forecast processes including long-range planning.
• Consolidate reports from internal and external sources for brand alignment.

Conhecimentos

Excel

PowerBI

PowerQuery

Excel VBA

Data analysis

Data visualization

Syndicated data

Communication

Formação académica

Bachelor's degree

Ferramentas

Circana

VIP

IDig

Karma

Relational databases

PowerBI

Descrição da oferta de emprego

Location: NYC office (4-day Hybrid, M-Th)

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.

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.

Responsibilities/Essential Functions:

• 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.

Qualifications/Requirements:

• Bachelor’s Degree required.
• Minimum of 5 years professional sales analyst and/or category insights experience in the alcohol beverage experience preferred.
• Candidates with experience using of VIP, IDig, Karma and Circana preferred.
• Expert in Excel with regards to Data Management, Reporting, and Data Analysis.
• Experience with PowerBI, PowerQuery, Excel VBA and relational databases is a plus.
• 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.

Benefits Overview:

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.