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

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

Advanced SQL experience (complex joins, CTEs, window functions, stored procedures, query optimization).

Advanced Python experience for data analysis and automation.

NumPy

Matplotlib / Seaborn

Data cleansing and transformation

Advanced Microsoft Excel skills:

Complex formulas

Power Query

Advanced VBA development experience:

Excel-based analytical tools

Power BI or Tableau

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)

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 idóneo 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

Data Visualization & Business Storytelling

#J-18808-Ljbffr

📌 Pricing data analyst (Heroica Puebla de Zaragoza)
🏢 TSSI Recruit US
📍 Heroica Puebla de Zaragoza