Hybrid Commercial Analytics Analyst

Cialdnb; Ciudad de México; Hybrid; MXN 1,000,000 - 1,400,000; Full time

Benefits offered by this job

Hybrid office / remote work scheme

Competitive compensation package

Job summary

CIAL Dun & Bradstreet in Mexico City is seeking a Commercial Analytics Analyst for our Sales Team. You will generate, review and understand data, KPI´s and Salesforce information to develop new strategies and keep monitoring our forecast and portfolio behavior.

You are analytical, innovative and data driven. You will generate KPI's, present insights to management, review CRM data quality, and build forecasts to support decision making.

Qualifications

• 1+ years of experience in Data/Business analytics.
• Advanced SQL for data extraction and normalization across multiple databases.
• Expert Excel skills for ETL, data transformation and complex business analysis.
• Proficiency in Power BI with DAX or Tableau to automate reporting and data models.
• Ability to build internal applications and low-code tools to automate business workflows.
• Strong UX/UI design skills for creating professional and intuitive business interfaces.
• Experience with CRM systems like Salesforce to analyze sales pipeline and performance.
• Innovative and collaborative mindset with a Bachelor’s degree in related fields.
• English - Advanced.

Responsibilities

• Generate and update KPI's for monitoring commercial activity.
• Present KPI's to the commercial management to review the results of the last actions and trigger new action plans.
• Review and understand the information from our CRM to generate Data Quality actions.
• Based on KPI's, historical and current information, generate business forecasts for decision making.
• Salesforce optimization analysis based on historical results.
• Segmentation of clients and products to generate resource optimization strategies.
• Generate reports that provide Insights on the behavior of the portfolio.

Skills

Advanced SQL

Advanced Excel

UX/UI design

CRM analysis

English proficiency

Education

Bachelor's degree in related fields

Tools

Power BI

Tableau

Low-code platforms

Salesforce

Job description

CIAL Dun & Bradstreet in Mexico City is seeking a Commercial Analytics Analyst for our Sales Team. You will generate, review and understand data, KPI´s and Salesforce information to develop new strategies and keep monitoring our forecast and portfolio behavior.

You are analytical, innovative and data driven. You will generate KPI's, present insights to management, review CRM data quality, and build forecasts to support decision making.