Commercial Intelligence Analyst

Jobtailor

São Paulo

Presencial

BRL 90 000 - 150 000

Tempo integral

Há 2 dias

Torna-te num dos primeiros candidatos

Recebe mais respostas dos empregadores

Envia um currículo específico para a oferta em poucos minutos.

Resumo da oferta

Jobtailor in São Paulo, Brazil, is seeking a Commercial Intelligence professional to conduct market analysis, build market share views, and monitor competition. The role involves cross-referencing external audit data with internal sell-in data, preparing recurring commercial books, and ensuring reliable data publication.

You will automate processes, enhance Power BI dashboards, and support forecasting with Marketing, Trade, and Supply.

Qualificações

Bachelor’s degree required.
3+ years in Commercial Intelligence, Commercial BI, Trade Marketing, or Sales Planning—pharmaceutical industry preferred.
Advanced Excel with pivot tables, complex formulas, and Power Query.
BI tools experience (Power BI, Qlik Sense, Tableau).
CRM and sales management systems experience.
Knowledge of segmentation and territory design methodologies.
Strong statistical analysis and data interpretation skills.
SQL for data extraction and database joins.
Experience with SAP as a data source.
Knowledge of Brazilian pharmaceutical retail market and price regulation (CMED/ANVISA).
Python or R for data processing and automation.
Experience with sales force CRM data and SFE indicators.
Power Automate or similar automation tools.

Responsabilidades

Conduct market analysis and assess market share.
Analyze market audit databases and build market share views by value and units, MAT/YTD evolution, and competition by molecule, class, and region.
Monitor competitor activity and flag risks and opportunities.
Cross-reference external audit data with internal sell-in/sell-out data and explain discrepancies.
Prepare recurring commercial books for the Commercial Directorate and regional management.
Ensure published figures are consistent, timely, and reliable.
Track targets, coverage, activation, and territory performance.
Support sectorization, quota setting, and incentive campaigns.
Support forecasting and demand planning with Marketing, Trade, and Supply.
Extract and process data from SAP and other databases, integrating with market data.
Structure and maintain cross-reference mappings between internal coding and market audits.
Automate manual processes and enhance Power BI models and dashboards.

Conhecimentos

Advanced Excel Skills

SQL Skills

Power BI Knowledge

Statistical Analysis

Data Interpretation

Segmentation Methodologies

Territory Design Methodologies

Python or R for data processing

CRM Systems Experience

SFE Indicators

Formação académica

Bachelor’s degree in Business Administration, Economics, Statistics, Engineering, or related fields

Ferramentas

SAP

Power Automate

Qlik Sense

Tableau

Descrição da oferta de emprego

Conduct market analysis and assess market share
Analyze market audit databases (IQVIA and Close-Up), building market share views by value and units, MAT/YTD evolution, performance versus the market, and direct competition by molecule, therapeutic class, and region
Monitor competitor activity—including launches, pricing, and share gains—and proactively flag portfolio risks and opportunities
Cross-reference external audit data with internal sell-in, sell-out, and channel inventory data, explaining discrepancies and supporting an accurate view of actual demand
Prepare and continuously improve recurring commercial books (monthly, cycle-based, and ad hoc) for the Commercial Directorate, regional management, and the sales force, supported by an analytical narrative
Ensure the consistency, timeliness, and reliability of published figures, serving as a reference when indicators are challenged
Track target achievement, coverage, customer activation, representative productivity, and performance by territory/brick
Provide analytical support for sectorization, quota setting, and incentive campaigns
Support the forecasting and demand planning cycle in collaboration with Marketing, Trade, and Supply
Extract and process data from SAP and other internal databases, integrating it with market data
Structure and maintain product, presentation, and competitor cross-reference mappings between internal coding and market audits
Automate manual processes and enhance Power BI models and dashboards, reducing consolidation time and increasing time available for analysis

Requirements

Bachelor’s degree in Business Administration, Economics, Statistics, Engineering, or related fields
At least 3 years of experience in Commercial Intelligence, Commercial BI, Trade Marketing, or Sales Planning—preferably in the pharmaceutical industry
Advanced Excel skills, including pivot tables, complex formulas, and Power Query
Knowledge of BI tools such as Power BI, Qlik Sense, or Tableau
Experience with CRM and sales management systems
Knowledge of segmentation and territory design methodologies
Strong statistical analysis and data interpretation skills
SQL skills for data extraction and database joins
Experience using SAP as a source of commercial data
Knowledge of the Brazilian pharmaceutical retail market, including retail chains, distributors, independent pharmacies, and the role of the point of sale in generic-drug conversion
Familiarity with price regulation (CMED/ANVISA) and its effects on commercial policy
Python or R for data processing and automation
Experience with sales force CRM data and SFE indicators
Power Automate or other routine automation tools

Core Competencies

Demonstrates expertise in market analysis, data interpretation, and commercial intelligence within the pharmaceutical industry, leveraging advanced analytical skills and BI tools to drive strategic decision-making and optimize sales performance.

Highest-signal resume keywords