All open roles
We're hiring
Commercial Business Intelligence Analyst (Power BI & Data Automation)
You'll work directly with one of our clients in the pharmaceutical industry.
Bogotá, Colombia · HybridFull-time · PermanentCOP 4–5M / monthAdvanced English
About the role
Build the dashboards and data automations that help a pharma client's commercial teams make better decisions. You'll model complex commercial data in Power BI, automate flows with Python and Power Query, and sit with sales teams to turn insights into action — not just build the dashboard, but help them use it.
What you'll do
- 01Design and maintain Power BI dashboards focused on actionable insights.
- 02Build and optimize robust data models.
- 03Automate data flows using Python and Power Query.
- 04Analyze commercial data to identify trends and opportunities.
- 05Work directly with commercial and sales teams to understand their needs and support them with analysis that drives results.
- 06Present findings and recommendations to non-technical stakeholders, translating data into clear, concrete actions.
- 07Take part in meetings and communications with clients in English when required.
- 08Propose improvements to reporting and analysis processes, and document best practices and business logic.
What we're looking for
- At least 3 years of experience in Business Intelligence, Data Analytics, or similar roles.
- Experience with commercial data: sales / sell-in / sell-out, performance, KPIs, forecasting, revenue analysis, sales force.
- Advanced Power BI: data modeling, advanced DAX (filter context, CALCULATE, time intelligence), decision-oriented dashboards, basic performance optimization.
- Advanced Excel: Power Query, data transformation/cleaning, pivot tables and advanced functions.
- Python: process automation, data manipulation with pandas/numpy, simple ETL.
- SQL, and advanced English (required) — the role involves interacting with stakeholders in English, spoken and written.
- Excellent communication: able to present findings and coach non-technical audiences (sales managers, reps, executives).
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.