Healthcare BI Analyst

Centivo•Buffalo, NY

10d•Hybrid

About The Position

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.

Requirements

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.
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.
Proficiency in the use of AI tools to improve productivity while maintaining appropriate guardrails.
Excellent verbal and written communication skills, including the ability to clearly and concisely convey complex or technical information and interpret complex information from others.
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.

Nice To Haves

Preferred proficiency in Python programming to support automation and advanced analytics capabilities.

Responsibilities

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 prohects and transformation initiatives.