Data Analyst – BI
LetsGetChecked
PythonSQL
Risk Adjustment Data Analyst
Honest Medical Group
full-time
Posted on:
Location Type: Remote
Location: Remote • 🇺🇸 United States
Visit company websiteSalary
💰 $76,600 - $88,000 per year
Job Level
Mid-LevelSenior
Tech Stack
SQLTableau
About the role
- Develop and maintain data processes and analytics related to the Centers for Medicare & Medicaid Services (CMS) -Hierarchical Condition Categories (HCC) risk adjustment model for the Medicare population
- Ensure that risk scores are accurately calculated and all updates from CMS are applied to the CMS HCC Risk Adjustment model
- Use a suite of tools to implement risk score calculation, develop actionable insights, develop risk score forecasts, and create dashboards/reporting, and optimize existing processes
- Calculate risk scores for each Honest member using CMS HCC risk adjustment model and maintain model to account for any changes made by CMS
- Develop SQL processes to automate risk score runs that integrate data from a multitude of datasets
- Evaluate project performance and identify value drivers for risk adjustment initiatives and programs
- Develop processes to calculate and automate key performance indicator (KPI)’s specific to risk adjustment as well as effectively communicate KPI’s to internal stakeholders
- Work closely with internal teams (Actuarial, Health Economics, and Finance) to provide data and insights necessary for financial forecasts and projections
- Build risk adjustment dashboards and automated reporting in Tableau for internal and external stakeholders
- Work closely with performance management and reporting teams to provide data and reporting necessary for practice and provider scorecards
- Perform other related responsibilities as assigned
Requirements
- Bachelor's degree in analytics, computer science, engineering, economics, or a related quantitative field required
- Master’s degree in analytics or computer science is considered a plus
- Advanced data manipulation skills with 3+ years of SQL experience
- 3+ years of data analytics experience delivering actionable insights
- Advanced MS Excel skills with 3+ years of experience
- Experience working with large healthcare datasets strongly preferred
- Experience using data visualization software (Tableau or Power BI) to build automated reporting and dashboards
- Medicare and/or Risk Adjustment experience/knowledge preferred
- Excellent analytical, planning, organization, and problem-solving skills with the ability to clearly communicate complex ideas
- Ability to effectively multitask in a dynamic and fast-paced environment
Benefits
- Attractive base salary with performance-based bonuses and rewards
- 401(k) plan with a generous company match, fully vested from day one
- Flexible health, dental, and vision insurance options tailored to your needs
- Company contribution towards health savings accounts (HSA) for high-deductible health plan (HDHP) participants
- 100% company-paid short-term disability and life insurance
- Wellness programs and resources to support your physical and mental health
- Generous paid time off, including vacation, sick leave, and paid holidays annually
- Two paid volunteer days to support causes you're passionate about
- Flexible work arrangements to accommodate your lifestyle
- Robust onboarding program and ongoing training opportunities
- Reimbursement for role-related continuing education and certifications
- Paid parental leave for new parents
- Dependent care flexible spending accounts
- Support for work-life integration
- Work alongside professionals who share your commitment to Honest's high-quality, value-based care model
- Opportunities to contribute to meaningful projects and initiatives
- Team member recognition programs
- Team-building events and social activities
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SQLdata manipulationdata analyticsKPI calculationrisk score calculationdata forecastingdata integrationautomated reportingdata visualizationdashboard development
Soft skills
analytical skillsplanning skillsorganizational skillsproblem-solving skillscommunication skillsmultitasking ability
