Business Intelligence & QA Analyst II-Healthcare Analytics

Tapestry Health is seeking a Business Intelligence and QA Analyst II with deep healthcare and clinical experience to lead business analytics initiatives. The role focuses on partnering with various teams to define requirements, validate data, and drive the adoption of insights that enhance operational performance.

Responsibilities:

• Serve as a senior partner to clinical and operational leaders to identify opportunities, define priorities, and drive reporting and process improvements across CCM/BHI/RPM/IPV programs
• Lead requirements discovery through interviews and workshops; align stakeholders on scope, success criteria, assumptions, dependencies, and risks
• Own requirements documentation including business, functional, and non-functional requirements, user stories, and acceptance criteria with clear traceability from request through release
• Provide mentorship and guidance to the technical developers and cross-functional partners on best practices in requirements, validation, and documentation
• Translate clinical workflows and documentation requirements into analytics-ready definitions (cohorts, eligibility, timing rules, numerator/denominator logic, exclusions)
• Demonstrate strong understanding of EHR concepts and clinical data (patients, encounters, diagnoses, vitals, orders, documentation, billing/claims data flows), with emphasis on PointClickCare (PCC) and MatrixCare (Matrix)
• Identify the appropriate source of clinical information from EHRs and related systems and translate requirements and data elements into standardized clinical vocabularies
• Partner with Data Scientists to validate source-to-target mapping, transformation logic, business rules, and data integrity across pipelines and curated views
• Partner with Data Engineering team to ensure data sources available in the Lakehouse
• Establish and execute a repeatable QA approach for dashboards and data products, including test planning, test case design, regression testing, and release readiness criteria
• Validate data accuracy and business logic using SQL (reconciliations, trend validation, duplicates/uniqueness checks, join integrity, and edge-case testing)
• Validate dashboard and report outputs against source systems to ensure end-to-end accuracy and trust, including PointClickCare (PCC), MatrixCare (Matrix), Tapestry Complete, BHI, and RPMI platforms (e.g., record-level spot checks, cohort matching, timing logic verification, and cross-system reconciliation)
• Perform cross-system reconciliations (counts, totals, patient lists, date logic, inclusion/exclusion rules) and document validation results and known limitations
• Identify, document, and manage defects with clear reproduction steps and expected vs. actual outcomes; support triage and verify fixes through retesting
• Support UAT by coordinating test cycles, guiding end users, and documenting sign-off and outcomes
• Partner with stakeholders to ensure requested dashboard content is complete, accurate, and aligned to operational needs
• Review dashboard requirements and ensure the 'ask' is fully represented (required visuals, filters, drill-throughs, cohorts, time windows, and edge cases)
• Validate KPI definitions and metric specifications, including documentation and governance of: definitions, thresholds, cohorts, timing rules, eligibility, and program compliance logic
• Perform UI/UX review of dashboards to ensure the experience is intuitive and user-friendly (navigation, layout, labeling, filter logic, performance considerations, and 'what action should a user take from this view?' clarity)
• Monitor ongoing dashboard performance and data quality (data drift, definition changes, upstream source issues), raise issues proactively, and drive continuous improvement recommendations
• Create end-user training materials for dashboards and reporting tools (quick reference guides, workflow documentation, FAQs, and short-form tutorials)
• Deliver live and/or virtual training sessions to clinical and operational teams, ensuring users can interpret KPIs, navigate dashboards, and apply insights to workflows
• Provide post-launch support (onboarding sessions, intake and triage of questions/issues) to drive adoption and consistent usage
• Partner with operational leaders to translate dashboard findings into actionable next steps and promote sustained operational improvement

Requirements:

• Clinical background required, with a degree in Nursing (RN preferred), Health Information Management (HIM), Health Informatics, Public Health, or a comparable healthcare-related field, or equivalent combination of clinical training and relevant experience
• Demonstrated experience supporting CCM, BHI, and/or RPM programs, including workflow understanding, documentation needs, and performance reporting
• Strong understanding of EHR systems and clinical data, with experience in PointClickCare (PCC) and/or MatrixCare (Matrix) strongly preferred
• Working knowledge of SQL for querying, validation, troubleshooting, and data quality checks (joins, aggregates, filters, reconciliation logic)
• Experience working with representing clinical concepts in dashboards in a requirements/validation capacity (reviewing requirements, validating outputs, usability review, UAT support)
• Strong facilitation, communication, and documentation skills, including the ability to translate complex metrics and workflows for non-technical audiences
• Exceptionally strong ability to source clinical information, clinical vocabularies (ICD-10, CPT, HCPC, LOINC, RxNorm, etc.)
• 3+ years of experience in a Business Analyst, Senior Analyst, Analytics/BI Analyst, or Quality Analyst role delivering healthcare analytics and reporting solutions
• Experience in Value-Based Care environments (quality performance measurement, utilization, outcomes, risk-based contracts)
• Experience with claims/encounters, program eligibility logic, or billing/workqueue workflows tied to CCM/BHI/RPM
• Experience working in Agile/Scrum environments and tools (Jira/Confluence or Azure DevOps)
• Familiarity with data warehousing concepts and analytics engineering practices (source-to-target mapping, curated views, metric layers)
• Proven experience owning requirements and quality across the delivery lifecycle: requirements → build support → test → UAT → release → adoption
• Experience in creating training materials and leading end-user training for dashboards or operational reporting tools