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