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 ma

📌 Commercial Business Intelligence Analyst (Bogotá, D.C.)
🏢 Inovot
📍 Bogotá, D.C.