Senior Healthcare Data Analyst, Analytics Hub - ECG Management Consultants

ECG, the most experienced healthcare consulting firm working in the U.S., is ranked as a Best Small Firm to Work For 2024 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 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.

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. The goal of the position is to further capitalize on the existing ECG infrastructure, as well as implement new features and technologies. The ideal candidate is open to new challenges, exceptional at multitasking, and proficient at implementing new solutions.

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 data sets, 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:

• 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

Our Expectations of You

• Strong knowledge of and passion for the healthcare industry
• A bachelor’s degree in either computer science, computer engineering, mathematics, statistics, health information management, health administration, business, or a related degree that relies heavily on critical thinking, logic, and math
• Five years of healthcare data analytics work experience using databases, SQL, and Power BI required
• Prior experience in healthcare consulting preferred
• Experience using Python, R, Fabric, and Tableau
• Proficiency in Microsoft Word, Excel, and PowerPoint
• Comfort with manipulating and synthesizing large data sets
• Strong written and verbal communication skills
• Excellent organizational skills

Job Locations

Chicago, Seattle, and Washington, DC. This position has in-office responsibilities. Must be able to work a hybrid schedule with days in the office and days remote.

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 $100,000 - $130,000 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, unlimited PTO, and other wellness programs.

About ECG

With knowledge and expertise built over the course of 50-plus years, ECG is a national consulting firm that is redefining healthcare together with its clients. ECG offers a broad range of strategic, financial, operational, and technology-related consulting services. ECG is an industry leader, offering specialized expertise to hospitals, health systems, medical groups, academic medical centers, children’s hospitals, ambulatory surgery centers, investors, and payers/health plans. As an affiliated partner of Siemens Healthineers, ECG’s subject matter experts have a proven track record of delivering results fueled by top talent and technology. ECG’s national presence includes offices in Atlanta, Boston, Chicago, Dallas, Minneapolis, San Diego, Seattle, St. Louis, and Washington, DC.

Apply now and make an impact for years to come.

To begin the recruitment process, please submit your resume via our career site at https://careers.ecgmc.com.

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. People of color are encouraged to apply. 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.

#LI-SC1 #LI-Hybrid