Data Warehouse Analyst
Level (B) – Intermediate

At a minimum, the Vendor shall:

1. Analyze Medicaid claims, eligibility, provider, and encounter data to identify trends, anomalies, and opportunities for improvement.
2. Support program evaluation, policy analysis, and operational decision-making through data insights.
3. Design and maintain dashboards and reports using tools like Tableau or AI-Generated web-based dashboards. Present findings to stakeholders in a clear, actionable format.
4. Work with internal teams, external partners, and leadership to define data needs and deliver solutions. Present findings to stakeholders in a clear, actionable format.
5. Ensure all work aligns with client’s regulations, including HIPAA and state data governance standards. Document methodologies, data sources, and assumptions for transparency and reproducibility.
6. Support special projects, audits, and federal reporting initiatives as needed.
7. Assist in the development of technical documentation for recurring reports, data pipelines, and reporting logic to ensure consistency and knowledge transfer.
8. Develop and validate data extracts for federal and state reporting requirements, including CMS submissions and performance metrics.
9. Apply machine learning methods where appropriate to improve forecasting and risk stratification models.
10. Perform other duties as required.


Required Knowledge, Skills & Abilities
Minimum Qualifications:

1. Bachelor’s or Master’s degree in Data Science, Statistics, Computer Science, or a related field.
2. 5+ years of experience in data analysis, preferably in healthcare or Medicaid.
3. Strong proficiency in SQL/SAS, with working knowledge of Python for data manipulation, analysis, and automation tasks.
4. 3 years of experience with data visualization tools such as Tableau, or similar platforms for building dashboards and reports.
5. Strong understanding of healthcare data, especially Medicaid or claims-based data.
6. Excellent communication skills and ability to present complex data to non-technical audiences.
7. Strong understanding of Fraud Analysis methodologies.

Preferred Qualifications:
1. Experience working with state or federal healthcare programs.
2. Knowledge of Medicaid managed care, long-term services and supports (LTSS), or waiver programs.
3. Familiarity with cloud-based data platforms (e.g., Azure, AWS).
4. Experience with machine learning or advanced statistical modeling.