### **Job Description** **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 analytics assets (measures, templates, queries) to accelerate delivery. * Track and communicate KPIs, trends, and business drivers to stakeholders. * **Lead and mentor** analysts, defining standards, onboarding plans, and workflows as we scale the teams. * **Collaborate with leadership** to improve processes, shape strategy, and contribute to company growth. ### **Requirements** Qualifications Experience \& Technical Skills * 5\+ years of experience in data analytics or BI consulting, ideally within healthcare or other complex operational environments. * Deep expertise in Power BI, including: + Advanced DAX for time intelligence and conditional logic + Data modeling and schema design for large relational datasets + Row\-Level Security (RLS) and multi\-tenant governance + Write\-back and alerting solutions via Power Apps or Power Automate + Workspace governance, deployment pipelines, and dataset refresh strategies * Proven ability to design performant, visually compelling, and executive\-ready dashboards. * Proficient in SQL and Python (pandas, statsmodels, scikit\-learn) for ad hoc analysis, data preparation, and model evaluation. Analytical \& Statistical Skills * Experience applying inferential statistics (t\-tests, chi\-square, ANOVA) and experimental design (A/B, cohort, multivariate testing). * Applied statistical modeling (regression, cohort analysis, survival analysis, variance decomposition) to uncover drivers of revenue and outcomes. * While this is an analytics not ML role, practical familiarity with AutoML workflows, including feature preparation, model selection, and performance interpretation for churn, propensity, and time series models is a nice to have. * Focused on business interpretability and ROI, not just predictive accuracy. Business \& Strategy Orientation * Several years of experience defining KPIs and success metrics for growth, operations, or revenue cycle initiatives. * Translated ambiguous business problems into structured analytic frameworks. * Prioritized insights by ROI and presented findings to executive audiences. * Thrives in entrepreneurial environments where processes and playbooks are still forming. Leadership \& Consulting Skills * Experience leading client workshops or stakeholder sessions to define analytic needs. * Managed cross\-functional projects with finance, operations, and IT to align analytics with business strategy. * Communicates complex topics clearly across both technical and business audiences. * High\-ownership mindset with a passion for building teams, systems, and scalable analytics capabilities. * Excellent spoken and written English. Strong communication and persuasion skills to drive trust and alignment. Ideal Background * Prior experience at a top consulting firm. * Accustomed to fast\-paced, client\-facing work with shifting priorities and rapid iteration. * Demonstrated ability to thrive in unstructured, high\-accountability settings that require initiative and judgment. * Master’s degree preferred in Statistics, Data Science, Engineering, or a related quantitative field. ### **Benefits** *✔Competitive salary.* *✔ Prepaid medicine.* *✔ Life insurance.* *✔ Birthday day off.* *✔ Indefinite\-term employment contract, with all legal benefits, offered directly by the company.*