Commercial Analyst

About the role

The Commercial Analyst plays a critical role in driving the success of the sales department by leveraging analytical skills and techniques to create actionable insights, maintain sales data integrity, and develop reports that inform decision-making.

Responsibilities

• Develop and maintain sales dashboards and reports that provide actionable insights into pipeline health, deal progress, win rates, and key performance metrics in spreadsheets, dashboarding solutions, and within Salesforce.
• Ensure accuracy and consistency of sales reports, including pipeline data, revenue forecasting, and performance tracking, incorporating pricing KPIs and margin analysis.
• Communicate updates or changes in reporting processes and metrics to stakeholders effectively to ensure alignment and proper usage.
• Collaborate with the sales team to identify and refine data points critical for decision-making and strategic planning.
• Conduct in-depth analyses to uncover sales trends, opportunities, and risks, providing recommendations to sales leadership.
• Present data-driven insights with clarity, tailoring communication to varying audiences, from sales representatives to executive leaders.
• Analyze segment win rates, document competitive bid data provided by customers or field teams, and build reporting that enables teams to understand competitive positioning and optimize pricing.
• Support regular monitoring and analysis of pipeline data to ensure visibility into deal stages, potential revenue, and risks.
• Assist in defining and maintaining routine reporting processes for KPIs and SLAs to tracking key metrics that drive sales efficiency including metrics around win rate, conversion rate, activity volume, quota attainment, and pipeline coverage/aging.
• Own raw material and labor cost pricing models, monitor external indices (e.g., Bureau of Labor Statistics) to track cost changes and adjust internal pricing benchmarks accordingly.
• Develop and maintain surcharge frameworks for commodities such as fuel, adjusting pricing in response to market fluctuations and cost events.
• Build and maintain segment-level pricing models, analyzing price elasticity by division, product type, and customer group to understand the impact of pricing decisions on win rates.
• Build reporting on competitive bid data — cataloging data shared by competitors or customers in lost bid scenarios — and develop prescriptive insights to help sales teams apply optimized pricing.
• Analyze actual vs. estimated cost vs. price-to-customer to identify margin opportunities, surfacing cases where pricing adjustments could improve win rates without sacrificing profitability.
• Develop geographic pricing tools that account for regional variation in raw material and labor costs, enabling sales personnel to accurately price multi-site national work and clearly communicate cost drivers to customers.
• Produce prescriptive, detailed pricing outputs that empower sales personnel to explain complex pricing structures in a straightforward and compelling way.
• Partner with sales teams to understand data requirements and ensure alignment with business objectives.
• Work alongside other analytics team members to ensure best practices in data handling, reporting, and analysis.
• Support IT and data governance teams in ensuring the accuracy and availability of sales-related data.
• Confidently present findings and recommendations to C-suite leaders and other stakeholders, maintaining clear communication with direct supervisors.
• Act as sales and pricing subject matter expert in enterprise projects and projects in adjacent departments (marketing, customer success, pricing etc.).
• Identify inefficiencies in sales reporting or data processes and recommend improvements.
• Participate as a subject matter expert in sales-related IT projects, including CRM upgrades, ERP integrations, and data architecture improvements.
• Evaluate and implement new tools to improve the visibility, functionality, and usability of sales data and insights.

Qualifications

• Minimum of 4 years in a data/analytics role, preferably with a focus on sales, pricing, or business operations.
• Expertise in reporting tools like Power BI or Tableau.
• Advanced proficiency in Microsoft Excel; familiarity with Word and PowerPoint.
• Knowledge of Python and SQL (or similar tools) preferred but not required.
• Familiarity with pricing concepts: cost-plus pricing, price elasticity, competitive benchmarking, and geographic market pricing preferred.
• Experience working with external cost indices (e.g., BLS labor data, commodity pricing feeds) a plus.
• Strong verbal and written communication skills, with the ability to translate technical details into actionable insights.
• Financial acumen and experience with revenue forecasting or sales budgeting preferred.
• Comfort working with cost and margin data; ability to communicate pricing logic to non-financial stakeholders.
• Proven ability to collaborate effectively with teams at all levels of the organization.
• An analytical and problem-solving mindset with a proactive approach to challenges.

What We Offer

• Supportive & Friendly Culture
• Medical, Dental, Vision coverage options
• Flexible Spending & Health Savings Accounts
• Company-paid Life Insurance
• 401k with Employer Contribution
• Generous Paid Time Off Program + Holidays
• Career Growth Opportunities and Career Mapping
• Additional perks include Pet Insurance, Employee Assistance Program, Educational Assistance Program, Identity Theft Protection, Critical Illness Plans, Commuter Benefits, and employee discount offerings.

Pay

$80,000 - $100,000 annually

This range reflects the anticipated compensation for this role at the time of posting. Actual pay may vary based on factors such as job-related skills, experience, education, location, and business needs.

Travel Requirements

This position is required to travel as an essential function of this role due to the need for in-person interaction with customers, field partners, and/or business stakeholders. Travel may include local, regional, or national destinations and may be conducted via automobile, air, or other modes of transportation.

Work Environment

The position involves extended computer use and virtual communication, with minimal physical requirements which may include light lifting and movement in an office setting.

Pre-Employment Requirements

All offers of employment with Stratus are contingent upon the successful completion of a background check, in accordance with applicable laws.