Healthcare Senior Data Engineer, Analytics Hub

ECG is a national management consulting firm working exclusively in the healthcare industry. 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: Consult with Purpose

At ECG, you can have a bigger impact than you ever imagined. The work you do will 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 across our five divisions, take on challenging projects, and find new ways to improve patient care. ECG is committed to ensuring a friendly work environment that rewards high performance and welcomes, values, and supports all people.

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 Engineer

As a Senior Data Engineer, you will support the firm’s client delivery and business development efforts, working with consultants and senior leaders to design and maintain a growing analytical infrastructure, manage large data sets, aggregate internal and external data, develop the infrastructure for scalable models and other analyses, and support data visualization and presentation sets. In addition, you will work directly with our internal support teams (IT, business development, and L&D) and associated vendors for data management and IT solutions, and you 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).
• Designing, developing, and maintaining new data capabilities and infrastructure for utilizing ECG, third-party, and partner data to enhance ECG’s data products and solutions related to consulting services.
• Creating new data pipelines, data transfers, and infrastructure to facilitate seamless data utilization within cloud environments (primarily Microsoft Azure).
• Optimizing and fine-tuning data pipelines for improved speed, reliability, and efficiency.
• Creating and supporting the ETL to facilitate the accommodation of data in the data lakes.
• Designing and developing systems for the maintenance of ECG’s EDW and data lakes, ETL processes, and business intelligence.
• Identifying existing data capability and infrastructure gaps or opportunities within and across initiatives and providing subject matter expertise in support of remediation.
• Collaborating with the Analytics Hub peers, IT team, and consulting teams to understand data requirements and translate them into technical solutions.
• Working with large data sets, ensuring data quality, accuracy, and performance.
• Implementing data transformation, integration, and validation processes to support analytics and reporting needs.
• Implementing best practices for data storage, retrieval, and archival to ensure data accessibility and security.
• Troubleshooting and resolving data-related issues, collaborating with the team to identify root causes.
• Documenting data processes, data lineage, and technical specifications for future reference.
• Participating in code reviews, ensuring adherence to coding standards and best practices.
• Collaborating with the Analytics Hub and IT teams to automate deployment and monitoring of data pipelines.
• Integrating into analytical roles to quickly and effectively dissect business requirements for analysis and reporting needs; establishing documentation and maintaining technical specifications for all reports and processes.
• Building relational databases using a Microsoft SQL Server or Microsoft Fabric.
• Communicating market insights to pursuit teams and supporting business development efforts.
• Partnering with various consulting units (strategy, academic healthcare, provider financial services, performance transformation, etc.) to gather requirements related to data analytics.
• Developing, configuring, and maintaining interfaces to exchange data among Microsoft Power BI, SQL databases, and other cloud-based applications.
• 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

• A bachelor’s degree in either computer science or computer engineering, or a related degree that relies heavily on critical thinking, logic, and math; a master’s degree or PhD a plus
• Five-plus years of proven experience in Data Engineering, with a strong track record of designing and implementing data solutions; experience working in the healthcare sector preferred
• Strong knowledge of SQL and NoSQL databases, as well as data integration and transformation tools
• Proficiency in programming languages, such as Python, R, Java, or Scala, and experience with data processing frameworks (Apache Spark, Apache Hadoop, etc.)
• Experience using Fabric
• In-depth understanding of data warehousing concepts, cloud platforms (AWS, Azure, GCP), and data modeling techniques
• A passion for and engagement with emerging trends in data, AI/ML, analytics, and digital experiences
• Extensive working knowledge of API- or stream-based data extraction processes like bulk API
• Experience in data product development, analytical models, and model governance
• Experience in anonymizing data and managing the use of data
• Experience in data hygiene procedures, identity resolution capabilities, or data management a plus
• Comfort in unit testing, regression testing, and other test-driven development methodologies
• Knowledge of BI tools and visualization tools like Power BI or Tableau a plus
• Comfort with manipulating and synthesizing large data sets
• Strong written and verbal communication skills
• Excellent organizational skills 

Job Locations

St.  Louis and Washington, DC, offices are preferred. Other offices may include Atlanta, Boston, Chicago, Minneapolis, San Diego, or Seattle. Able to work a hybrid schedule with days in the office and 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.

About ECG

ECG is a strategic consulting firm leading healthcare forward using knowledge and expertise built over the course of five decades to help clients see clearly where the industry is going and navigate toward success. We work as trusted, professional partners with hospitals, health systems, medical groups, and academic medical centers across the country. We thrive on delivering smart counsel and pragmatic solutions to the critical challenges facing healthcare providers. Client success is our primary objective. 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. Residents of the states of California or Washington may receive salary information for this job through this link or by contacting the recruiter directly at schavez@ecgmc.com.

#LI-SC1 #LI-Hybrid