Data Warehouse Analyst

• Analyze Medicaid claims, eligibility, provider, and encounter data to identify trends, anomalies, and opportunities for improvement.

• Support program evaluation, policy analysis, and operational decision-making through data insights.

• 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.

• Work with internal teams, external partners, and leadership to define data needs and deliver solutions. Present findings to stakeholders in a clear, actionable format.

• Ensure all work aligns with Agency’s regulations, including HIPAA and state data governance standards. Document methodologies, data sources, and assumptions for transparency and reproducibility.

• Support special projects, audits, and federal reporting initiatives as needed.

• Assist in the development of technical documentation for recurring reports, data pipelines, and reporting logic to ensure consistency and knowledge transfer.

• Develop and validate data extracts for federal and state reporting requirements, including CMS submissions and performance metrics.

• Apply machine learning methods where appropriate to improve forecasting and risk stratification models.

• Perform other duties as required. Specific Knowledge, Skills, and Abilities (KSAs)

• Bachelor’s or Master’s degree in Data Science, Statistics, Computer Science, or a related field.

• 5+ years of experience in data analysis, preferably in healthcare or Medicaid.

• Strong proficiency in SQL/SAS, with working knowledge of Python for data manipulation, analysis, and automation tasks.

• 3 years of experience with data visualization tools such as Tableau, or similar platforms for building dashboards and reports.

• Strong understanding of healthcare data, especially Medicaid or claims-based data.

• Excellent communication skills and ability to present complex data to non-technical audiences.

• Strong understanding of Fraud Analysis methodologies.

• Preferred Qualifications:

• Experience working with state or federal healthcare programs.

• Knowledge of Medicaid managed care, long-term services and supports (LTSS), or waiver programs.

• Familiarity with cloud-based data platforms (e.g., Azure, AWS).

• Experience with machine learning or advanced statistical modeling. General Knowledge, Skills and Abilities (KSAs)

• Communication: The ability to clearly convey information, in both written and verbal formats, to individuals or groups in a wide variety of settings (i.e.; project team meetings, management presentations, etc.). Must have the ability to effectively listen and process information provided by others.

• Customer Service: Works well with peers, clients, and customers (i.e.; business office, public, or other agencies). Able to assess the needs of the customer, provide information or assistance to satisfy expectations, or resolve a problem. Always courteous and professional.

• Decision Making: Makes sound, well-informed,

and objective decisions. Asks questions and escalates to the manager if unsure on how to proceed.

• Flexibility: Is open to change, new processes (or process improvement), and new information. Has the ability to adapt in response to new information, changing conditions, or unexpected obstacles. Ability to receive and give constructive criticism and maintain effective work relationships with others.

• Interpersonal: Shows friendliness, courtesy, understanding, and politeness to others.

• Leadership: Motivates, encourages, and challenges others. Ability to adapt to leadership styles in a variety of situations.

• Problem-Solving: Able to identify, evaluate, and use sound judgment to generate and evaluate alternative actions, and make recommendations accordingly.

• Team Building: Encourages, inspires, and guides others toward accomplishing the common goal. Education and Certifications Education

• Bachelor’s or Master’s degree in Data Science, Statistics, Computer Science, or a related field.