Senior Healthcare Data Analyst at BerryDunn

Job description

BerryDunn’s Health Analytics Practice Group (HAPG) is dedicated to supporting decision-makers in state government healthcare agencies, mission-driven organizations, and other public and private sector organizations. Our team brings together deep expertise in health economics, actuarial science, data science, policy analysis, and advanced analytics to help clients address complex questions involving healthcare financing and payment, cost and risk, program performance, and the use of data to inform policy, operational, and strategic decisions. As a Senior Healthcare Data Analyst, you will apply advanced healthcare analytics, quantitative methods, and Medicaid subject-matter knowledge to support major policy and program transformation initiatives. You will analyze complex eligibility, enrollment, claims and encounter, provider, utilization, financial, and operational data; develop measures and monitoring tools; assess the impacts of policy and program changes; and translate findings into practical information for decision-makers. The position will focus significantly on supporting Hawaiʻi Med-QUEST as the agency implements major Medicaid policy and operational changes, including changes affecting eligibility and enrollment, work and community engagement requirements, program operations, and related systems, reporting, and implementation processes. You will work across policy, program, operational, and technical teams to help translate complex requirements into analytic approaches, evaluate implementation impacts, monitor program performance, and identify emerging risks and opportunities. This position offers the opportunity to contribute to high-impact work such as: • Analyzing Medicaid policy and implementation impacts, including changes in eligibility, enrollment, coverage continuity, utilization, expenditures, access, and affected populations. • Developing measurement and monitoring approaches to assess implementation progress, program performance, and emerging trends or risks. • Using complex healthcare and administrative data to answer policy and operational questions and support evidence-based decision-making. • Supporting major Medicaid system and program changes through data validation, testing, production monitoring, and post-implementation analysis. You will collaborate with multidisciplinary teams of healthcare analysts, health economists, actuaries, policy experts, data scientists, technology professionals, and other subject-matter experts. You will also have opportunities to lead complex analyses, work directly with client and project leadership, contribute to analytic methods and tools, and help strengthen sustainable data and analytic capabilities for public healthcare programs. Our work environment values critical thinking, intellectual curiosity, mutual respect, and rigorous, evidence-based problem-solving, with an unwavering focus on delivering results that matter to our clients and the communities they serve. This position offers flexibility in work location, including fully onsite, hybrid, or remote arrangements. The preferred location is Hawaiʻi or the U.S. West Coast. BerryDunn’s Hawaiʻi office is located in Kapolei, Oʻahu. The role requires availability during Hawaii Standard Time (HST) working hours and may require periodic travel within Hawaiʻi and the continental United States based on project needs. • Analyze large and complex eligibility, enrollment, claims and encounter, provider, utilization, financial, and operational datasets to identify trends, population impacts, risks, gaps, and implementation outcomes. • Assess how federal and state Medicaid policy changes may affect eligibility, enrollment, coverage continuity, utilization, expenditures, access, program operations, and affected populations. Develop analytic approaches to support implementation planning, monitoring, and evaluation. • Define, calculate, validate, and interpret measures and key performance indicators. Develop dashboards, reports, analytic summaries, monitoring tools, and ad hoc analyses for program leadership and implementation teams. • Translate policy, program, operational, and business questions into defined populations, business rules, data requirements, reporting logic, analytic specifications, and validation criteria. • Provide data and analytic support throughout system development and implementation, including requirements validation, testing, UAT, production validation, release monitoring, and post-implementation assessment. • Conduct data profiling, reconciliation, reasonableness checks, and quality reviews; investigate discrepancies and anomalies; document assumptions and limitations; and work with technical and business teams to resolve data issues. • Apply appropriate quantitative methods, including trend, cohort, utilization, expenditure, population, and comparative analyses, to answer policy and program questions. Develop reproducible analytic processes and clearly document methods. • Translate complex analyses into clear findings, visualizations, presentations, technical documentation, and recommendations for technical and non-technical audiences. Collaborate with Medicaid leaders, policy experts, operations teams, technologists, vendors, actuaries, economists, and other analysts. • Master’s degree in health services research, public health, health informatics, statistics, biostatistics, data science, economics, health policy, mathematics, information systems, or a related quantitative field. • Five or more years of progressively responsible experience conducting healthcare analytics, Medicaid or health and human services data analysis, health services research, program evaluation, or related quantitative work. • Demonstrated experience working hands-on with large and complex healthcare or administrative datasets, such as eligibility and enrollment, claims and encounter, provider, utilization, financial, or operational data. • Advanced proficiency with SQL and/or one or more analytic programming tools such as SAS, R, Python, or comparable technologies, including demonstrated experience manipulating, analyzing, validating, and interpreting large and complex datasets. • Experience developing analytical methods, measures, reports, dashboards, data visualizations, and other decision-support products, with strong attention to data quality and methodological rigor. • Ability to translate policy, program, operational, and business questions into structured analytical approaches and explain findings, assumptions, limitations, and implications clearly to both technical and non-technical audiences. • Strong analytical, problem-solving, writing, documentation, and communication skills, including the ability to work independently on complex analyses while collaborating effectively across multidisciplinary teams. • Ability to work appropriately with sensitive Medicaid, healthcare, PII, and PHI data and follow applicable privacy, security, confidentiality, and HIPAA requirements. Preferred candidates may also have experience with one or more of the following: • Experience supporting a state Medicaid agency, Medicaid managed care organization, CMS-related Medicaid initiative, or Medicaid consulting or technology environment. Working knowledge of Medicaid eligibility, enrollment, claims and encounters, managed care, and program operations is preferred. • Experience with Medicaid eligibility systems, MMIS/MES environments, integrated eligibility systems, data warehouses, vendor-managed data platforms, or major Medicaid policy and system implementations. • Experience assessing utilization, expenditures, access, population outcomes, coverage transitions, program performance, or the effects of policy and operational changes using administrative healthcare data. • Experience with Power BI, Tableau, or similar visualization tools and familiarity with structured data validation, testing, requirements management, or collaboration tools such as Jira and SharePoint. The ideal candidate will be analytically rigorous, practical, and comfortable working with complex and imperfect healthcare data. They should be able to move between detailed technical analysis and broader Medicaid policy and operational questions, translating findings into clear implications for decision-makers. The candidate should bring strong judgment, curiosity, documentation and quality-control habits, and the ability to work collaboratively across policy, program, operational, and technical teams in a complex implementation environment. The base salary range targeted for this role is $80,000 - $120,000. This position may also be eligible for a discretionary annual bonus based on factors such as company and personal performance. This salary range represents BerryDunn’s good faith and reasonable estimate of the range of possible compensation at the time of posting. If an applicant possesses experience, education, or other qualifications more than the minimum requirements for this posting, that applicant is encouraged to apply, and a final salary range may then be based on those additional qualifications; compensation decisions are dependent on the facts and circumstances of each case. The salary of the finalist selected for this role will be based on a variety of factors, including but not limited to years of experience, depth of experience, seniority, merit, education, training, amount of travel, and other relevant business considerations. Our people are what make BerryDunn special, and in return we strive to support our employees and help them thrive. Eligible employees have access to benefits that go beyond what’s expected to support their physical, mental, career, social, and financial well-being. Visit our website for a complete list of benefits and a look into our culture: Experience BerryDunn . We will ensure that individuals are provided reasonable accommodation to participate in the job application or interview process or perform essential job functions. Please contact careers@berrydunn.com to request an accommodation. We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender, gender identity or expression, or veteran status. We are proud to be an equal opportunity workplace. About BerryDunn BerryDunn is the brand name under which Berry, Dunn, McNeil & Parker, LLC and BDMP Assurance, LLP, independently owned entities, provide services. Since 1974, BerryDunn has helped businesses, nonprofits, and government agencies throughout the US and its territories solve their greatest challenges. The firm’s tax, advisory, and consulting services are provided by Berry, Dunn, McNeil & Parker, LLC, and its attest services are provided by BDMP Assurance, LLP, a licensed CPA firm. BerryDunn is a client-centered, people-first professional services firm with a mission to empower the meaningful growth of our people, clients, and communities. The firm has been recognized for its efforts in creating a diverse and inclusive workplace culture, and for its focus on learning, development, and well-being. Learn more at berrydunn.com . Don’t See A Match For You At This Time? We invite you to join our Talent Connection and let’s stay in touch

