Senior Healthcare Data Analyst, Analytics Hub

ECG Management Consultants•Boston, MA

4d•Hybrid

About The Position

ECG, a national consulting firm with over 50 years of experience in healthcare, is seeking individuals to join its growing Analytics Hub. The Analytics Hub collaborates with consulting teams to deliver insights, analysis, and intelligence to healthcare clients, aiding leadership in making informed decisions. ECG operates in a Microsoft Azure and Microsoft 365 environment, utilizing Microsoft Power BI for analytics visualization. The firm focuses on creating practical, tailored solutions for a wide range of healthcare organizations, including hospitals, health systems, medical groups, and payers. Their work involves strategic, financial, operational, and technology-enabled consulting services aimed at maximizing resources and achieving sustainable results. ECG values collaboration, integrity, and innovation, and is committed to fostering an inclusive and supportive work environment.

Requirements

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
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

Nice To Haves

Experience working with healthcare datasets such as claims, EHRs, patient outcomes, quality metrics, or value-based care programs is highly preferred

Responsibilities

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.