Data Analyst - Reporting & Analytics - Risk Adjustment

Molina Healthcare•Long Beach, CA

13h

About The Position

JOB DESCRIPTION Job Summary The Data Analyst role will support Molina's Risk Adjustment Predictive Analytics team. Designs and develops Suspect, Targeting, and Tracking System to support Molina’s Prospective and Retrospective Interventions. Knowledge/Skills/Abilities Assist Risk Adjustment Data Analytics Leaders in Prospective and Retrospective Intervention Strategy Analytics along with corresponding tracking of progress and impact of such interventions. Development and QA of ad-hoc as well as automated analytical as well as Reporting modules related to Risk Adjustment for Medicaid, Marketplace and Medicare/MMP. Assist Risk Adjustment Data Analytics Leaders in developing Automated Suspect and Target/Ranking Engine for all line of businesses. Analysis and reporting related to Managed care data like Medical Claims, Pharmacy, Lab and related financial data like risk score, revenue and cost. Calculate and track risk scores for all intervention outcome and for overall markets and LOB. Work in an agile business environment to derive meaningful information out of complex as well as large organizational data sets through data analysis, data mining, verification, scrubbing, and root cause analysis. Do root cause analysis for business data issues as assigned by the team lead. Analyze data sets and trends for anomalies, outliers, trend changes and opportunities, using statistical tools and techniques to determine significance and relevance. Utilize extrapolation, interpolation, and other statistical methodologies to predict future trends in cost, utilization, and performance. Assist with research, development and completion of special projects as requested by various internal departments, or in support of requests from regulatory agencies, contracting agencies, or other external organizations.

Requirements

1-3 Years of experience in working with data mapping, scrubbing, scrapping, and cleaning of data.
1-3 Years of experience in Managed Care Organization executing similar techno functional role that involves writing complex SQL Queries, Functions, Procedures and Data design
1-3 years of experience in working with Microsoft T-SQL, SSIS and SSRS.
1-3 Years of experience in Analysis related to Risk Scores, Encounter Submissions, Payment Models for at least one line of business among Medicaid, Marketplace and Medicare/MMP.
1-3 Years of experience in Prospective/Retrospective/Audit targeting Analytics and Reporting.
1-3 Years of experience in working with increasingly complex data problems in quantifying, measuring, and analyzing financial/performance management and utilization metrics.
1-3 Years of experience in Statistical Analysis and forecasting of trends in medical costs to provide analytic support for finance, pricing, and actuarial functions

Nice To Haves

Familiarity with Data Science Techniques and languages like Python and R programming would be an added advantage.

Responsibilities

Assist Risk Adjustment Data Analytics Leaders in Prospective and Retrospective Intervention Strategy Analytics along with corresponding tracking of progress and impact of such interventions.
Development and QA of ad-hoc as well as automated analytical as well as Reporting modules related to Risk Adjustment for Medicaid, Marketplace and Medicare/MMP.
Assist Risk Adjustment Data Analytics Leaders in developing Automated Suspect and Target/Ranking Engine for all line of businesses.
Analysis and reporting related to Managed care data like Medical Claims, Pharmacy, Lab and related financial data like risk score, revenue and cost.
Calculate and track risk scores for all intervention outcome and for overall markets and LOB.
Work in an agile business environment to derive meaningful information out of complex as well as large organizational data sets through data analysis, data mining, verification, scrubbing, and root cause analysis.
Do root cause analysis for business data issues as assigned by the team lead.
Analyze data sets and trends for anomalies, outliers, trend changes and opportunities, using statistical tools and techniques to determine significance and relevance.
Utilize extrapolation, interpolation, and other statistical methodologies to predict future trends in cost, utilization, and performance.
Assist with research, development and completion of special projects as requested by various internal departments, or in support of requests from regulatory agencies, contracting agencies, or other external organizations.