Overview
Skills
Job Details
Client: Delta Dental Plan of Michigan
Job Title: Healthcare Data Analyst (Medicaid/Medicare)
Location: Hybrid Minimum 3 days/week onsite in Okemos, MI
Visa Status: Open
Interview: MS Teams
Position Summary
Delta Dental Plan of Michigan is seeking a Healthcare Data Analyst (Medicaid/Medicare) with a strong background in SQL, DBT, and Tableau, coupled with deep domain experience in Medicaid and Medicare dental data. This role will support analytics initiatives focused on dental claims optimization, utilization-based scoring, and policy impact modeling. The ideal candidate thrives in cross-functional environments and has experience working with large-scale healthcare data systems.
Key Responsibilities
- Design and maintain modular DBT models within a medallion data architecture
- Develop performant SQL queries to transform and analyze data in Snowflake
- Create interactive, executive-level Tableau dashboards centered on claims, utilization trends, and benefit design impact
- Analyze Medicaid/Medicare dental datasets, identifying trends in care progression and cost modeling
- Partner with data science, actuarial, and operations teams to deliver actionable insights
- Document data pipelines, validation steps, and results for audit readiness and internal reviews
Must-Have Qualifications
- Advanced SQL skills and experience with cloud data warehouses (Snowflake preferred)
- Proficiency with DBT for data modeling, testing, and pipeline documentation
- Expertise in Tableau for creating scalable dashboards tailored to clinical and executive users
- Experience working with Medicaid/Medicare dental data (e.g., CDT codes, utilization metrics)
- Familiarity with healthcare claims structures and dental benefit terminology
- Strong communication and problem-solving skills in cross-functional teams
Preferred Qualifications
- Experience with benefit design analysis or dental claims optimization
- Familiarity with Git and CI/CD workflows
- Basic Python skills for data manipulation or machine learning support