Director of Data Architecture & Engineering

Hartford HealthCare; Farmington (CT); On-site; USD 180,000 - 240,000; Full time

Benefits offered by this job

Competitive benefits

Job summary

Hartford HealthCare seeks a Director of Data Architecture and Engineering to lead the data engineering and architecture functions within the ITS Data and Digital department. The role focuses on delivering enterprise curated data solutions to empower Hartford HealthCare’s enterprise-wide data and AI platform (H2D2) and to drive business value and customer success.

The Director will build, mentor, and lead a team of data engineers, architects, and ETL developers responsible for developing

Qualifications

• Bachelor’s degree in Computer Science, Engineering, Mathematics, or related quantitative field is required.
• Five plus years leading high functioning and productive data engineering and/or data architecture teams.
• Seven plus years of hands‑on experience in data software development including applications running on premise and/or cloud environments (GCP, AWS or Azure).
• Five plus 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.
• Seven plus years of experience with specialized data architecture (e.g., data lake, lake house, data fabric, data mesh).
• Extensive experience using ETL tools (Microsoft SQL Server Integration Services, Google Cloud Dataflow, Informatica PowerCenter, Oracle Data Integrator, etc.).
• Extensive experience with multiple programming languages (Python, C/C++, SQL, etc.).
• ETL design & 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.
• Strong analytical, organizational and problem-solving skills.
• Strong communications skills required - both written and verbal.

Responsibilities

• Develop, implement and continuously enhance a Digital Data Lake-house that ingests data from multiple sources to create a unified system for unstructured, semi-structured, and structured data
• Design, develop, construct, test, and maintain Data Lake-house pipelines, architectures, and large-scale data processing systems that accelerate HHC’s data and digital strategies
• Build, lead, mentor, upskill and guide data engineers, architects and ETL developers by leading code reviews, documenting and implementing best practices
• Partner with integrated platform (ITS infrastructure and operations) and data teams to define integrated solutions that meet evolving needs of data analysts, developers and consumers
• Develop and implement a documentation strategy that creates, maintains, and publishes data dictionaries, entity diagrams, relational/schema diagrams, technical documentation, runbooks, and standards

Skills

Data architecture

Leadership

ETL tools

Python

SQL

Cloud environments

Data modeling

Analytics

Communication skills

Problem solving

Education

Bachelor's degree in Computer Science, Engineering, Mathematics, or related quantitative field

Tools

SQL Server Integration Services

Google Cloud Dataflow

Informatica PowerCenter

Oracle Data Integrator

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.

Hartford HealthCare is transforming healthcare across Connecticut and beyond—enhancing access, affordability, health equity, and excellence. Spanning 500 locations across 185 towns and cities, our comprehensive care-delivery system is built to serve every community, every day. From world-class hospitals—including two tertiary-level teaching hospitals, an acute-care community teaching hospital, an acute-care hospital and trauma center, and three community hospitals—to an expansive network of behavioral health services, multispecialty physician groups, urgent and virtual care, surgery centers, home care, senior care, rehabilitation, and mobile neighborhood health programs, Hartford HealthCare is there when and where it matters most. We touch the lives of nearly 28,000 people every single day, delivering unparalleled care through our unique Institute Model—bringing together leading experts in neuroscience, cancer, digestive health, heart and vascular care, orthopedics, and urology & kidney health to provide a unified, high standard of care at the most affordable cost.

Position Summary

The Director of Data Architecture and Engineering is a hands-on technical leader who will lead the data engineering and architecture functions within the ITS Data and Digital department. The Director will be responsible for delivering enterprise curated data solutions that enable Hartford Healthcare’s enterprise-wide data and AI platform (H2D2) to drive business value and customer success. The Director will build, mentor, and lead a team of data engineers, architects and ETL developers who will develop analytical data solutions (On premises and Cloud) to help drive operations, clinical care, research, and human experience and lead the organizational development and implementation of data ingestion, data transformation, data management, data quality, and data lineage strategies.

Key Accountabilities

• Develop, implement and continuously enhance a Digital Data Lake-house that ingests data from multiple sources to create a unified system for unstructured, semi-structured, and structured data
• Design, develop, construct, test, and maintain Data Lake-house pipelines, architectures, and large-scale data processing systems that accelerate HHC’s data and digital strategies
• Build, lead, mentor, upskill and guide data engineers, architects and ETL developers by leading code reviews, documenting and implementing best practices
• Partner with integrated platform (ITS infrastructure and operations) and data teams (data governance, interoperability, reporting, research informatics, data science, analytics etc.) to define integrated solutions that meet the evolving needs of data analysts, developers and consumers (e.g. data ingestion framework, AI/ML capabilities, scalable compute), contributing to the innovation and leadership of the data organization
• Develop and implement a documentation strategy that creates, maintains, and publishes data dictionaries, entity diagrams, relational/schema diagrams, technical documentation, runbooks, and standards

Qualifications

• Bachelor’s degree in Computer Science, Engineering, Mathematics, or related quantitative field is required
• Five plus years leading high functioning and productive data engineering and/or data architecture teams
• Seven plus years of hands‑on experience in data software development including applications running on premise and/or cloud environments (GCP, AWS or Azure)
• Five plus 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
• Seven plus years of experience with specialized data architecture (e.g., data lake, lake house, data fabric, data mesh)
• Extensive experience using ETL tools (Microsoft SQL Server Integration Services, Google Cloud Dataflow, informatica power center, Oracle Data Integrator. ETC)
• Extensive experience with multiple programming languages (Python, C/C++, SQL etc.)
• Extensive experience in ETL design & 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
• Highly effective analytical, organizational and problem‑solving skills
• Strong communications skills required - both written and verbal

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.