Sales Analytics Intern

AAA1002AWCN; Village of Williamsville (NY); On-site; USD 26,000 - 37,000; Full time

Job summary

AAA1002AWCN in Williamsville, NY is seeking a Data Analyst for Sales Analytics to drive data-informed decisions across CRM, ERP, and BI platforms. You will build dashboards, generate KPI reports, and collaborate with Sales, Marketing, Finance, and Operations. Strong Excel and visualization skills are essential.

This role emphasizes forecasting, strategic insights, and data governance to support growth initiatives and informed decision-making.

Qualifications

• Experience in statistical analysis and forecasting techniques.
• Advanced Excel skills (pivot tables, VLOOKUP, macros).
• Experience with Power BI, Tableau or similar data visualization tools.
• Strong analytical, problem-solving, and communication skills.

Responsibilities

• 40% Sales data analysis and reporting from CRM, ERP, Power BI, and other sources.
• 15% Forecasting & performance modeling for branch/channel planning.
• 15% Strategic insights & recommendations to improve sales processes.
• 10% Cross-functional collaboration with Sales, Marketing, Finance and Operations.
• 10% Campaign & promotion effectiveness analysis.
• 10% Data management & administrative support.

Skills

Data analysis

Forecasting

Problem solving

Communication

Independent work

Tools

Power BI

Excel

Tableau

Job description

Compensation

• Starting Pay Rate: $23 per hour

Benefits

Associates are eligible for a wide selection of benefits (dependent upon position) including:

• Medical Insurance
• Health Spending Account (HSA) with company match
• Paid Time Off
• Pre-Tax & Roth 401(k) plan with company match
• Flexible Scheduling
• Dental and Vision Insurance
• Life and AD&D Insurance
• Tuition reimbursement & company-paid training programs
• FREE AAA membership & travel / product discounts
• Company Paid Short-term & Long-term disability
• Paid Volunteer Time Off
• Flexible Spending Accounts
• Tuition reimbursement & company-paid training programs

Job Responsibilities

• 40% Sales Data Analysis & Reporting: Collect, clean, and analyze sales data from CRM, ERP, Power BI, and other sources. Build and maintain dashboards to track KPIs such as revenue, conversion rates, and pipeline velocity. Generate weekly, monthly, and quarterly reports for sales analytics team.
• 15% Forecasting & Performance Modeling: Assist in developing sales forecasts using historical data and predictive models. Support performance tracking and branch/channel planning. Identify risks and opportunities in sales performance.
• 15% Strategic Insights & Recommendations: Present findings to sales analytics team using clear visualizations and narratives. Recommend strategies to improve sales processes, pricing, and customer targeting. Support strategic initiatives such as mergers & acquisitions or sales productivity improvements.
• 10% Cross-Functional Collaboration: Collaborate with Sales, Marketing, Finance, and Operations to align data and goals. Ensure data integrity across systems and teams. Participate in planning meetings and strategy sessions.
• 10% Campaign & Promotion Effectiveness Analysis: Evaluate the ROI of sales campaigns and promotions. Analyze customer behavior and buying patterns. Recommend adjustments to improve future campaign performance.
• 10% Data Management & Administrative Support: Assist with data entry, data validation, and routine data maintenance activities. Support the preparation of reports, updates to spreadsheets and databases, and other administrative tasks that help ensure the accuracy and accessibility of business information.

Job Specific Requirements

• Familiarity with statistical analysis and forecasting techniques.
• Experiencein Excel, Power BI, Tableau, or other data visualization tools.
• Analytical, problem-solving, and communication skills.
• Ability to work independently and manage multiple priorities in a fast-paced environment.
• Advanced Excel skills (e.g., pivot tables, VLOOKUP, macros).

Physical Requirements

• Ability to perform routine office tasks that includes operating a computer for long periods of time, sitting, filing and communicating on the phone
• Ability to perform all physical functions consistent with travel including sitting in airplanes and driving for long periods of time
• Must be able to lift, carry, push, pull a maximum of 30 lbs

This position does not offer visa sponsorship now or in the future.