Pricing data analyst

Pricing Data Analyst

Overview

We are seeking a highly analytical Pricing Data Analyst to support pricing strategy, commercial decision-making, and revenue optimization through data-driven insights. The successful candidate will have advanced expertise in SQL, Python, VBA, and Excel , with a proven ability to analyze large datasets, automate reporting, develop pricing models, and influence business performance.

This role will work closely with Commercial, Finance, Sales, Product, and Leadership teams to identify opportunities for margin improvement, pricing optimization, and operational efficiency.

Key Responsibilities

Pricing Strategy & Analysis

• Analyze pricing performance, profitability, customer behavior, and market trends.
• Develop and maintain pricing models to optimize revenue, margin, and customer retention.
• Evaluate pricing changes, promotions, discounts, and commercial initiatives.
• Conduct competitor and market pricing analysis.
• Provide recommendations on pricing strategy based on quantitative analysis.

Data Analysis & Reporting

• Extract, transform, and analyze large datasets using SQL .
• Build automated reporting solutions and dashboards to track pricing KPIs.
• Identify patterns, trends, and business opportunities through advanced analytics.
• Develop forecasting models to support pricing and revenue planning.

Automation & Process Improvement

• Design and maintain Excel VBA solutions to automate repetitive commercial and reporting processes.
• Use Python to build data pipelines, automate reporting, and perform advanced statistical analysis.
• Improve data quality, reporting efficiency, and business intelligence capabilities.
• Create scalable analytical tools that enable self-service reporting.

Stakeholder Management

• Partner with Sales, Commercial, Finance, and Operations teams to understand business requirements.
• Translate complex analytical findings into actionable business recommendations.
• Present insights and pricing performance reports to senior stakeholders.
• Support strategic initiatives and ad-hoc commercial analysis requests.

Required Skills & Experience

Technical Skills

Essential

• Advanced SQL experience (complex joins, CTEs, window functions, stored procedures, query optimization).
• Advanced Python experience for data analysis and automation.
• Pandas
• NumPy
• Matplotlib / Seaborn
• Data cleansing and transformation
• Advanced Microsoft Excel skills:
• Complex formulas
• Power Query
• Pivot Tables
• Data Modelling
• Power Pivot
• Advanced VBA development experience:
• Macro development
• Process automation
• User forms
• Excel-based analytical tools

Desirable

• Power BI or Tableau
• Statistical modelling
• Machine Learning techniques
• Experience with cloud data platforms (Azure, AWS, Snowflake)
• Experience with pricing, revenue management, or commercial analytics

Experience Required

• 3+ years' experience in Pricing Analytics, Commercial Analytics, Revenue Management, Business Intelligence, or Data Analytics.
• Experience working with large and complex datasets.
• Strong background in pricing strategy, profitability analysis, revenue optimization, or commercial performance analysis.
• Demonstrated success automating reporting and analytical processes using SQL, Python, VBA, and Excel.

Key Performance Indicators (KPIs)

• Margin improvement initiatives delivered.
• Pricing optimization opportunities identified and implemented.
• Reporting automation and efficiency gains.
• Forecast accuracy.
• Quality and timeliness of analytical insights.
• Stakeholder satisfaction and business impact.

Ideal Candidate Profile

The ideal candidate combines strong commercial acumen with exceptional technical capability. They will be equally comfortable discussing pricing strategy with senior leadership as they are writing complex SQL queries, developing Python automation scripts, or building advanced VBA solutions in Excel.

Must-Have Technology Stack

Advanced SQL

Advanced Python (Pandas, NumPy)

Advanced Excel (Power Query, Power Pivot)

Advanced VBA Development

Pricing / Commercial Analytics Experience

Data Visualization & Business Storytelling