Senior Data Engineer

The Site Connect delivery data engineers are masters of data ETL. We create and maintain integrations for over 70+ EHR’s powering every patient use case you can think of. Our team is full of go getters that work in a matrixed 100% remote environment on agile teams that support customers from go live to support for the live of the integration.

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/ETL 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

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
Experience with using AWS