Senior Healthcare Data Analyst, Analytics Hub

at  ECG Management Consultants

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

WHAT’S IN IT FOR YOU: WORK WITH PURPOSE

At ECG, you can have a bigger impact than you ever imagined. The work you do will ultimately help health systems deliver care more effectively and efficiently—and that’s just the beginning. We’re looking for innovators, problem-solvers, and self-starters to collaborate, take on challenging projects, and find new ways to improve processes. ECG is committed to ensuring a supportive work environment that embraces DEI, recognizes performance, communicates transparently, and values work/life balance.

YOUR RESPONSIBILITIES MAY INCLUDE:

• Gathering and synthesizing data from various sources (e.g., national surveys, proprietary research, client interviews, industries, markets)
• Preparing analyses related to hospital inpatient databases and provider claims data
• Building 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)
• Enhancing existing models and capabilities built using SQL, primarily, with some use of Python or R in certain models or scenarios
• 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 a Microsoft SQL Server or Fabric
• Communicating market insights to pursuit teams, and supporting business development efforts
• Configuring, maintaining, and building flexible reports, queries, and visuals within the Power BI environment and the production and development environments of related databases
• Researching, testing, and implementing solutions in Power BI
• Partnering with various consulting units (strategy, academic health, provider financial services, performance transformation, etc.) to gather requirements related to data analytics
• Developing, configuring, and maintaining interfaces to exchange data among Power BI, SQL databases, and other cloud-based applications
• Creating and maintaining analytical support documentation and operating procedures
• Developing new and innovative methodologies and approaches
• Contributing to internal education and learning opportunities for consultants and operations members for the Analytics Hub and analytics in general, and supporting education about ECG’s use cases related to analytics in work
• Assisting the director of data analytics in developing analytics and data strategy to support data analytics capabilities at the firm