Remote Power Bi Sql Jobs in Hawaii (NOW HIRING)

Overview
BerryDunn is seeking an experienced Senior Consultant with subject matter expertise in Medicaid payment integrity to support Hawai'i Med-QUEST's (MQD) Fraud, Waste, and Abuse (FWA), program integrity, audit, third party liability (TPL), payment integrity, and claims review initiatives.
You will manage forensic review, investigative, and claims audit activities related to Medicaid medical, dental, behavioral health, pharmacy, provider, member, financial, and operational data. You will provide oversight and management of day-to-day operation of program integrity activities including claims audits, forensic reviews, investigations, documentation of findings, case tracking, and corrective action follow-up. You will work as a part of the BerryDunn Program Integrity team, and work closely with the MQD Program Integrity staff, audit and TPL specialists, data analysts, compliance staff, vendor partners, and other workstream members to help identify risks, interpret policy, improve internal controls, escalate issues for leadership, and support recovery efforts.
This position offers flexibility in work location, including fully onsite, hybrid, or remote arrangements. The preferred location is Kapolei, Hawai'i, or the U.S. West Coast. Regardless of location, the role requires availability during Hawaii Standard Time (HST) working hours.
This role requires travel approximately 30%-50% of the time, including travel to Hawai'i for onsite client meetings, release activities, training support, go-live readiness, and related project needs.
You Will

• Manage forensic review, investigative, and provider audit activities related to Medicaid medical, dental, behavioral health, pharmacy claims, as well as provider, member, financial, audit, TPL, and operational data.
• Provide oversight, quality assurance, and coordination for forensic analysts, audit SMEs, claims review resources, and related team members.
• Lead identification, documentation, and escalation of potential fraud, waste, abuse, or non-compliance risks.
• Review Medicaid claims and medical records for accuracy, reasonableness, and compliance with Medicaid policies, federal and state regulations, program requirements, and claims data.
• Research, interpret, and apply Medicaid policies, program integrity requirements, and applicable regulations to support audit findings, investigative recommendations, and corrective action planning.
• Establish, monitor, and report on program integrity, claims audit, investigative, corrective action, and operational improvement objectives, metrics, and key performance indicators.
• Develop and review investigative documentation, case summaries, findings, and recommendations.
• Support development of controls, monitoring approaches, and process improvements to strengthen FWA detection and deterrence.
• Develop corrective action recommendations and follow-up plans to address identified fraud, waste, abuse, improper payment, compliance, claims, audit, payment, or operational issues.
• Assist developing or updating relevant policies and procedures
• Develop and update review protocols, audit tools, documentation standards, and training supports related to Medicaid Program Integrity, claims audits, FWA monitoring, and TPL activities.
• Advise on how Medicaid policy, program integrity findings, audit results, and operational needs may translate into system requirements, change requests, process updates, or vendor follow-up.
• Support training, knowledge transfer, and technical assistance for client staff related to program integrity, claims audit processes, documentation expectations, and follow-up procedures.
• Support onsite planning, workgroup sessions, client leadership preparation, release activities, and related project needs in coordination with project leadership and workstream leads.

Key Tools and Systems:

• Microsoft Excel, SQL, Power BI, Tableau, or comparable analytics and dashboarding tools for claims analysis, audit support, validation, visualization, and reporting.
• Jira for action items, risks, blockers, dependencies, audit follow-up, corrective action tracking, dashboard visibility, and project coordination.
• SharePoint for project documentation, report templates, audit methodology, review protocols, version control, quality review, and knowledge management.
• Microsoft Teams and Outlook for meeting coordination, stakeholder communication, audit follow-up, training support, and client/vendor collaboration.
• Claims, eligibility, provider, member, TPL, payment integrity, and related Medicaid or vendor systems, as applicable.

You Have

• Minimum five (5) years of experience leading Medicaid payment/program integrity initiatives and managing provider audits, overpayment identification, claims audits, and recovery activities.
• In-depth understanding of medical coding (ICD-10, CPT), claims processing, and Medicaid requirements.
• Experience reviewing or auditing Medicaid medical, dental, behavioral health, pharmacy, provider, member, eligibility, TPL, or claims data.
• Experience managing forensic reviews, investigations, claims audits, or compliance reviews.
• Knowledge of Medicaid fee-for-service and managed care delivery systems, including managed care organization operations, claims processing, encounter data, provider network management, and payment methodologies
• Extensive knowledge of Medicaid Program Integrity, FWA, provider oversight, payment integrity, TPL, claims audit, or cost avoidance concepts.
• Experience developing audit findings, corrective action plans, executive-ready reporting, analytical summaries, methodology documentation, quality checks, or recurring performance reports.
• Strong analytical, documentation, quality assurance, and stakeholder coordination skills.
• Experience with public sector health or healthcare compliance projects preferred.
• Experience coordinating across client stakeholders, vendor partners, project leadership, and cross-functional workstreams in a public sector or health and human services environment.
• Experience using Jira, SharePoint, Microsoft Teams, Outlook, Excel, or comparable tools to manage action items, documentation, investigative follow-up, and project coordination.
• Bachelor's degree or equivalent combination of education and applicable experience.
• Ability to conduct research and analysis related to Medicaid policies, claims, provider oversight, payment integrity, and program integrity requirements.
• Ability to handle sensitive program, operational, provider, member, client, PII/PHI, and HIPAA-related information in alignment with confidentiality and data security expectations.

Preferred Qualifications/Experience:

• Experience supporting Medicaid Program Integrity, fraud risk assessments, TPL, PERM, payment integrity, claims audit, compliance monitoring, internal audit, or public sector health program analytics.
• Experience with Medicaid managed care operations, including encounter data validation, capitation payment oversight, provider network requirements, and managed care program integrity activities
• Preference will be given to candidates with relevant certifications, such as Certified Professional Coder (CPC), Certified in Healthcare Compliance (CHC), Certified Professional Medical Auditor (CPMA)
• Audit and investigation related certification such as Certified Fraud Examiner (CFE), Certified Internal Auditor (CIA), or equivalent credentials are also considered.

Compensation Details
The base salary range targeted for this role is $110,000 to $140,000. 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 in excess of 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.
BerryDunn Benefits & Culture
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.