Job Title: Senior Data Analyst – Medicaid Exp Must
Experience : 10+ Years
Key Responsibilities:
• Analyze large volumes of Medicaid healthcare data, including claims, enrollment, provider, eligibility, encounter, and pharmacy data.
• Gather, analyze, and document business and data requirements from Medicaid business stakeholders.
• Develop and maintain complex SQL queries, stored procedures, and data validation scripts for data extraction and analysis.
• Perform detailed analysis of Medicaid claims adjudication, member eligibility, provider networks, and reimbursement processes.
• Design, develop, and maintain dashboards, scorecards, and reports using BI tools such as Tableau, Power BI, or Cognos.
• Conduct data profiling, data quality assessments, and root cause analysis to ensure accuracy and completeness of Medicaid data.
• Collaborate with business teams to support Medicaid regulatory reporting, including CMS, state-specific mandates, and quality measures.
• Analyze healthcare KPIs, utilization trends, cost containment opportunities, and operational metrics.
• Support Medicaid programs such as Managed Care, Fee-for-Service (FFS), Dual Eligible, LTSS, and Value-Based Care initiatives.
• Work closely with ETL and data engineering teams to validate source-to-target mappings and data transformations.
• Perform impact analysis for system enhancements, regulatory changes, and Medicaid policy updates.
• Create functional specifications, business requirement documents (BRDs), and data mapping documents.
• Participate in Agile ceremonies including sprint planning, backlog grooming, daily stand-ups, and retrospectives.
• Ensure compliance with HIPAA regulations and healthcare data security standards.
• Provide mentorship and guidance to junior analysts and team members.
Required Skills:
Healthcare/Medicaid Domain:
• Strong experience in Medicaid programs and healthcare payer systems.
• Deep understanding of Medicaid claims processing lifecycle.
• Experience with:
○ Member Eligibility and Enrollment
○ Claims Adjudication
○ Provider Management
○ Encounters and Capitation
○ Prior Authorization
○ Care Management
○ Pharmacy and PBM data
○ ICD-10, CPT, HCPCS, DRG, NDC coding systems
○ CMS and State Medicaid reporting
This is a remote position.