Sr Commercial Analyst, Pricing & Profitability

Job Summary:

The Sr Commercial Analyst takes full ownership of our proprietary Product Portfolio Optimization and Strategic Pricing Model, and is a critical driver of our commercial strategy. Reporting directly to the Head of Sales Operations, this is a high-impact role for a business-savvy data professional who can translate complex financial models into actionable strategies. This role runs the process and is a key business partner for sales, finance, and leadership, using data-driven insights to enhance profitability across our entire product portfolio. This role has deep understanding of business processes, exceptional communication skills, a strong financial modeling background, and advanced skills in SQL and data visualization.

Duties & Responsibilities:

• Financial Model Management:
  
  
  
  • Own the end-to-end operational lifecycle of the Product Portfolio Optimization and Strategic Pricing Model, which ingests, stages, and cleanses all key financial data to ensure maximum accuracy.
  
  
• Execute the model's core logic, which allocates Operating Cost of Goods Sold (OCOGS) across every Customer x Part combination using over 45 distinct allocation methodologies.
• Proactively identify, diagnose, and report potential bugs, data anomalies, or logical flaws within the model's workflows to ensure the continued integrity of its outputs.
• Manage and maintain the underlying data workflows and file systems, ensuring a robust and efficient data flow from multiple sources.
• Analysis & Strategic Insights:
  
  
  
  • Calculate and validate total COGS, gross profit, and gross margin outputs, performing rigorous QA to ensure business sense and accuracy.
  
  
• Analyze the model's final output-a comprehensive flat file-to identify and quantify key opportunities for strategic pricing adjustments and margin improvement.
• Serve as the primary subject matter expert on profitability analytics, translating complex data into compelling business cases for operational and sales leadership.
• Cross-Functional Collaboration & Communication:
  
  
  
  • Serve as a key analytical partner to Sales Operations, Sales, Information Systems, and FP&A teams, providing data-driven insights to support their diverse objectives.
  
  
• Partner directly with the sales team to communicate and illustrate complex pricing and margin data, equipping them with clear talking points to drive effective sales operations and negotiations.
• Present key findings, strategic recommendations, and financial impacts with confidence and clarity to executive leadership.

Minimum & Preferred Qualifications and Experience:

Minimum Qualifications:

• 5+ years of progressive experience in data analysis, financial planning & analysis (FP&A), sales operations, or a similar business analytics role.
• Exceptional communication and executive presence. Must have a demonstrated ability to distill complex analytical topics into clear, concise, and actionable insights for diverse audiences, from sales representatives to C-level executives.
• Advanced, hands-on proficiency in SQL is mandatory. Must be able to write complex queries to manipulate and integrate data from multiple sources.
• Advanced proficiency in a major data visualization tool (Tableau or Power BI) is required, including data modeling, dashboard development, and performance optimization.
• Demonstrated experience with data processing and financial modeling using tools such as MS Excel and Power Query.
• Prior experience with Alteryx is a strong plus, but not required.
• Strong understanding of core business processes, pricing dynamics, and contract negotiation.

Education:

• BS degree in Business, Information Systems, Accounting, Finance, or a related quantitative field is required.
• MBA is highly preferred.

Compensation: The anticipated range for this position is $85,000 - $100,000. Actual placement within the range is dependent on multiple factors, including but not limited to skills, education, and experience. This position also qualifies for up to 10% annual bonus based on Company, department, and individual performance.

This position primarily works in an office environment. It requires frequent sitting, standing and walking. Daily use of a computer and other computing, digital devices, and use of visual display terminals is required. May stand for extended periods when facilitating meetings or walking in the facilities. 10-20% travel required.

The physical demands of the position described herein are essential functions of the job and employees must be able to successfully perform these tasks for extended periods. Reasonable accommodations may be made for those individuals with real or perceived disabilities to perform the essential functions of the job described.