Analyst, National Risk Adjustment Predictive Analytics (Remote)

Molina Healthcare; United States; Remote; USD 90,000 - 120,000; Full time

Benefits offered by this job

Competitive benefits

Job summary

Molina Healthcare is seeking an analytics professional to support enterprise risk adjustment predictive analytics. The role involves designing and developing targeting and tracking systems to support prospect and retrospective interventions.

You will work with risk adjustment data, create QA reporting and dashboards, and help quantify impact across Medicaid, Marketplace, and MMP programs in a fast-paced, agile environment.

Qualifications

• Proven experience writing complex SQL queries, functions, and data design with T-SQL.
• Experience with SSIS, SSRS, and Power BI for reporting and analytics.
• Predictive modeling and data analytics in health care quality or risk adjustment.

Responsibilities

• Support risk adjustment analytics for prospective and retrospective interventions.
• Develop QA ad-hoc and automated reporting for Medicaid, Marketplace, and MMP lines.
• Create suspect/targeting engines and tracking for multiple lines of business.
• Analyze managed care data (claims, pharmacy, lab, financial) and track risk scores.
• Lead data analysis in an agile environment and perform root-cause analysis.

Skills

SQL

T-SQL

SSIS

SSRS

Power BI

Predictive Modeling

HEDIS forecasting

Azure / AWS / Hadoop

Tools

Azure

AWS

Hadoop

Job description

Job Summary

Provides analyst support for Molina enterprise risk adjustment predictive analytics activities. Designs and develops suspect, targeting, and tracking system to support Molina’s prospective and retrospective interventions.

Essential Job Duties

• Assists risk adjustment data analytics leaders in prospective and retrospective intervention strategy analytics, and corresponding tracking of progress and impact of interventions.
• Develops quality assurance (QA) ad-hoc and automated reporting modules related to risk adjustment for Medicaid, Marketplace and Medicare/Medicare-Medicaid Plan (MMP) lines of business.
• Assists risk adjustment data analytics leaders in developing automated suspect and target/ranking engine for all lines of businesses.
• Facilitates analysis and reporting related to managed care data including claims, pharmacy, lab and related financial data (risk score/revenue/cost).
• Calculates and tracks risk scores for all intervention outcomes for all markets/lines of business.
• Works in an agile business environment; derives meaningful information out of complex/large organizational data sets through data analysis, data mining, verification, scrubbing, and root-cause analysis.
• Conducts root-cause analysis for business data issues.
• Analyzes data sets and trends for anomalies, outliers, trend changes and opportunities, using statistical tools and techniques to determine significance and relevance. Utilizes extrapolation, interpolation, and other statistical methodologies to predict future trends in cost, utilization, and performance.
• Assists 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.

Required Qualifications

• At least 2 years of experience writing complex SQL queries, functions, procedures, and data design, including experience working with relational databases, Microsoft Transact-SQL (T-SQL), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and Power BI, and predictive modeling experience in health care quality and HEDIS rate tracking, medical record review tracking, interventions tracking, and statistical analysis/HEDIS forecasting experience supporting quality, finance, and health plan functions, or equivalent combination of relevant education and experience.
• Analytical mindset, excellent attention to detail, and problem-solving skills.
• Experience in working with complex data to include quantifying, measuring, and analyzing financial/performance management and utilization metrics.
• Experience working with Microsoft T-SQL, Databricks SQL and Power BI.
• Experience writing complex SQL queries, functions, procedures and data design.
• Experience with Microsoft Azure, Amazon Web Services (AWS), or Hadoop.
• Ability to manage multiple priorities in a fast-paced, deadline-driven environment.
• Strong business acumen with the ability to connect data insights to strategic goals.
• Ability to communicate complex analytical results clearly to non-technical audiences.
• Proven ability to lead cross-functional projects and deliver value added results in a highly matrixed environment.
• Self-starter with a continuous improvement mindset.
• Effective verbal and written communication skills.
• Microsoft Office suite proficiency.

Preferred Qualifications

• Familiarity with data science techniques and languages like Python and R programming.

Molina Healthcare offers a competitive benefits and compensation package.

Molina Healthcare is an Equal Opportunity Employer (EOE) M/F/D/V