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 requi