Sr Analyst, Healthcare Analytics - Risk Adjustment (REMOTE)

Molina Healthcare; City of Albany (NY); Remote; USD 77,000 - 156,000; Full time

Job summary

An established industry player in healthcare analytics is seeking a Sr. Analyst to join their Risk Adjustment Actuarial team. This role involves analyzing complex healthcare data, developing performance reports, and making strategic recommendations based on findings. You will leverage advanced SQL and data visualization tools to create impactful dashboards and forecasts. If you have a strong analytical background and a passion for healthcare, this opportunity offers a chance to contribute to meaningful healthcare interventions and drive financial results.

Qualifications

• 5-7 years of experience in database management and financial metrics analysis.
• Advanced SQL skills and proficiency in data visualization tools.

Responsibilities

• Analyze healthcare claims data to evaluate program performance.
• Develop reports and dashboards to communicate insights to management.

Skills

Healthcare Data Analysis

SQL

Financial Analysis

Data Visualization (Power BI, Tableau)

Root Cause Analysis

Data Management

Forecasting

Data Structure Knowledge

Education

Bachelor's Degree in Finance

Bachelor's Degree in Economics

Bachelor's Degree in Computer Science

Tools

Databricks

Spark SQL

SQL Server

Excel

Power BI

Tableau

Job description

JOB DESCRIPTION

Job Summary

This Sr. Analyst, Healthcare Analytics role will be responsible for work around Program Valuation on Molina's Risk Adjustment Actuarial team. Responsibilities include research, analysis and modeling of complex healthcare claims data, pharmacy data, lab data, and Risk Adjustment submissions data to evaluate healthcare intervention program performance. Develops and presents Risk Adjustment intervention ROI, incremental conditions captured, and other program performance reports including forecasts and makes recommendations based on relevant findings. Performs Health Plan strategic analysis and planning and coordinates across business units on Risk Adjustment Program Valuation and Strategic/Scoreable Action Items (SAIs) to meet business needs. Performs analysis across multiple states and lines of business (Medicare, Medicaid, Marketplace ACA).

KNOWLEDGE/SKILLS/ABILITIES

• Compiling and organizing health care data using Databricks and Spark SQL, Notebooks, Workflows, Repositories, SQL Server Stored Procedures, SQL Server Integration Services (SSIS), and other analytic / programming tools as needed
• Reporting includes Risk Adjustment program performance metrics, risk score and revenue impact, tracking of strategic/scorable action items, annual and quarterly forecasts, and regular deep dives to drive improvement in financial results
• Take ownership with root cause analysis to maintain high integrity data and processes to minimize discrepancies and gaps
• Create databases and reporting dashboards for monitoring, tracking and trending based on project specifications and applies automation as appropriate
• Complete analysis and forecasting of risk adjustment intervention program values
• Develop and demonstrate proficiency in running all applicable risk models including the various CMS models for Medicare Advantage members, the HHS model for Commercial ACA members, the CDPS model for Medicaid members, and others as needed
• Must have a strong attention to detail and knowledge of data structure and programming
• Performing financial analysis to assist in delivering optimal health care management and decision making
• Understanding and applying data storage and data sharing best practices
• Converting data into usable information that is easy to understand and provides insights needed to support strategic investment decisions
• Research and develop reports and analyses for senior management and effectively and concisely communicate results and key takeaways
• Collects and documents report / programming requirements from requestors to ensure appropriate creation of reports and analyses. Uses peer-to-peer review process and end-user consultation to reduce errors and rework
• Practice strong judgement in carrying out work independently, consult with experts as needed and use available resources and reports to critique results
• Manage multiple projects and consistently deliver results on time in a fast-paced environment with changing priorities.

JOB QUALIFICATIONS

Required Education

Bachelor's Degree in Finance, Economics, Computer Science

Required Experience

• 5-7 years increasingly complex database and data management responsibilities
• 5-7 years of increasingly complex experience in quantifying, measuring, and analyzing financial/performance management metrics
• Demonstrate Healthcare experience in Quantifying, Measuring and Analyzing Financial and Utilization Metrics of Healthcare
• Advanced knowledge of SQL
• Proficient in Excel and visualization tools such as Power BI, Tableau, or similar

Preferred Education

• Bachelor's Degree in Finance, Economics, Math, or Computer Science

Preferred Experience

Preferred experience in Medical Economics and Strong Knowledge of Performance Indicators:

• Preferred experience in Medical Economics and Strong Knowledge of Performance Indicators:
• Proactively identify and investigate complex suspect areas regarding risk adjustment initiatives, risk score lift, conditions captured, and program value
• Initiate in-depth analysis of the suspect/problem areas and suggest a corrective action plan
• Apply investigative skill and analytical methods to look behind the numbers, assess business impacts, and make recommendations through use of healthcare analytics, predictive modeling, etc.
• Analysis and forecasting of program value and underlying population trends in risk adjustment to provide analytic support for finance, pricing and actuarial functions
• Healthcare Analyst I or Financial/Accounting Analyst I experience desired
• Multiple data systems and models
• Data modelling and BI tools

To all current Molina employees: If you are interested in applying for this position, please apply through the intranet job listing.

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

Pay Range: $77,969 - $155,508 / ANNUAL
*Actual compensation may vary from posting based on geographic location, work experience, education and/or skill level.