Senior Healthcare Data Analyst, Analytics Hub at ECG Management Consultants

ECG Management Consultants, Inc; Chicago (IL); On-site; USD 100,000 - 130,000; Full time

Job summary

ECG Management Consultants, Inc is seeking a Senior Data Analyst to support client delivery and business development. You will manage large datasets, build scalable models, and support data visualization with Power BI, collaborating with IT, L&D, and vendors.

You will work with multiple teams on data analytics use cases across healthcare providers, shaping insights that influence decision making.

Qualifications

• Bachelor’s degree in CS/CE/Math/Stats/Health informatics or related field.
• 5+ years of healthcare data analytics experience.
• Experience in healthcare consulting or with hospitals/health systems delivering actionable insights.
• Strong data analysis, reporting, and dashboard development skills.
• Experience with healthcare datasets such as claims and EHRs preferred.
• Advanced SQL and data visualization proficiency; Python/R a plus.

Responsibilities

• Gather and synthesize data from various sources for insights.
• Prepare analyses related to hospital inpatient databases and provider claims data.
• Build scalable financial and operational models to forecast trends and scenarios.
• Enhance models using SQL as primary tool; Python or R in some cases.
• Configure and maintain Power BI reports and visuals across environments.
• Develop interfaces to exchange data among Power BI, SQL databases, and cloud apps.
• Collaborate with multiple ECG units to gather data requirements for analytics.
• Create and maintain analytical documentation and procedures.

Skills

Healthcare analytics

Communication

SQL

Data visualization

Python

R

Education

Bachelor’s degree (CS/CE/Math/Stats/Health informatics)

Tools

Tableau

Power BI

Python

R

Databricks

Azure

SQL Server

Job description

This Full time on site position offers great opportunities for career growth.

Overview

With over 50 years of proven success, ECG, ranked as a Best Midsized Firm to Work For 2026 by Consulting Magazine, is the most experienced healthcare consulting firm in the US. Working exclusively in this space, our people consistently demonstrate their ability to solve challenges for providers and achieve better patient outcomes. Across our seven office locations, we’re seeking individuals who will show the courage to find innovative solutions and make a direct impact on the delivery of healthcare services nationwide.

About ECG

ECG is a national consulting firm that is redefining healthcare together with its clients. We provide a broad range of strategic, financial, operational, and technology-enabled consulting services to the full continuum of care, including hospitals, health systems, medical groups, academic medical centers, children’s hospitals, cancer centers, ambulatory surgery centers, investors, and payers/health plans. Our work focuses on creating practical, tailored solutions that help clients maximize resources and achieve sustainable results. We value collaboration, integrity, and innovation, and are committed to fostering an inclusive and supportive work environment.

Job Details

Join Our Analytics Hub Our growing Analytics Hub works with our consulting teams to deliver new insights, streamlined analysis, and world-class intelligence to the healthcare organizations we serve as clients. Combined with our consulting teams, you will be helping physician and executive leadership make informed decisions that can alter the course of their enterprises in areas such as physician alignment, mergers and acquisitions, service line planning, provider compensation, financial performance, transforming care models, patient access, managed care portfolio optimization, digital health expansion, and more.

ECG uses a Microsoft Azure and Microsoft 365 environment, with Microsoft Power BI as ECG’s current analytics visualization platform. Our detailed plans incorporate qualitative findings with data-driven strategic, operational, and financial considerations that enable organizations to pursue realistic change. Our consultants bridge the gap between strategic thinking and operational implementation with sensible action plans and tactical recommendations. This approach allows us to stretch our clients’ thinking while ensuring that initiatives with the broadest and deepest impact are prioritized and implementable. Our wide-ranging engagements often focus on helping our clients: Position themselves for value-based care delivery. Align hospitals and physician organizations. Strengthen financial performance. Enhance clinical programs. Develop strategic partnerships and/or mergers.

Your Opportunity with ECG

Senior Data Analyst As a senior data analyst, you will support the firm’s client delivery and business development efforts, working with consultants and senior leaders to manage large datasets, aggregate internal and external data, develop scalable models and other analyses, and support data visualization and presentation sets. In addition, the analyst will work directly with our internal support teams (IT, business development, and L&D) and associated vendors for data management and IT solutions and will assist with a range of innovative analytic opportunities. Here, no two days or projects are alike, which means you’ll have a lot to learn and plenty of support to help you succeed.

Your Responsibilities May Include

• Gather and synthesize data from various sources (e.g., 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, preparing scenarios for consulting efforts related to delivery and business development (e.g., strategic planning, operational improvement, market assessments).
• Enhance existing models and capabilities built using SQL, primarily, with some use of Python or R in certain models or scenarios.
• 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 a 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 the Power BI environment and the production and development environments of related databases.
• Research, test, and implement solutions in Power BI.
• Partner with various consulting units (Strategy & Enterprise Growth, Payer Strategy & Contracting, Health System Performance, and Medical Group Optimization) to gather requirements related to data analytics.
• 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 for the Analytics Hub and analytics in general, and support education about ECG’s use cases related to analytics.
• Assist the vice president of data analytics and AI in developing analytics and data strategy to support data analytics capabilities at the firm.

Qualifications

• Strong knowledge of and passion for the healthcare industry
• A bachelor’s degree in either computer science, computer engineering, mathematics, statistics, health information management, or a related degree that relies heavily on 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 or health system, using data to deliver actionable insights and recommendations
• Strong proficiency in data analysis, reporting, dashboard development, and translating complex data into actionable business insights
• Experience working 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

Job Locations

• Preferred locations: Chicago or Washington, DC
• Other location: Boston

Schedule Full time/exempt

What You Can Expect of Us To reward our driven, innovative, and passionate employees, we’ve built a company culture that’s centered on performance. We offer an attractive compensation package, challenging work, and an entrepreneurial environment where you can take ownership of your career—and get out as much as you put in.

The estimated base salary range for this job is $100000.00 - $130000.00 annually. It represents a good faith estimate of the range that ECG reasonably expects to pay at the time of the job posting. The actual salary paid will vary based on multiple factors, including but not limited to years of experience, special skills, and market changes.

This job is eligible to participate in ECG’s annual incentive compensation program, which reflects ECG’s pay-for-performance philosophy.

The job is also eligible to participate in ECG’s benefit plans, which include medical, dental, and vision coverage, a 401(k) matching program, unlimited PTO, and other wellness programs.

ECG provides equal employment opportunities to all employees and applicants for employment without regard to sex, race, color, religion, national origin, citizenship, ancestry, age, disability, pregnancy, medical condition (cancer and genetic characteristics), genetic information, gender, gender identity or expression, sexual orientation, marital status, military or veteran status, or any other legally protected characteristic.

We participate in E-Verify as part of our onboarding process.

Having the permanent legal right to work in the United States is a condition of employment.

ECG is not currently able to provide assistance to candidates requiring sponsorship or a visa.