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

Why work with us?

CIAL Dun & Bradstreet is the leading commercial data and counterparty decisioning solutions provider across 43 countries in Latin America and the Caribbean.

As the exclusive Latin American partner of the Dun & Bradstreet Worldwide Network, we serve 20,000+ customers with insights on 600M+ companies globally, combining the power of a world-class data network with deep local expertise built over decades in the region.

Our solutions help organizations make smarter faster decisions around credit risk, supply chain risk, compliance risk, to build stronger business relationships.

The role:

We are seeking for a Commercial Analytics Analyst for our Sales Team. He or she will be responsible to generate, review and understand data, KPI´s and Salesforce information to develop new strategies and keep monitoring our forecast and portfolio behavior. He or she is analytical, innovative and data driven.

What you will do:

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

What we are looking for:

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

What we offer:

• Positive and encouraging work environment.
• Dynamic company where you can grow as far as your vision and curiosity leads you.
• Competitive compensation and benefits package.
• Hybrid office / remote work scheme.

CIAL provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. This applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, and transfer, leaves of absence, compensation, and training.