Sales Analytics & Forecasting Analyst

Orange EV; Garden City (KS); On-site; USD 70,000 - 100,000; Full time

Job summary

Orange EV is seeking a Sales Operations Analyst to transform Salesforce CRM data into actionable analytics that drive revenue. You will own forecasts, pipeline visibility, and stage analytics for the commercial team, partnering with sales leadership to surface risk, opportunities, and smarter decisions at every funnel stage.

The role requires building KPI dashboards, analyzing win/loss patterns, and delivering executive-ready reports.

Qualifications

• 3-5+ years of experience in a sales operations, revenue operations, or sales analytics role
• Hands-on Salesforce experience in a reporting and analytics capacity
• Demonstrated ability to build and maintain pipeline, forecast, and territory reports
• Advanced Microsoft Excel skills including pivot tables, Power Query, data modeling, and complex formulas
• Strong analytical thinking with the ability to translate data into a clear narrative
• Experience supporting a quota-carrying sales team in a B2B environment
• Clear, confident written and verbal communication skills

Responsibilities

• Own weekly forecast reporting from Salesforce, including commit, best case, and pipeline views by rep, region, and vertical
• Analyze pipeline coverage ratios relative to quota and flag coverage gaps for leadership review
• Track forecast accuracy over time and identify patterns in rep-level sandbagging or overcommitting
• Maintain and refine opportunity scoring to improve forecast reliability
• Build and maintain rolling pipeline trend reports to give leadership early warning of funnel deterioration
• Conduct ongoing analysis of stage-to-stage conversion rates to identify drop-off points and bottlenecks
• Track average sales cycle length by product, segment, vertical, and rep to surface meaningful variance
• Alert sales leadership to stalled deals and aging opportunities before they become at-risk
• Analyze win/loss patterns and tie outcomes to identifiable deal characteristics
• Build and maintain territory coverage dashboards that show activity, pipeline, and closed revenue by geographic region and assigned rep
• Report on quota attainment progress and identify reps or territories trending behind plan
• Support territory planning and realignment exercises with data-backed recommendations
• Track penetration rates within key verticals and customer segments
• Monitor rep-level activity metrics in Salesforce including calls, meetings, demos, and proposal submissions
• Analyze the relationship between activity inputs and pipeline outcomes to identify high-leverage behaviors
• Build leaderboard and performance scorecards for weekly and monthly sales reviews
• Support quota-setting and capacity planning processes with historical performance data
• Own Salesforce data hygiene standards for the commercial team, including required fields, stage definitions, and opportunity documentation
• Identify and correct data entry gaps that compromise reporting accuracy
• Partner with Sales Operations Manager and IT on Salesforce configuration and reporting enhancements
• Develop and maintain documentation for Salesforce reporting standards and definitions
• Prepare weekly, monthly, and quarterly sales performance packages for leadership review
• Build and maintain Salesforce dashboards for executive visibility into revenue KPIs
• Respond to ad hoc analytical requests from VP of Sales, Revenue Operations, and leadership team
• Present findings clearly, with recommended actions, not just data

Skills

Sales analytics

Forecasting

Data storytelling

Stakeholder communication

Tools

Salesforce

Power BI

Power Query

Python (pandas/NumPy)

Job description

Orange EV is seeking a Sales Operations Analyst to transform Salesforce CRM data into actionable analytics that drive revenue. You will own forecasts, pipeline visibility, and stage analytics for the commercial team, partnering with sales leadership to surface risk, opportunities, and smarter decisions at every funnel stage.

The role requires building KPI dashboards, analyzing win/loss patterns, and delivering executive-ready reports.