Apply on Employer Site

ECG Management Consultants · 1 day ago

Healthcare Senior Data Engineer, Analytics Hub

Arlington, VA

Full-time

Hybrid

Senior Level

$130K/yr - $160K/yr

5+ years exp

ECG Management Consultants is a leading healthcare consulting firm focused on delivering quality and impactful services. The Senior Data Engineer will support client delivery and business development by designing and maintaining an analytical infrastructure, managing large data sets, and developing solutions to enhance data products and services in the healthcare sector.

Health CareHospital

No H1B

Responsibilities

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

Qualification

Data engineeringSQL databasesMicrosoft AzureData warehousingPythonData integrationData transformationAPI data extractionRJavaScalaApache SparkApache HadoopPower BITableauData hygieneCommunication skillsOrganizational skills

Required

A bachelor's degree in either computer science or computer engineering, or a related degree that relies heavily on critical thinking, logic, and math

Five-plus years of proven experience in data engineering, with a strong track record of designing and implementing data solutions

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

Comfort in unit testing, regression testing, and other test-driven development methodologies

Comfort with manipulating and synthesizing large data sets

Strong written and verbal communication skills

Excellent organizational skills