Analyst, Health Plan Risk & Quality Reporting (Remote in New Mexico)

Molina Healthcare; United States; On-site; USD 50,000 - 97,000; Full time

Benefits offered by this job

Competitive benefits package

Equal Opportunity Employer

Job summary

Molina Healthcare in the United States is seeking a Health Plan Data Analyst to support risk and quality reporting for Medicaid, Medicare, Marketplace and MMP. You will design and develop custom reports to back local interventions and track outcomes of initiatives.

The role includes educating users on using reports related to HEDIS, performing data mining and root-cause analysis, and contributing to special quality projects in an agile environment.

Qualifications

• 2+ years mapping, scrubbing and cleaning data for HEDIS/risk adjustment.
• 1 year in a managed care organization or equivalent.
• Experience with SQL, Power BI, and data analytics.
• Experience with cloud platforms (Azure/AWS) and big data tools.

Responsibilities

• Provides analyst support for health plan risk and quality reporting activities.
• Designs and develops custom health plan reports to support interventions and tracks outcomes.
• Educates users on how to use reports related to risk and quality/HEDIS.
• Builds intervention strategy reporting to close gaps and improve HEDIS performance.
• Works in an agile environment using SQL, Power BI, and Excel for data analysis.

Skills

Data analysis

SQL

Power BI

Cloud platforms

Attention to detail

Communication skills

Time management

MS Office

Tools

Databricks SQL

T-SQL

Microsoft Excel

Job description

JOB DESCRIPTION Job Summary

Provides analyst support for health plan risk and quality reporting activities. Designs and develops custom health plan reports to support local interventions, provider outreach, and tracks outcomes of initiatives. Educates users on how to use reports related to risk and quality/Healthcare Effectiveness Data and Information Set (HEDIS) for Medicaid, Medicare, Marketplace and Medicare/Medicare-Medicaid Plan (MMP). Assists with research, development, and completion of special quality performance improvement projects including root-cause analysis.

• Captures and documents health plan quality reporting requirements, builds custom reports, and educates health plan users on how to use reports.
• Builds intervention strategy reporting for the risk and quality interventions and measures gap closure.
• Builds ad hoc quality reports as requested to track HEDIS performance and supplemental data monitoring.
• Develops quality assurance (QA) custom health plan reports related to Risk and Quality/HEDIS for Medicaid, Marketplace and Medicare/MMP.
• Develops custom health plan reports related to managed care data including medical claims, pharmacy, lab and HEDIS rates.
• Collaborates with the national risk and quality team on testing of pre-production reporting for assigned health plan.
• Calculates and tracks gap closure and intervention outcome reporting for the assigned health plan.
• Works in an agile business environment to derive meaningful information out of complex and 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 databricks Structured Query Language (SQL), PowerBi, Microsoft Excel, and techniques to determine significance and relevance.
• Assists with research, development and completion of special quality-related projects as requested by various internal departments, or in support of requests from regulatory agencies, contracting agencies, or other external organizations.
• Represents as a key partner to assist with testing changes in the Datawarehouse platform and performs transparent upgrades to reporting modules to ensure no impact to the end users.
• Conducts preliminary and post-impact analyses for any logic and source code changes for data and reporting module - keeping other variables as constant that are not of focus.
• Represents as a HEDIS subject matter expert, and supports health plan improve performance on underperforming quality measures.

JOB DESCRIPTION Job Summary

Provides analyst support for health plan risk and quality reporting activities. Designs and develops custom health plan reports to support local interventions, provider outreach, and tracks outcomes of initiatives. Educates users on how to use reports related to risk and quality/Healthcare Effectiveness Data and Information Set (HEDIS) for Medicaid, Medicare, Marketplace and Medicare/Medicare-Medicaid Plan (MMP). Assists with research, development, and completion of special quality performance improvement projects including root-cause analysis.

• Captures and documents health plan quality reporting requirements, builds custom reports, and educates health plan users on how to use reports.
• Builds intervention strategy reporting for the risk and quality interventions and measures gap closure.
• Builds ad hoc quality reports as requested to track HEDIS performance and supplemental data monitoring.
• Develops quality assurance (QA) custom health plan reports related to Risk and Quality/HEDIS for Medicaid, Marketplace and Medicare/MMP.
• Develops custom health plan reports related to managed care data including medical claims, pharmacy, lab and HEDIS rates.
• Collaborates with the national risk and quality team on testing of pre-production reporting for assigned health plan.
• Calculates and tracks gap closure and intervention outcome reporting for the assigned health plan.
• Works in an agile business environment to derive meaningful information out of complex and 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 databricks Structured Query Language (SQL), PowerBi, Microsoft Excel, and techniques to determine significance and relevance.
• Assists with research, development and completion of special quality-related projects as requested by various internal departments, or in support of requests from regulatory agencies, contracting agencies, or other external organizations.
• Represents as a key partner to assist with testing changes in the Datawarehouse platform and performs transparent upgrades to reporting modules to ensure no impact to the end users.
• Conducts preliminary and post-impact analyses for any logic and source code changes for data and reporting module - keeping other variables as constant that are not of focus.
• Represents as a HEDIS subject matter expert, and supports health plan improve performance on underperforming quality measures.

Essential Job Duties

• Captures and documents health plan quality reporting requirements, builds custom reports, and educates health plan users on how to use reports.
• Builds intervention strategy reporting for the risk and quality interventions and measures gap closure.
• Builds ad hoc quality reports as requested to track HEDIS performance and supplemental data monitoring.
• Develops quality assurance (QA) custom health plan reports related to Risk and Quality/HEDIS for Medicaid, Marketplace and Medicare/MMP.
• Develops custom health plan reports related to managed care data including medical claims, pharmacy, lab and HEDIS rates.
• Collaborates with the national risk and quality team on testing of pre-production reporting for assigned health plan.
• Calculates and tracks gap closure and intervention outcome reporting for the assigned health plan.
• Works in an agile business environment to derive meaningful information out of complex and 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 databricks Structured Query Language (SQL), PowerBi, Microsoft Excel, and techniques to determine significance and relevance.
• Assists with research, development and completion of special quality-related projects as requested by various internal departments, or in support of requests from regulatory agencies, contracting agencies, or other external organizations.
• Represents as a key partner to assist with testing changes in the Datawarehouse platform and performs transparent upgrades to reporting modules to ensure no impact to the end users.
• Conducts preliminary and post-impact analyses for any logic and source code changes for data and reporting module - keeping other variables as constant that are not of focus.
• Represents as a HEDIS subject matter expert, and supports health plan improve performance on underperforming quality measures.

Required Qualifications

• At least 2 years of experience mapping, scrubbing, scrapping, and cleaning data, and analysis experience related to HEDIS and/or risk adjustment, and 1 year of experience in a managed care organization, or equivalent combination of relevant education and experience.
• Analytical mindset with excellent attention to detail.
• 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.
• Self-starter with a continuous improvement mindset.
• Effective verbal and written communication skills.
• Microsoft Office suite (including advanced Excel), and applicable software programs proficiency.

Preferred Qualifications

• Certified Professional in Healthcare Quality (CPHQ).
• Certified HEDIS Compliance Auditor (CHCA).
• Registered Nurse. If licensed, license must be active and unrestricted in state of practice.

To all current Molina employees: If you are interested in applying for this position, please apply through the Internal Job Board.

Molina Healthcare offers a competitive benefits and compensation package. Molina Healthcare is an Equal Opportunity Employer (EOE) M/F/D/V

Pay Range: $49,930 - $97,363 / ANNUAL

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