Location

Guadalajara, MX — Hybrid (1 day onsite per week)

Role Overview

We are seeking a Data Analyst with strong experience in Excel, data analysis, data modeling, forecasting, and business reporting to support Sales Operations and commercial business functions. The idóneo candidate will be responsible for analyzing business data, identifying trends and patterns, developing analytical models, and providing data-driven insights to support business decisions.

Key Responsibilities

- Analyze large and complex datasets to identify trends, patterns, correlations, anomalies, and business opportunities .
- Develop and maintain Excel-based analytical models, reports, dashboards, and forecasting tools .
- Perform data cleansing, validation, transformation, and reconciliation to ensure data accuracy.
- Use advanced Excel functions including XLOOKUP/VLOOKUP, INDEX-MATCH, SUMIFS/COUNTIFS, PivotTables, Power Query, and advanced formulas .
- Build data models to analyze sales, pricing, revenue, discounts, pipeline, and operational performance.
- Perform trend analysis and forecasting using historical data to support business planning and decision-making.
- Develop predictive analyses to identify potential outcomes based on historical business patterns.
- Analyze sales and commercial data to identify performance gaps, risks, and improvement opportunities.
- Create recurring and ad-hoc reports for business stakeholders.
- Translate business requirements into analytical queries, reports, dashboards, and actionable insights.
- Validate data across multiple sources and investigate discrepancies or unexpected results.
- Work with Salesforce,



Vector, Google Sheets, and other business systems to extract and analyze data.
- Present analytical findings to business stakeholders in a clear and understandable manner.
- Support KPI development, performance measurement, and operational reporting.

Data Analysis & Modeling Skills

- Strong understanding of data analysis concepts and methodologies .
- Experience creating data models and analytical models using Excel or other analytics tools.
- Ability to work with structured and semi-structured datasets.
- Understanding of descriptive, diagnostic, and predictive analytics .
- Experience with forecasting, trend analysis, variance analysis, and what-if analysis .
- Ability to identify relationships between different business variables and interpret analytical results.
- Strong understanding of data quality, validation, and reconciliation.

Required Qualifications

- 2–4 years of experience in Data Analytics, Business Analytics, Sales Operations Analytics, Commercial Analytics, or a related field.
- Advanced Microsoft Excel skills with hands-on experience in data analysis and modeling.
- Strong knowledge of data visualization, reporting, and dashboard development .
- Experience working with large datasets and performing data cleaning and transformation.
- Understanding of basic statistical concepts, forecasting, and predictive analysis .
- Experience with CRM or business systems such as Salesforce .
- Strong analytical and problem-solving skills.
- Excellent communication skills with the ability to explain data-driven findings to non-technical stakeholders.

📌 Data Analyst – Sales Operations (Guadalajara)
🏢 XChange Software
📍 Guadalajara