Sales Analyst

Johnson Brothers; Indianapolis (IN); On-site; USD 55,000 - 75,000; Full time

Job summary

Johnson Brothers is seeking a Sales Analyst to support our national beverage distribution team. The role focuses on sales data analysis, tracking, recapping, and reporting to managers and sales teams using Excel, Tableau, and other Office tools.

The candidate will develop sales tools, create monthly presentations, and help plan all aspects of sales meetings in a fast-paced environment. Bachelor’s degree and 3+ years in a relevant field preferred.

Qualifications

• Bachelor’s degree or equivalent industry experience.
• 3+ years in sales/CPG or related field.
• Strong Excel and Microsoft Office proficiency.
• Excellent organizational and communication skills.

Responsibilities

• Provide administrative support to upper management and clerical duties.
• Utilize data systems like Branches, Slicer, IRI, Tableau to identify opportunities.
• Compile sales reports, supplier end-of-month reports, and program recaps.
• Track monthly reports on spreadsheets and build PowerPoint summaries.
• Distribute all reports weekly to managers and prepare supplier meeting materials.
• Assist budgeting and local marketing program tracking.

Skills

Analytical thinking

Excel

Data analysis

Organization

Communication

Independence

Education

Bachelor’s Degree

Tools

Tableau

Slicer

Branches

Microsoft Office

PowerPoint

Job description

Johnson Brothers is a national family-owned wine, spirits, and beer distributor. Johnson Brothers has been providing exceptional service to our customers since 1953, representing the world's most famous brands in the beverage industry.

This position is responsible for sales analysis, tracking, recapping and reporting of sales data and goals for the sales teams and managers. The most successful Sales Analyst will be able to rely on basic instructions and pre-established guidelines to perform the functions of the position. Will develop and create sales tools and presentations each month. Will be responsible for planning all aspects of sales meetings. Can adapt to a changing, fast-paced environment. Must be proficient in Excel as well as other Microsoft Office programs.

Job Description

Job Responsibilities

• Provide administrative support to all upper management by performing general clerical duties.
• Utilize data systems like Branches, Slicer, IRI, Tableau, etc. to identify key targeted channel driven opportunities to drive incremental JB business.
• Compile sales reports, supplier end of month reports and completion of chain programs.
• Track monthly reports on spreadsheets.
• Review, Build and Analyze Go Spot Check Missions and Submissions.
• Build PowerPoint Supplier Recaps.
• Distribute all reports on a weekly basis to all managers.
• Prepare divisional-level information for supplier meetings. Prepare upper management for calls and meetings with key suppliers.
• Assist in the management of LMF funds and banks as it relates to local marketing and brand planning.
• Keep track of all free good programs, budgets, etc. and give weekly updates.
• Oversee and track all monthly, quarterly incentive plans and recap each Sales Manager.
• Daily Sales Updates and Weekly Sales Objectives Updates.

Qualifications

• Work experience in analyst role preferred
• 3+ years CPG experience or related field
• Excellent organizational, planning and project management skills with a strong attention to detail with the ability to effectively manage programs.
• Extensive computer knowledge in all Microsoft programs including Word Processing, spreadsheet capability, PowerPoint and Excel.
• Professional, organized and energetic.
• Ability to work independently.
• Possess initiative and motivation.
• Able to communicate effectively both written and verbal.
• Ability to multi task, work on several initiatives and meet deadlines.
• Programming and Price Structure experience a plus.

Education

• Bachelor’s Degree required (or analogous industry experience / skills)

Worker Sub-Type

Regular

Time Type

Full time