Data Engineer / ITS Data Governance

Hartford HealthCare; Farmington (CT); On-site; USD 100,000 - 140,000; Full time

Job summary

Hartford HealthCare is seeking a Data Engineer to design, build, deploy, and support enterprise data solutions for analytics, AI/ML, and governance across H2D2. You will architect scalable data pipelines, enable data quality controls, and collaborate with governance and architecture teams.

The role emphasizes integrating MDM/RDM, metadata, and lineage into a robust data fabric across on-prem and cloud environments, supporting clinical and research data standards.

Qualifications

• 2+ years of hands-on experience in data software development including on-prem and cloud (GCP, AWS or Azure).
• Experience implementing automated data-quality profiling, validation, reconciliation, monitoring, and exception-management controls.
• Working knowledge of data governance concepts, including metadata management, technical lineage, data classification, stewardship, and policy enforcement.
• Experience integrating governance controls into cloud data pipelines, lakehouse architectures, or enterprise data platforms.
• 2+ years building data and digital platforms for batch or streaming ingestion, processing analytics, storing in various stages.
• Extensive experience with multiple programming languages (Python, C/C++, SQL, etc.).
• 2+ years of ETL design and data modeling implementation, and maintenance.
• Proactive, self-motivated with continuous learning and staying updated with best practices and technologies.
• 2+ years experience with specialized data architectures (data lake, lake house, data fabric, data mesh).
• Preferred: 3+ years of cloud-native development; GCP preferred.
• Experience with enterprise MDM and RDM platforms, including matching, survivorship, hierarchy, crosswalk, and reference-code management.
• Experience with metadata catalog, lineage, or data-quality platforms; Informatica CDGC, Cloud Data Quality, or MDM experience preferred.
• Healthcare data experience involving Epic, FHIR, HL7, OMOP, clinical terminology, or other governed clinical and research data standards.
• 3+ years of experience in data software development that includes building data and digital platforms.
• Understanding of FHIR and HL7 standards and clinical documentation architecture.
• 3+ years of Experience with specialized data architecture

Responsibilities

• Design, develop, test, deploy, and operate automated, scalable data pipelines for batch, streaming, and near-real-time workloads. Implement ingestion, transformation, orchestration, observability, and recovery patterns.
• Monitor and troubleshoot pipeline performance, resolve bottlenecks, and automate controls that protect data quality, security, integrity, availability, and maintainability.
• Provide data-engineering support for the enterprise Data Governance program. Build automated data-quality rules, profiling, validation, reconciliation, exception management, and monitoring capabilities; publish results and remediate defects with data owners.
• Engineer and support MDM and RDM capabilities, including source integration, matching, survivorship logic, hierarchy and crosswalk management, reference-code synchronization, data-standard enforcement, and distribution to downstream consumers.
• Partner with data architects, Data Governance Office, interoperability, analytics, security, and other teams to embed governance into the H2D2 fabric. Implement metadata capture, lineage, classification, ownership and stewardship attributes, access and retention controls, and policy-as-code across data layers.
• Create and maintain technical documentation: source-to-target mappings, data dictionaries, models, lineage, interface specs, data-quality rules, runbooks, and support docs; keep metadata synchronized with deployed solutions.
• Contribute to software engineering, data engineering, data architecture, DevSecOps, and governance standards; participate in design/code reviews, promote reusable patterns, automated testing, and a culture of accountability and innovation.

Skills

Python

C/C++

SQL

Data governance

MDM

RDM

Metadata management

Data quality

Education

Bachelor's degree in computer science, engineering, mathematics, or related quantitative field

Master’s degree in healthcare administration, computer sciences or related field

Tools

GCP

AWS

Azure

Informatica CDGC

Job description

Location Detail: 9 Farm Springs Rd Farmington (10566)

Work where every moment matters.

Every day, more than 40,000 Hartford HealthCare colleagues come to work with one thing in common: Pride in what we do, knowing every moment matters here. We invite you to become part of Connecticut's most comprehensive healthcare network.

The creation of the HHC System Support Office recognizes the work of a large and growing group of employees whose responsibilities are continually evolving so that we and our departments now work on behalf of the system as a whole, rather than a single member organization.

With the creation of our new umbrella organization we now have our own identity with a unique payroll, benefits, performance management system, service recognition programs and other common practices across the system.

Position Summary

