Wellmark Blue Cross and Blue Shield – Dual Eligibility      

Built dual eligibility forecasts using demographic, economic, and policy data from Iowa and South Dakota, projecting Medicaid-Medicare demand through 2035 using Python and Tableau.

Identified key post-COVID growth drivers such as inflation CPI: Medical Care, labor force shifts, and new legislation at the federal and state levels.

Developed a Tableau dashboard to visualize trends in income, race, education, age, disability status, and regional growth rates by county and zip code.

Recommended strategies for expanding provider workforces and hospital capacity in rural and tribal communities, using county-level forecasts and population projections.

Tools: Tableau, Python, Excel, U.S. Census API, public policy datasets