Senior Healthcare Data Analyst, Analytics Hub

About the role

ECG is a national healthcare consulting firm with over 50 years of experience, ranked as a Best Midsized Firm to Work For 2026. The Analytics Hub supports consulting teams by delivering insights, streamlined analysis, and visualizations using Microsoft Azure, Microsoft 365, and Power BI. As a Senior Data Analyst, you will work with consultants and senior leaders to manage large datasets, develop scalable models, support data visualization, and partner with internal teams to drive data‑driven solutions for healthcare clients.

Responsibilities

• Gather and synthesize data from various sources (national surveys, proprietary research, client interviews, industries, markets).
• Prepare analyses related to hospital inpatient databases and provider claims data.
• Build flexible, dynamic, and scalable financial and operational models to forecast trends and prepare scenarios for consulting efforts (strategic planning, operational improvement, market assessments).
• Enhance existing models and capabilities built using SQL, with some use of Python or R.
• Perform complex analyses on big data, including cleaning, preparing, and interpreting.
• Identify and execute analyses in response to consultant business intelligence inquiries.
• Build relational databases using Microsoft SQL Server or Fabric.
• Communicate market insights to pursuit teams and support business development efforts.
• Configure, maintain, and build flexible reports, queries, and visuals within Power BI and related database environments.
• Research, test, and implement solutions in Power BI.
• Partner with consulting units (Strategy & Enterprise Growth, Payer Strategy & Contracting, Health System Performance, Medical Group Optimization) to gather analytics requirements.
• Develop, configure, and maintain interfaces to exchange data among Power BI, SQL databases, and other cloud‑based applications.
• Create and maintain analytical support documentation and operating procedures.
• Develop new and innovative methodologies and approaches.
• Contribute to internal education and learning opportunities for consultants and operations members regarding the Analytics Hub and analytics in general.
• Assist the vice president of data analytics and AI in developing analytics and data strategy to support firm‑wide capabilities.

Qualifications

• Strong knowledge of and passion for the healthcare industry.
• Bachelor’s degree in computer science, computer engineering, mathematics, statistics, health information management, or a related field emphasizing critical thinking, logic, and math.
• 5+ years of experience in healthcare data analytics, including analyzing clinical, operational, financial, or population health data.
• Experience in healthcare consulting, healthcare technology, or working for a hospital/health system using data to deliver actionable insights.
• Strong proficiency in data analysis, reporting, dashboard development, and translating complex data into actionable business insights.
• Experience with healthcare datasets such as claims, EHRs, patient outcomes, quality metrics, or value‑based care programs is highly preferred.
• Advanced skills in SQL and data visualization tools (e.g., Tableau, Power BI); experience with Python, R, Databricks, or Azure is a plus.
• Proficiency in Microsoft Word, Excel, and PowerPoint.
• Strong written and verbal communication skills.
• Excellent organizational skills.

Pay

The estimated base salary range is $100,000.00 – $130,000.00 annually. The role is eligible for ECG’s annual incentive compensation program (pay‑for‑performance).

Benefits

• Medical, dental, and vision coverage.
• 401(k) matching program.
• Unlimited PTO.
• Other wellness programs.

Schedule

Full‑time, exempt position.

Job locations: Preferred – Chicago or Washington, DC; other – Boston.