Healthcare BI Analyst at Centivo

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 prohects 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. - 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. Preferred Qualifications: - Preferred proficiency in Python programming to support automation and advanced analytics capabilities. Education and Experience: - 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. Location: - Candidates located within commuting distance of our Buffalo office will be considered for both in-person and hybrid roles. - All other applicants will be considered for remote positions. Centivo Values: - Resilient – This is wicked hard. There is no easy button for healthcare affordability. Luckily, the mission makes it worth it and sustains us when things are tough. Being resilient ensures we don’t give up. - Uncommon - The status quo stinks so we had to go out and build something better. We know the healthcare system. It isn't working for members, employers, and providers. So we're building it from scratch, from the ground up. Our focus is on making things better for them while also improving clinical results - which is bold and uncommon. - Positive – We care about each other. It takes energy to do hard stuff, build something better and to be resilient and unconventional while doing it. Because of that, we make sure we give kudos freely and feedback with care. When our tank gets low, a team member is there to be a source of new energy. We celebrate together. We are supportive, generous, humble, and positive. Who we are: Centivo is an innovative health plan for self-funded employers on a mission to bring affordable, high-quality healthcare to the millions who struggle to pay their healthcare bills. Anchored around a primary care based ACO model, Centivo saves employers 15 to 30 percent compared to traditional insurance carriers. Employees also realize significant savings through our free primary care (including virtual), predictable copay and no-deductible benefit plan design. Centivo works with employers ranging in size from 51 employees to Fortune 500 companies. For more information, visit centivo.com [Upgrade to PRO to see link] Headquartered in Buffalo, NY with offices in New York City and Buffalo, Centivo is backed by leading healthcare and technology investors, including a recent round of investment from Morgan Health, a business unit of JPMorgan Chase & Co.