Analytics Solutions Lead, Analytics Hub

Join to apply for the Analytics Solutions Lead, Analytics Hub role at ECG Management Consultants

ECG, the most experienced healthcare consulting firm working in the U.S., is ranked as a Best Midsized Firm to Work For 2025 by Consulting Magazine. At ECG, our primary emphasis is on quality—in our people as well as our services—and we’re seeking others who embrace our high standards of excellence.

At ECG, your contribution will have meaningful impact. The work you do will ultimately help health systems optimize performance and meet the needs of the communities they serve—and that’s just the beginning. We’re looking for team players, culture builders, problem-solvers, and self-starters to collaborate, take on challenging projects, and find new ways to make a positive impact in the healthcare services sector.

ECG is committed to ensuring a supportive, inclusive, and equitable work environment that embraces DEI, where we recognize performance, communicate openly and transparently, and value work-life balance.

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. ECG uses a Microsoft Azure and Microsoft 365 environment, with Microsoft Power BI as ECG’s current analytics visualization platform.

The goal of the position is to further capitalize on the existing ECG infrastructure, as well as implement new features and technologies.

• Position themselves for value-based care delivery.
• Align hospitals and physician organizations.
• Strengthen financial performance.
• Enhance clinical programs.
• Develop strategic partnerships and/or mergers.

As an analytics solutions lead at ECG, you will support the firm’s client delivery and business development efforts, working with consultants and senior leaders to manage large data sets, aggregate internal and external data, develop scalable models and other analyses, and support data visualization and presentation sets. You will also work directly with our internal support teams and associated vendors for data management and IT solutions, and will assist with a range of innovative analytic opportunities.

• Leading the development, management, and growth of a portfolio of analytic solutions designed to accelerate the time to insight.
• Engaging with stakeholders and managing the process of rendering analytic solutions; managing prioritization and ensuring deadlines are met.
• Being a subject matter expert on data domains and their application in healthcare.
• Managing and mentoring junior data analysts through the analytics delivery process.
• Gathering and synthesizing data from various sources.
• Preparing analyses related to hospital inpatient databases and provider claims data.
• Building flexible, dynamic, and scalable financial and operational models to forecast trends.
• Enhancing existing models and capabilities built using SQL, with some use of Python or R.
• Performing complex analyses on big data, including cleaning, preparing, and interpreting.
• Identifying and executing analyses in response to consultant business intelligence inquiries.
• Building relational databases using Microsoft SQL Server or Fabric.
• Communicating market insights to sales teams and supporting business development efforts.
• Intaking, configuring, maintaining, and building flexible reports, queries, and visuals within Power BI.
• Leading research, testing, and implementation of solutions in Power BI.
• Designing Microsoft Power App frameworks to facilitate end-user experience.
• Partnering with consulting divisions to gather requirements related to data analytics.
• Developing, configuring, and maintaining interfaces to exchange data among Power BI, SQL databases, and cloud-based applications.
• Creating and maintaining analytic support documentation and operating procedures.
• Developing new and innovative…