Requirements

Must-haves

This position offers the opportunity to contribute to high-impact work such as:
Analyzing Medicaid policy and implementation impacts, including changes in eligibility, enrollment, coverage continuity, utilization, expenditures, access, and affected populations.
Developing measurement and monitoring approaches to assess implementation progress, program performance, and emerging trends or risks.
Using complex healthcare and administrative data to answer policy and operational questions and support evidence-based decision-making.
Supporting major Medicaid system and program changes through data validation, testing, production monitoring, and post-implementation analysis.
Analyze large and complex eligibility, enrollment, claims and encounter, provider, utilization, financial, and operational datasets to identify trends, population impacts, risks, gaps, and implementation outcomes.
Define, calculate, validate, and interpret measures and key performance indicators. Develop dashboards, reports, analytic summaries, monitoring tools, and ad hoc analyses for program leadership and implementation teams.
Translate policy, program, operational, and business questions into defined populations, business rules, data requirements, reporting logic, analytic specifications, and validation criteria.
Provide data and analytic support throughout system development and implementation, including requirements validation, testing, UAT, production validation, release monitoring, and post-implementation assessment.
Master’s degree in health services research, public health, health informatics, statistics, biostatistics, data science, economics, health policy, mathematics, information systems, or a related quantitative field.
Five or more years of progressively responsible experience conducting healthcare analytics, Medicaid or health and human services data analysis, health services research, program evaluation, or related quantitative work.
Demonstrated experience working hands-on with large and complex healthcare or administrative datasets, such as eligibility and enrollment, claims and encounter, provider, utilization, financial, or operational data.
Experience developing analytical methods, measures, reports, dashboards, data visualizations, and other decision-support products, with strong attention to data quality and methodological rigor.
Strong analytical, problem-solving, writing, documentation, and communication skills, including the ability to work independently on complex analyses while collaborating effectively across multidisciplinary teams.
Ability to work appropriately with sensitive Medicaid, healthcare, PII, and PHI data and follow applicable privacy, security, confidentiality, and HIPAA requirements.
Experience with Medicaid eligibility systems, MMIS/MES environments, integrated eligibility systems, data warehouses, vendor-managed data platforms, or major Medicaid policy and system implementations.
Experience assessing utilization, expenditures, access, population outcomes, coverage transitions, program performance, or the effects of policy and operational changes using administrative healthcare data.
Experience with Power BI, Tableau, or similar visualization tools and familiarity with structured data validation, testing, requirements management, or collaboration tools such as Jira and SharePoint.

Nice-to-haves

Preferred candidates may also have experience with one or more of the following:

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlpythonjirago

Platform: icims
Effort: medium