Data Analyst 3
Job Description
Data Analyst 3 will lead a unit supporting Medicaid federal data compliance, pharmacy claims integrity, and fee-for-service encounter analysis, including CMS/OIG audit and investigation support.
Responsibilities
- Lead and direct a unit focused on federal data compliance, pharmacy fraud/waste/abuse detection, fee-for-service claims analysis, and audit data support
- Set unit goals, priorities, and operational procedures
- Provide technical guidance and mentorship on claims analytics, rate code interpretation, federal reporting standards, pharmacy data analysis, and audit response protocols
- Perform the most complex analyses of pharmacy claims data to identify fraud, waste, and abuse indicators, including aberrant prescribing patterns, excessive dispensing volumes, controlled substance diversion, therapeutic duplication, inappropriate days-supply manipulation, pharmacy shopping behaviors, and billing for non-covered or excluded drugs versus Medicaid formulary and fee schedule rules
- Analyze fee-for-service claims and encounter data to identify billing irregularities such as rate code misapplication, pricing discrepancies, unbundling, upcoding, and reimbursement anomalies
- Apply deep knowledge of Medicaid rate code structures, including APGs, DRGs, fee schedule methodologies, and service-specific reimbursement rules, to validate claims accuracy and identify systemic billing errors
- Serve as a technical analytic resource for CMS and OIG audit data investigations by producing responsive data extracts, running targeted investigative analyses, preparing audit documentation and data validation packages, and reconciling discrepancies identified by federal auditors
- Coordinate with program areas and fiscal staff to develop and track corrective action plans
- Oversee analysis and validation of data submitted to CMS for federal reporting, including identifying data quality deficiencies, conducting root cause analyses, and coordinating corrective actions to maintain CMS data quality thresholds and avoid federal funding penalties
- Develop and maintain data quality monitoring frameworks to track completeness, accuracy, timeliness, and consistency of claims, encounter, and pharmacy data against federal standards
- Produce recurring compliance scorecards and support alert management for emerging risks, CMS certification outcomes, and audit readiness
- Investigate fee-for-service encounter submission issues, including missing or rejected claims, edit/audit failures, provider enrollment discrepancies, and rate code mapping errors
- Coordinate with claims processing (eMedNY), pharmacy benefit systems, and managed care encounter intake processes to resolve systemic data issues
- Research and interpret federal Medicaid regulations, CMS guidance, State Plan Amendments, and policy changes affecting rate code structures, pharmacy benefit rules, federal data reporting requirements, and audit methodologies
- Develop and implement advanced analytic methodologies such as statistical outlier detection, trend analysis, peer comparison models, and risk scoring to prioritize pharmacy FWA investigations and fee-for-service claims reviews
- Produce actionable intelligence and referral packages for program integrity staff
- Develop and maintain compliance dashboards, reporting tools, and analytic products for federal reporting staff, program integrity units, audit response teams, and management
- Review data sources, analytic products, and reports produced by lower-level staff for accuracy, completeness, and alignment with federal standards
- Coordinate cross-domain trend analysis across pharmacy and fee-for-service claims data
- Oversee supervisory responsibilities over Data Analysts and technical staff within the unit
Requirements
- Non-competitive: nine (9) years of experience* in data visualization, and statistical models and data mining tools
- Previous experience leading analytic teams, working with large-scale healthcare datasets, and ensuring federal compliance in Medicaid programs
- Excellent analytical and communication skills
- Demonstrated expertise in claims data analysis and knowledge of Medicaid rate code structures and fee-for-service billing rules, federal Medicaid reporting requirements, pharmacy claims adjudication processes, and supporting federal audits and compliance reviews
- Professional experience in Information Technology and data analysis and management, including database design, database optimization, transformation and load activities, query design and optimization, and large-scale multi-tier/multi environment databases
- Experience in a health-related information technology program
- Strong analytical, organizational, reporting, and communication abilities
- Experience contributing as an analytics subject matter expert to a large group of stakeholders
- Ability to independently develop strategies to support program integrity and identify opportunities to eliminate waste, fraud, or abuse in Medicaid administration
Technologies
- SQL
- Business intelligence tools
- Statistical methods
- eMedNY
Benefits
- Holiday & Paid Time Off
- Public Service Loan Forgiveness (PSLF)
- Pension from New York State Employees’ Retirement System
- Shift & Geographic pay differentials
- Affordable Health Care options
- Family dental and vision benefits at no additional cost
- NYS Deferred Compensation plan
- Access to NY 529 and NY ABLE College Savings Programs, and U.S. Savings Bonds
Substitution
- An associate’s degree may substitute for two years of general experience
- A bachelor’s degree may substitute for four years of general experience
- A master’s degree in data or computer science, informatics, economics, statistics, mathematics, or a related field may substitute for one year of general experience
- A Ph.D. in these fields may substitute for two years of general experience