Strategy Analyst Iii
CurrentI take internal and external data from CMS, Medi-Cal, Covered California, and the health plan to provide strategic insights into what’s happening now and where we want to go into the future. I also research the marketplace to determine how we compare to the market and how we trend compared to the market. I look at things like persistency/tenure of members, 834 raw data for Medi-Cal and Covered California lines of business to identify data issues internally, DTRR data for Medicare line of business, issues with Sales and Outreach for Covered California, collaborating with IT and operations in developing a workflow for the Sales & Outreach team members, lead generation with even distribution across team members.The skills I use are technical and creative. I utilize SQL to create ad-hoc reports, improve existing reports, and push them into PowerBI for a clean refreshable report. I create temp tables, static tables, and stored procedures to produce the outcomes necessary.