Postúlate en Kit Empleo: kitempleo.com.co/empleo/1azhlo

Position Overview

We’re seeking a Lead / Principal Data Analytics Consultant who can turn complex healthcare and medical claim data into clear, actionable insights — and help build the foundation for our growing analytics organization.

You’ll work across Power BI (DAX, Power Query, visuals), SQL, and Python to design scalable models and reports, then go beyond dashboards to interpret results, frame the story, and advise decision-makers.

This role is hands-on today but designed for leadership. You’ll take ownership of key client deliverables while mentoring and growing a high-performing analytics team, including shaping the development of our new Colombian and Philippines delivery hubs.

Note: Due to the sensitive nature of the datasets we work with, this is a 100% in-office position based in Colombia. Because we work closely with U.S. healthcare clients and need rapid iteration on analytics deliverables, this role will work standard U.S. business hours (9AM - 6PM US Eastern Time)

Key Responsibilities
- Partner with business leaders to define metrics, scope questions,



and translate needs into analytical requirements.
- Design and maintain data models, queries, and ETL/Power Query steps for analytics and reporting.
- Build, publish, and govern Power BI semantic models and dashboards; optimize DAX for performance and usability.
- Implement advanced Power BI capabilities, including:
- Complex DAX measures and calculated tables for dynamic KPI logic
-
Row-Level Security (RLS) and role-based access controls
-
Data write-back, alerts, and parameterized what-if analyses
- Composite models, DirectQuery, and incremental refresh for large healthcare datasets
- Conduct exploratory analyses in SQL or Python (e.g., cohorting, segmentation, forecasting, regression).
- Translate analytical findings into clear narratives and recommendations that drive executive decisions.
- Establish documentation, QA checks, and data quality guardrails across projects.
- Create reusable analyti

Postúlate en Kit Empleo: kitempleo.com.co/empleo/1azhlo

📌 Lead Data Analyst Consultant (Bogotá)
🏢 Booth & Partners
📍 Bogotá