Sales Analytics Intern: Data, Forecasts & Insights

Aaa-of-Western-and-Central-Ny; Village of Williamsville (NY); On-site; USD 26,140,000 - 37,230,000; Full time

Benefits offered by this job

Medical Insurance

HSA with company match

Paid Time Off

Pre-Tax & Roth 401(k)

Flexible Scheduling

Dental Insurance

Vision Insurance

Life Insurance

Disability Insurance

Tuition reimbursement & training

Job summary

AAA Corporate in Williamsville, NY is seeking a Sales Data Analyst to collect, clean, and analyze sales data from CRM, ERP, and Power BI. You'll build dashboards tracking KPIs like revenue and pipeline velocity, and generate regular reports for the sales analytics team.

Responsibilities include forecasting, strategic insights, and collaboration with Sales, Marketing, Finance, and Operations to ensure data integrity and informed decision-making.

Qualifications

• Experience with statistical analysis and forecasting.
• Advanced Excel skills (pivot, VLOOKUP, macros).
• Ability to analyze data from multiple sources.

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.
• 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.
• 10% Cross-Functional Collaboration: Collaborate with Sales, Marketing, Finance, and Operations to align data and goals. Ensure data integrity across systems and teams.
• 10% Campaign & Promotion Effectiveness Analysis: Evaluate the ROI of sales campaigns and promotions. Analyze customer behavior and buying patterns.
• 10% Data Management & Administrative Support: Assist with data entry, data validation, and routine data maintenance activities.

Skills

Statistics knowledge

Excel

Power BI

Tableau

Data analysis

Communication

Education

High School or better

Pursuing bachelor's degree in data analysis

Tools

CRM systems

ERP systems

Job description

AAA Corporate in Williamsville, NY is seeking a Sales Data Analyst to collect, clean, and analyze sales data from CRM, ERP, and Power BI. You'll build dashboards tracking KPIs like revenue and pipeline velocity, and generate regular reports for the sales analytics team.

Responsibilities include forecasting, strategic insights, and collaboration with Sales, Marketing, Finance, and Operations to ensure data integrity and informed decision-making.