Healthcare BI Analyst

Responsibilities

• Partner with business stakeholders and subject matter experts to gather, document, and validate requirements, and translate them into technical data specifications, KPIs, and user outcomes.
• Design end-to-end solution covering data sourcing, scalable data models, metric definitions, and dashboard layouts that are scalable, accurate, user-friendly, and visualize trends effectively.
• Build reports, dashboards, and analytical datasets; write optimized SQL and leverage company-approved BI tools to deliver market-facing and internal analytics capabilities.
• Own metric definitions, calculation logic, and data lineage to ensure reporting consistency across the organization.
• Conduct rigorous data validation and user acceptance testing (UAT); verify metric logic, source-to-target accuracy, and dashboard functionality before release.
• Manage the deployment of new reports and dashboards through defined release processes; communicate with stakeholders to ensure access control, user training, and timely delivery.
• Maintain the health of existing reporting assets; troubleshoot data and dashboard issues, identify root causes, and implement technology or process fixes to ensure ongoing reliability.
• Compare KPIs to understand the root cause of variation.
• Continuously evaluate existing analytics capabilities for improvement opportunities; incorporate stakeholder feedback, evolving business needs, and new data sources to expand analytical value.
• Provide training and support to end users on utilizing and interpreting reports and analytics. Write user-friendly documentation to help self-serve.
• Deliver urgent business needs through rapid ad-hoc queries, report creation, and data analysis.
• Perform continual analysis of current performance, utilizing historical trends, and conduct frequent re-forecasting to make necessary adjustments in staffing plans to achieve service level goals and business objectives.
• Support the internal teams by using data and root cause analysis to recommend process changes that improve SLAs and operational efficiency. Reduce manual effort by automating needs for insights through BI tools, scripting, and improved data pipelines.
• Contribute to assigned special projects and transformation initiatives.

Qualifications

• Strong understanding of healthcare data, including claims, clinical, and operational data.
• Proven experience managing the full lifecycle of reporting and analytics development, from requirements gathering through long-term maintenance.
• Mature expertise in Jira, Confluence, project planning, Microsoft Office, and related productivity tools.
• Demonstrated ability to work independently, problem-solve, and make decisions in a fast-paced environment while managing multiple issues and production deadlines.
• Preferred proficiency in Python programming to support automation and advanced analytics capabilities.
• Expert-level troubleshooting skills with a focus on root cause identification and process improvement.
• Bachelor’s degree in Information Systems, Data Analytics, or a related field.
• 5+ years of experience developing healthcare reporting and analytics using advanced SQL, BI tools such as Tableau and Power BI, advanced Excel skills including Power Query, Power Pivot, and Excel Data Model, working with large datasets across multiple source systems, and cloud infrastructure.