As a Data Engineer, you will design, build, deploy, and support enterprise data solutions that capture, integrate, transform, govern, and make data available for analytics, AI/ML, generative AI, operational reporting, research, and other enterprise use cases. The Data Engineer will help architect, implement, and operate robust, scalable data infrastructure across on-premises and cloud environments, with a primary focus on Hartford HealthCare's enterprise data and digital platform (H2D2). This role will also provide dedicated engineering support to the enterprise Data Governance program by implementing data-quality controls, master data management (MDM), reference data management (RDM), metadata, lineage, and governance requirements as reusable capabilities within the H2D2 data fabric.

Position Responsibilities

Key Areas of Responsibility

Design, develop, test, deploy, and operate automated, scalable data pipelines and reusable ingestion frameworks for batch, streaming, and near-real-time workloads. Implement incremental ingestion, transformation, orchestration, observability, error handling, and recovery patterns. Monitor and troubleshoot pipeline performance and reliability, resolve bottlenecks, and automate controls that protect the quality, security, integrity, availability, and maintainability of HHC data solutions.

Provide data-engineering support for the enterprise Data Governance program. Build and maintain automated data-quality rules, profiling, validation, reconciliation, exception management, and monitoring capabilities; publish measurable data-quality results; and partner with data owners and stewards to investigate root causes and remediate defects at the appropriate source or transformation layer.

Engineer and support master data management (MDM) and reference data management (RDM) capabilities, including source integration, matching and survivorship logic, hierarchy and crosswalk management, reference-code synchronization, data-standard enforcement, and distribution of trusted master and reference data to downstream consumers.

Partner with data architects, the Data Governance Office, interoperability, analytics, research, security, and other data-engineering teams to embed governance into the H2D2 fabric. Implement metadata capture, business and technical lineage, classification, ownership and stewardship attributes, access and retention controls, and policy-as-code or reusable control patterns across Bronze/Raw, Silver/Curated, and Gold/Governed data layers.

Create and maintain technical documentation, including source-to-target mappings, data dictionaries, logical and physical models, lineage, interface specifications, data-quality rules, operating procedures, runbooks, and support documentation. Ensure metadata and documentation remain synchronized with deployed solutions.

Contribute to software engineering, data engineering, data architecture, DevSecOps, and governance standards across the team and broader organization. Participate in design and code reviews, promote reusable patterns and automated testing, and support a culture of accountability, continuous improvement, innovation, and responsible data use.

Working Relationships

This Job Reports To (Job Title): Director Data Engineering and Architecture.

Qualifications

Education

• Minimum: bachelor’s degree in computer science, engineering, mathematics, or related quantitative field
• Preferred: Master’s degree in healthcare administration, computer sciences or related field

Experience

• Minimum:
• 2+ years of hands-on experience in data software development including applications running on premise and/or cloud environments (GCP, AWS or Azure)
• Experience implementing automated data-quality profiling, validation, reconciliation, monitoring, and exception-management controls.
• Working knowledge of data governance concepts, including metadata management, technical lineage, data classification, stewardship, and policy enforcement.
• Experience integrating governance controls into cloud data pipelines, lakehouse architectures, or enterprise data platforms.
• 2+ years of experience in data software development that includes building data and digital platforms for batch or streaming ingestion, processing the data for analytics, and storing the data in various stages
• Extensive experience multiple programming languages (Python, C/C++, SQL etc.)
• 2+ Years experience in ETL design and data modeling implementation, and maintenance.
• Proactive and self-motivated with a passion for continuous learning and staying updated with best practices, new features, and emerging technologies.
• 2+ years of Experience with specialized data architecture (e.g., data lake, lake house, data fabric, data mesh)
• Preferred:
• 3+ years of experience working with Cloud native development. GCP preferred.
• Experience with enterprise MDM and RDM platforms, including matching, survivorship, hierarchy, crosswalk, and reference-code management.
• Experience with metadata catalog, lineage, or data-quality platforms; Informatica CDGC, Cloud Data Quality, or MDM experience is preferred.
• Healthcare data experience involving Epic, FHIR, HL7, OMOP, clinical terminology, or other governed clinical and research data standards.
• 3+ years of experience in data software development that includes building data and digital platforms
• Understanding of FHIR and other Health Level 7 (HL7) communication standards and clinical documentation architecture.
• 3+ years of Experience with specialized data architecture

Knowledge, Skills And Ability Requirements

time and project management skills; demonstrated skills in verbal and written expression of ideas; in person and virtual presentation skills; good command and understanding of data engineering and architecture concepts.

We take great care of careers.

With locations around the state, Hartford HealthCare offers exciting opportunities for career development and growth. Here, you are part of an organization on the cutting edge - helping to bring new technologies, breakthrough treatments and community education to countless men, women and children. We know that a thriving organization starts with thriving employees-- we provide a competitive benefits program designed to ensure work/life balance. Every moment matters. And this is your moment.