Lead Analyst, National Risk Adjustment Predictive Analytics (Remote)

Molina Healthcare; United States; On-site; USD 72,000 - 157,000; Full time

Job summary

Molina Healthcare is seeking an experienced lead-level analyst to support enterprise risk adjustment predictive analytics. The role designs and develops suspect, targeting, and tracking systems to support prospective and retrospective interventions.

The position requires strong SQL, Power BI, and data analytics skills, with experience in Medicaid, Marketplace, and MMP risk adjustment. Collaboration across departments and agile delivery are essential to success.

Qualifications

• At least 4 years of experience with SQL, T-SQL, SSIS, SSRS and Power BI.
• Experience with predictive modeling in health care quality and HEDIS forecasting.
• Ability to manage multiple priorities in a fast-paced environment.
• Strong communication and problem-solving skills.

Responsibilities

• Assists risk adjustment analytics leaders in prospective and retrospective intervention analytics and tracking of progress and impact.
• Designs and leads tracking systems for risk scores across interventions and markets.
• Develops QA-ad hoc and automated reporting modules for risk adjustment across Medicaid, Marketplace, and MMP lines.
• Creates automated suspect and target/ranking engines for multiple lines of business.
• Performs analysis of managed care data (claims, pharmacy, lab, financial data) related to risk scores, revenue, and costs.
• Calculates and tracks risk scores for all intervention outcomes across markets and lines of business.
• Works in an agile environment to derive meaningful insights from large data sets.

Skills

SQL proficiency

Power BI

Analytical mindset

Communication skills

Cross-functional collaboration

Project leadership

Data visualization

Time management

Tools

T-SQL

SSIS

SSRS

Power BI

Azure

AWS

Hadoop

Job description

JOB DESCRIPTION Job Summary

Provides lead level 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.

• Assists risk adjustment data analytics leaders in prospective and retrospective intervention strategy analytics, and corresponding tracking of progress and impact of interventions.
• Designs and leads development of tracking system for risk scores for all intervention outcome and for overall markets and lines of business.
• 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.
• Collaborates with interdepartmental stakeholders and leaders to establish/deliver/explain the business requirement and data/data points, and facilitates escalation as needed.
• 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; provides executive summary of findings to requestors.
• 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.
• Adheres to Centers for Medicare and Medicaid Services (CMS)/state regulations related to risk adjustment analytics, and provides training as required.
• Stays current with industry regulation changes related to risk adjustment, and educates teams/leaders as necessary.
• Tracks, facilitates and manages changes in the Datawarehouse platform and performs transparent upgrades to analytics reporting modules to ensure no impact to end users.
• Conducts preliminary and post-impact analyses for any logic and source code changes for data analytics and reporting module, keeping other variables as constant that are not of focus.
• Develops training modules to help analysts understand processes, solutions or designs to meet the customer request.
• Maintains a team culture to adopt fast-paced agile environment and foster a positive attitude to take on challenging and time sensitive projects.
• Provides support for risk-adjustment related special projects.
• Provides training to new and existing risk adjustment predictive analytics team members.

JOB DESCRIPTION Job Summary

Provides lead level 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.
• Designs and leads development of tracking system for risk scores for all intervention outcome and for overall markets and lines of business.
• 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.
• Collaborates with interdepartmental stakeholders and leaders to establish/deliver/explain the business requirement and data/data points, and facilitates escalation as needed.
• 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; provides executive summary of findings to requestors.
• 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.
• Adheres to Centers for Medicare and Medicaid Services (CMS)/state regulations related to risk adjustment analytics, and provides training as required.
• Stays current with industry regulation changes related to risk adjustment, and educates teams/leaders as necessary.
• Tracks, facilitates and manages changes in the Datawarehouse platform and performs transparent upgrades to analytics reporting modules to ensure no impact to end users.
• Conducts preliminary and post-impact analyses for any logic and source code changes for data analytics and reporting module, keeping other variables as constant that are not of focus.
• Develops training modules to help analysts understand processes, solutions or designs to meet the customer request.
• Maintains a team culture to adopt fast-paced agile environment and foster a positive attitude to take on challenging and time sensitive projects.
• Provides support for risk-adjustment related special projects.
• Provides training to new and existing risk adjustment predictive analytics team members.

Required Qualifications

• At least 4 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

Pay Range: $72,370.82 - $156,803.45 / ANNUAL

• Actual compensation may vary from posting based on geographic location, work experience, education and/or skill level.