Reporting Data Analyst

Ibex Limited; Washington; On-site; USD 70,000 - 90,000; Full time

Job summary

Ibex Limited in Washington is seeking a Data/Reporting Analyst to support the SIU and ensure regulatory adherence across NEMT operations. This role will manage, analyze, and report on large datasets to identify trends, anomalies, and discrepancies related to Fraud, Waste, and Abuse.

The ideal candidate has advanced Excel, SQL, and data visualization skills, with healthcare reporting experience. You will generate recurring CMS and State Medicaid reports and collaborate with operations,

Qualifications

• Advanced proficiency in Microsoft Excel and ability to manage large datasets.
• Hands-on experience with SQL and data visualization tools (Power BI, Tableau, QuickSight).
• Strong analytical thinking with attention to detail and problem-solving能力.
• Excellent written communication skills with the ability to distill complex data findings for executives.
• Experience in healthcare reporting, Medicare/Medicaid or NEMT compliance is a plus.

Responsibilities

• SIU program support: analyze trip logs, billing and credentialing data for anomalies.
• Regulatory & client reporting: develop and maintain CMS, State Medicaid, and MCO reports.
• Data integrity: perform data validation to ensure accuracy across systems.
• Trend analysis: identify operational cost drivers and service discrepancies.
• Cross-functional collaboration: work with operations, credentialing and IT to resolve data issues.

Skills

Advanced Excel

Analytical thinking

Communication

Tools

SQL

Power BI

Tableau

QuickSight

Job description

Overview

Position Overview:

The Data/Reporting Analyst plays a critical role in supporting the Special Investigations Unit (SIU) and ensuring regulatory adherence across Non-Emergency Medical Transportation (NEMT) operations. This individual will manage, analyze, and report on large datasets to identify trends, anomalies, and potential discrepancies related to Fraud, Waste, and Abuse (FWA). The analyst will maintain recurring government and client reporting, ensuring that all data submitted to CMS, State Medicaid agencies, and health plan partners is highly accurate and compliant.

Responsibilities

Key Responsibilities:

• SIU Program Support: Analyze trip logs, billing records, and driver credentialing data to identify suspicious patterns, anomalies, or compliance breaches that require SIU investigation.
• Regulatory & Client Reporting: Develop, generate, and maintain recurring and ad-hoc reports required by CMS, State Medicaid programs, and managed care organization (MCO) clients.
• Data Integrity & Quality Assurance: Perform regular data validation checks to ensure the accuracy and consistency of operational and financial data across internal systems.
• Trend Analysis: Proactively identify operational trends, cost drivers, or service discrepancies, transforming raw data into actionable insights for the compliance and operations teams.
• Cross-Functional Collaboration: Partner with operations, network credentialing, and IT teams to resolve data discrepancies and improve data collection processes.

Qualifications

Qualifications:

• Core Technical Skills: Advanced proficiency in Microsoft Excel and demonstrated ability to manage large, complex datasets.
• Desirable Technical Skills: Hands-on experience with SQL and data visualization tools (Power BI, Tableau, QuickSight) is highly preferred.
• Analytical Aptitude: Exceptional attention to detail with strong critical thinking and problem-solving capabilities.
• Communication: Strong written communication skills with the ability to distill complex data findings into clear, concise executive summaries.
• Industry Experience (Plus): Previous experience in healthcare, Medicare/Medicaid reporting, NEMT, or corporate compliance/audit functions.