Note: The job is a remote job and is open to candidates in USA. Stratus is a market leader in brand implementation and maintenance, helping recognized brands maintain consistency in their operations. The Commercial Analyst will drive the success of the sales department through analytical skills, focusing on sales data integrity, pricing strategy, and competitive analysis to enhance decision-making and support sales performance.
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
- Perform root-cause analyses to address sales challenges, including deep-dive win/loss analyses at the segment level to identify root causes of lost opportunities and inform pricing strategy
- Present data-driven insights with clarity, tailoring communication to varying audiences, from sales representatives to executive leaders
- Seek innovative tools and methodologies to enhance analysis and reporting accuracy
- 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
- Regularly monitor and analyze pipeline data to ensure visibility into deal stages, potential revenue, and risks
- Support sales forecasting by refining models and collaborating with sales leadership to ensure alignment with business objectives
- 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, monitoring 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
- Actively contribute to the transition to advanced reporting and analytics platforms, ensuring a seamless adoption for the sales department
- 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
Skills
- Minimum of 4 years in a data/analytics role, preferably with a focus on sales, pricing, or business operations
- Experience with sales reporting, ideally using Salesforce
- Expertise in reporting tools like Power BI or Tableau
- Advanced proficiency in Microsoft Excel; familiarity with Word and PowerPoint
- Strong verbal and written communication skills, with the ability to translate technical details into actionable insights
- 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
- Analytical and problem-solving mindset with a proactive approach to challenges
- Degree in business, finance, computer/data science, information systems, statistics, analytics, or a related field is preferred
- 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
- Financial acumen and experience with revenue forecasting or sales budgeting preferred
Benefits
- Supportive & Friendly Culture
- Medical, Dental, Vision coverage options
- Flexible Spending & Health Savings Accounts
- Company-paid Life Insurance
- 401k with Employer Contribution
- Company-paid Short/Long Term Disability
- 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.
Company Overview