Senior Data Engineer

$120,000 - $160,000/Yr

Datavant - State College, PA

Full-time

Remote - State College, PA

Publishing Industries

About the position

The Site Connect delivery data engineer at Datavant plays a crucial role in creating and maintaining data integration processes for healthcare organizations. This position focuses on developing ELT/ETL processes, collaborating with various teams to understand data requirements, and ensuring the quality and accuracy of data models. The role is integral to supporting the company's mission of securely moving and connecting healthcare data across a vast network of partners and systems.

Responsibilities

• Create and maintain ELT/ETL processes for existing and new systems.
• Collaborate with development and business teams to understand requirements and define source system data flows.
• Develop and maintain ETL/ELT specifications for data integration development.
• Define and deliver consistent data modeling and data architecture standards, methodologies, guidelines, and techniques.
• Document, implement, and maintain the data pipeline architecture and related business processes.
• Serve as a source of knowledge of industry practices and processes.
• Participate in the development of enterprise standards and guidelines for data model quality and accuracy.
• Audit project level data model quality deliverables to ensure that practices and standards are met.
• Analyze information and data requirements and understand effects of data inconsistencies.
• Identify inefficiencies in current architecture and processes and communicate solutions in a manner that gets support from the teams involved.
• Perform cost and sizing estimates for projects.
• Collaborate with the project coordinator and the rest of the agile team to identify epics, stories, and estimate effort.
• Create and maintain data dictionary documents, table and data lineage models, and produce artifacts to support project development and communicate project information to customers.

Requirements

• Bachelors in Computer Science or other engineering degree equivalent.
• 5+ years of hands-on experience in building Data pipeline (ETL/ELT) in a cloud platform.
• 5+ years of experience with relational DBMS, SQL Server/T-SQL, stored procedures, functions, including experience optimizing database performance using T-SQL and PL/SQL for efficient data retrieval.
• 5+ years of experience with Python.

Nice-to-haves

• Healthcare data experience 2+ years.
• Knowledge of clinical systems (e.g. Cerner, Epic, Meditech, etc.) and standard Acute/Ambulatory workflows.
• Preferred AWS Cloud Practitioner or above certification.

Benefits

• Competitive salary range of $120,000 - $160,000 based on experience and skills.
• Remote-first work environment that allows flexibility in shaping the working environment.
• Commitment to diversity and inclusion in the workplace.