Commercial Business Intelligence Analyst (Power BI & Data Automation)

Inovot

Bogotá ciudad

On-site

COP 44,640,000 - 55,800,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Inovot is seeking a Commercial Business Intelligence Analyst to turn complex pharmaceutical data into actionable insights through Power BI dashboards and robust data automation. You will work closely with commercial and sales teams to translate requirements into clear analyses and recommendations, including presenting findings in English when needed.

The role emphasizes strong technical craft (Power BI, Excel, Python) combined with business sense, storytelling, and ongoing process improvements

Qualifications

  • 3+ years in BI/Analytics focused on commercial data (sales KPIs, forecasting).
  • Proficient with Power BI data modeling and DAX for time intelligence.
  • Strong Excel (Power Query) and Python for data automation; SQL & multiple source integration.

Responsibilities

  • Design and maintain Power BI dashboards focused on actionable insights.
  • Build and optimize robust data models.
  • Automate data flows using Python and Power Query.
  • Analyze commercial data to identify trends and opportunities.
  • Support sales teams with analysis that drives results and present findings to non-technical stakeholders.
  • Contribute to client meetings and communications in English when required.
  • Propose improvements to reporting processes and document best practices.

Skills

Power BI
Data Modeling
DAX
Python
Excel
SQL
ERP/CRM integration
Communication

Tools

Power BI
Excel
Python
SQL

Job description

Commercial Business Intelligence Analyst (Power BI & Data Automation)

You'll work directly with one of our clients in the pharmaceutical industry.

Partner with a pharma client's commercial and sales teams to turn complex data into better decisions. You won't just build the dashboard - you'll sit down with the team, walk them through it, and help them act on it. The role blends real business sense and clear communication with strong technical craft (Power BI, advanced Excel, Python).

What you'll do
  • Design and maintain Power BI dashboards focused on actionable insights.
  • Build and optimize robust data models.
  • Automate data flows using Python and Power Query.
  • Analyze commercial data to identify trends and opportunities.
  • Work directly with commercial and sales teams to understand their needs and support them with analysis that drives results.
  • Present findings and recommendations to non-technical stakeholders, translating data into clear, concrete actions.
  • Take part in meetings and communications with clients in English when required.
  • Propose improvements to reporting and analysis processes, and document best practices and business logic.
What we're looking for
  • At least 3 years in Business Intelligence, Data Analytics, or similar roles, working with commercial data (sales / sell-in / sell-out, performance, KPIs, forecasting, revenue, sales force).
  • Advanced Power BI: data modeling, advanced DAX (filter context, CALCULATE, time intelligence), decision-oriented dashboards, and basic performance optimization.
  • Advanced Excel (Power Query, data transformation/cleaning, pivot tables) and Python (process automation, pandas/numpy, simple ETL); SQL and integrating multiple sources (ERP, CRM, flat files, APIs).
  • Experience working closely with commercial and sales teams — understanding their goals, dynamics, and day-to-day.
  • Excellent communication: presenting findings and translating data into clear, concrete actions for non-technical audiences (sales managers, reps, executives).
  • Data storytelling and active listening — turning business needs into concrete data questions, and coaching teams to make decisions with the dashboards.
  • Advanced English (required), spoken and written. Hands-on, analytical, self-driven, with attention to detail and a continuous-improvement mindset.
Nice to have
  • Experience integrating multiple data sources (ERP, CRM, flat files, APIs).
  • Experience partnering closely with sales teams in the pharmaceutical industry.
  • Data storytelling and a strong eye for dashboard design.
What we offer

Monthly salary between COP 4,000,000 and 5,000,000, depending on profile.

Permanent (indefinite-term) contract.

Challenging projects with corporate clients.

Technical, agile, results-oriented environment.

Access to company-paid courses.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Strategic BI Analyst - Power BI & Data Automation
Strategic BI Analyst - Power BI & Data Automation

Inovot • Bogotá ciudad

On-site
COP 44,640,000 - 55,800,000
BI Analyst
BI Analyst

Turia GBS • Medellín

Hybrid
COP 107,770,233 - 179,617,056
Hybrid work model: up to 2 days working from home
Half day off on your birthday
Paid day off on your graduation day
+4
Data Analyst (Client Operations)
Data Analyst (Client Operations)

Publicis Groupe • Bogotá

Hybrid
COP 48,000,000 - 72,000,000
Data Analyst
Data Analyst

Lean Solutions Group • Bogotá

On-site
COP 33,480,000 - 50,220,000
Data Analyst (Client Operations)
Data Analyst (Client Operations)

Publicis Groupe • Bogotá

Hybrid
COP 66,960,000 - 100,440,000
Senior Power Bi Id90559
Senior Power Bi Id90559

AgileEngine, LLC. • Bogotá

Hybrid
COP 194,389,000 - 291,583,000
Professional growth
Competitive compensation (USD)
Exciting projects
+1
Senior BI Commercial Director Colombia
Senior BI Commercial Director Colombia

MRINetwork • Colombia

On-site
COP 180,000,000 - 260,000,000
Power BI Developer
Power BI Developer

Immiland Canada Inc. • Bogotá

On-site
COP 143,348,624 - 215,022,936
Senior Power Bi Id90559
Senior Power Bi Id90559

AgileEngine, LLC. • Capital

Hybrid
COP 291,583,000 - 421,175,000
Professional growth
Competitive compensation
Exciting projects
+1
Business Intelligence Reporting Lead
Business Intelligence Reporting Lead

Emma of Torre.ai • Bogotá

On-site
COP 145,985,946 - 166,841,082
Generous vacation days
Flexible work arrangements
Latest tech tools
+4