Data Analyst III – Medical Economics

Bright Vision Technologies • Flossmoor, IL

3d

About The Position

We are seeking a highly skilled Data Analyst III – Medical Economics to support our growing Medical Economics team. This role focuses on analyzing complex healthcare datasets to generate actionable insights that reduce cost of care and improve clinical outcomes for members. The ideal candidate brings strong managed care analytics experience, deep knowledge of healthcare payment methodologies, and advanced analytical skills.

Requirements

• Bachelor’s degree in business, economics, statistics, mathematics, actuarial science, public health, health informatics, healthcare administration, finance, or related field, or equivalent experience
• 4+ years of experience working with large datasets, data validation, and data management
• Without a Bachelor’s degree: 8+ years of relevant experience required
• Experience in Managed Care Analytics / Medical Economics
• Hands-on experience with Medicare, Medicaid, and Marketplace analytics
• Strong SQL skills, including complex queries and multiple JOINs
• Advanced Excel skills: Pivot Tables, Power Query VLOOKUP / XLOOKUP Nested formulas, aggregations, and financial modeling
• Power BI experience, including DAX and Power Pivot
• Strong understanding of healthcare payment methodologies: DRG APC EAPG
• Experience with financial analytics tools and basic financial modeling

Nice To Haves

• Master’s degree
• Experience with Python and/or R
• Exposure to actuarial work or healthcare consulting
• Knowledge of MLR (Medical Loss Ratio), QAI (Quality and Affordability Initiatives), and healthcare KPIs
• Experience in claims pricing, contract/network analysis, ROI evaluation, or utilization management

Responsibilities

• Analyze large, integrated healthcare datasets including claims, provider, member, and encounter data
• Identify trends, assess business impact, and deliver insights to support cost and quality initiatives
• Develop, maintain, and troubleshoot complex analytical scripts and reports using SQL, Excel, and BI tools
• Support large-scale analytics projects with minimal supervision and limited leadership direction
• Perform root-cause analysis on data anomalies and recommend corrective actions
• Design, test, and implement process improvements and automation opportunities
• Collaborate cross-functionally to evaluate QAI, MLR, and KPI performance
• Translate complex analytical findings into clear, data-driven recommendations for non-technical stakeholders
• Manage multiple concurrent priorities while meeting tight timelines in a dynamic environment
• Provide technical guidance and mentorship to junior analysts

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level