Pricing data analyst

Pricing Data AnalystOverviewWe 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 ResponsibilitiesPricing Strategy & AnalysisAnalyze 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 & ReportingExtract, 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 ImprovementDesign 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 ManagementPartner 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 & ExperienceTechnical SkillsEssentialAdvanced SQL experience (complex joins, CTEs, window functions, stored procedures, query optimization).Advanced Python experience for data analysis and automation.PandasNumPyMatplotlib / SeabornData cleansing and transformationAdvanced Microsoft Excel skills:Complex formulasPower QueryPivot TablesData ModellingPower PivotAdvanced VBA development experience:Macro developmentProcess automationUser formsExcel-based analytical toolsDesirablePower BI or TableauStatistical modellingMachine Learning techniquesExperience with cloud data platforms (Azure, AWS, Snowflake)Experience with pricing, revenue management, or commercial analyticsExperience Required3+ 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 ProfileThe 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 StackAdvanced SQLAdvanced Python (Pandas, NumPy)Advanced Excel (Power Query, Power Pivot)Advanced VBA DevelopmentPricing / Commercial Analytics ExperienceData Visualization & Business Storytelling