Sales Administration & Business Analyst

Fedway Associates, Inc.; Basking Ridge (NJ); On-site; USD 65,000 - 90,000; Full time

Job summary

Fedway Associates, Inc. in New Jersey seeks a Sales Administration & Business Analyst to support the sales organization with accurate reporting, data analysis, supplier program administration, and day-to-day operational support.

The role focuses on improving sales reporting accuracy, handling large data sets, creating dashboards, and translating insights for management, while supporting supplier programs and sales initiatives.

Qualifications

• 3–5 years in sales administration, business analysis, or sales operations.
• Experience in wine & spirits or beverage distribution preferred.
• Strong Microsoft Office suite including Excel, Power BI, and PowerPoint.
• Experience creating dashboards, charts, and reporting.
• Ability to analyze large datasets with high accuracy.
• Excellent organizational and time-management skills.

Responsibilities

• Prepare and maintain weekly, monthly, quarterly, and annual sales market share reports.
• Analyze sales performance by supplier, brand, SKU, account, salesperson, team, territory, and channel.
• Compare current performance to prior-year results, exclusive vs non-exclusive business, goals, and targets.
• Assist with administration and tracking of supplier programs, incentives, goals, and Platinum Club.
• Review reports for accuracy, investigate discrepancies prior to distribution, and coordinate with internal teams to resolve issues.
• Maintain standardized reporting formats and track KPIs, providing concise summaries of important findings.
• Develop Excel-based dashboards, scorecards, trackers, and management summaries.
• Assist sales leadership with ad hoc analysis and reporting requests.

Skills

Experience in sales administration

Data analysis

Reporting

Dashboard creation

Power BI

Excel

PowerPoint

PivotTables

XLOOKUP

VLOOKUP

Tools

Power BI

Excel

PowerPoint

PivotTables

XLOOKUP

VLOOKUP

Job description

Fedway is New Jersey's premier distributor of wine and spirits, serving over 7,000 restaurants, clubs, taverns, and retail stores throughout the state. We offer a diverse range of products that span every category of the beverage alcohol industry and proudly represent some of the world's leading distillers, wineries, and importers. Our dedicated team of managers, sales agents, and customer service representatives is committed to putting our customers first. Fedway Associates is seeking a Sales Administration & Business Analyst to join the team.

Position Summary:

The Sales Administration & Business Analyst supports the sales organization through accurate reporting, data analysis, supplier program administration, and day-to-day operational support. This position serves as a key link between sales leadership, sales teams, supplier partners, and internal departments by ensuring information is accurate, timely, organized, and actionable.

A primary focus of this role is improving the accuracy and consistency of sales reporting. The successful candidate will be comfortable working with large amounts of sales data, identifying discrepancies and trends, building reports, and translating information into clear insights for management.

The position also supports supplier programs, sales initiatives, presentations, meetings, and other administrative functions necessary to keep the sales organization operating efficiently.

Role & Responsibilities:

• Prepare and maintain weekly, monthly, quarterly, and annual sales market share reports.
• Analyze sales performance by supplier, brand, SKU, account, salesperson, team, territory, and channel.
• Compare current performance to prior-year results, exclusive versus non-exclusive business, goals, and established sales targets.
• Assist with the administration and tracking of supplier programs, incentives, goals, and sales initiatives and Platinum Club.
• Review reports for accuracy, investigate discrepancies prior to distribution, and partner with internal departments to validate data and resolve reporting issues.
• Maintain standardized reporting formats and track key performance indicators (KPIs), providing concise summaries of important findings.
• Develop Excel-based dashboards, scorecards, trackers, and management summaries.
• Assist sales leadership with ad hoc analysis and reporting requests.

Qualifications:

• 3–5 years of experience in sales administration, business analysis, sales operations, reporting, or a related position preferred.
• Experience in wine & spirits, beverage distribution, consumer packaged goods, hospitality, or a related industry is strongly preferred.
• Strong Microsoft Office, PowerPont, Power BI and Excel skills, including PivotTables, XLOOKUP/VLOOKUP, formulas, filters, conditional formatting, and data organization.
• Experience creating dashboards, charts, and reporting.
• Ability to analyze large amounts of information while maintaining a high degree of accuracy.
• Strong organizational and time-management skills with excellent attention to detail.•?