Pricing data analyst

TSSI Recruit US; Estado de México; On-site; MXN 1,292,000 - 2,031,000; Full time

Job summary

Pricing Data Analyst role at TSSI Recruit US in Mexico City offers the chance to shape pricing strategy through rigorous data analysis. You will use SQL, Python, VBA and Excel to build models, automate reports, and influence commercial decisions across Finance, Sales, Product and Leadership.

The ideal candidate has 3+ years in pricing analytics, handles large datasets, and creates self-service dashboards in Power BI or Tableau.

Qualifications

• 3+ years' experience in Pricing Analytics, Commercial Analytics, Revenue Management, BI, 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.

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.
• 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.
• 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.

Skills

SQL

Python

Excel

VBA

Power BI

NumPy

Matplotlib/Seaborn

Data cleansing

Power Query

Power Pivot

Snowflake

Azure

AWS

Machine Learning techniques

Tools

Snowflake

Azure

AWS

Power Query

Power Pivot

Job description

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 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
• Data Visualization & Business Storytelling