Healthcare BI Analyst

We exist for workers and their employers -- who are the backbone of our economy. That is where Centivo comes in -- our mission is to bring affordable, high-quality healthcare to the millions who struggle to pay their healthcare bills. The Healthcare BI Analyst role is pivotal in transforming claims, clinical and operational data into meaningful insights for market-facing and internal business needs. As part of the Analytics team, this position is responsible for delivering accurate, complete, and timely reports that will enable the relevant stakeholders to take decisions to achieve the twin goals of improve health outcomes while reducing cost of care. The role involves end-to-end ownership of assigned reporting and analytics capabilities, from data sourcing and validation to metric creation, resulting in dashboard design, development, testing, and ongoing enhancements. Additionally, the role supports troubleshooting, identifies root causes, recommends technology and process solutions, and participates in stakeholder meetings and special projects. Responsibilities include: Working under the guidance of the Analytics leader, this role is responsible for partnering 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: Architect 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. - Development: 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. - Testing: Conduct rigorous data validation and user acceptance testing (UAT); verify metric logic, source-to-target accuracy, and dashboard functionality before release. - 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. - Maintenance: Monitor and sustain 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. - Enhancements: Continuously evaluate existing analytics capabilities for improvement opportunities; incorporate stakeholder feedback, evolving business needs, and new data sources to expand analytical value. - Training and Documentation: Provide training and support to end users on utilizing and interpreting reports and analytics. Write user-friendly documentation to help self-serve. - Ad-hoc Needs: Deliver urgent business needs through rapid ad-hoc queries, report creation, and data analysis. - Trend 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. - Process Optimization: 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. - Special Projects: Contribute to assigned special projects and transformation initiatives. Qualifications: Required Skills and Abilities: - 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. - Expert-level troubleshooting skills with a focus on root cause identification and process improvement.