Sales Analytics Intern | Flexible Scheduling & Training

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

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.