Lead Data Engineer- Healthcare Interoperability

Verisma; United States; On-site; USD 150,000 - 180,000; Full time

Job summary

Verisma seeks an experienced Lead Data Engineer to design, build, and maintain Azure-based data infrastructure supporting BI, analytics, and healthcare interoperability. You will integrate with EHR systems using FHIR/C-CDA and ensure HIPAA/HITRUST compliance.

You will mentor engineers, lead data architecture discussions, and collaborate with cross-functional teams to deliver scalable data solutions and secure data pipelines across development to production environments.

Qualifications

• Bachelor's degree in computer science, information systems, data engineering, or related field.
• 8+ years of experience in data engineering, database development, or related roles.
• Expert-level proficiency in T-SQL and Microsoft SQL Server.
• Expert-level proficiency in Python.
• Experience building REST APIs and background workers in Python (FastAPI/Flask).
• Understanding of event-driven architectures and asynchronous processing.
• Strong experience with Azure data services (Azure SQL, Data Factory, Synapse, Blob Storage).
• Hands-on experience building and maintaining data pipelines and ETL/ELT processes.
• Knowledge of Power BI development skills including DAX, data modeling, and performance optimization.
• Solid understanding of database design principles, normalization, and data modeling.
• Experience with version control systems (Git) and CI/CD practices.
• Excellent communication and teamwork abilities.
• HIPAA/HITRUST compliance knowledge and healthcare data experience.
• Travel up to 15%.

Responsibilities

• Design and implement scalable data architectures on Azure for BI and analytics.
• Build and maintain data pipelines using Azure Data Factory and Synapse.
• Contribute to database designs across Azure SQL, PostgreSQL, CosmosDB.
• Optimize data storage across Azure Blob Storage and Data Lake.
• Design data models and structures for analytics and reporting.
• Develop and maintain stored procedures, functions, triggers, and views.
• Implement database DevOps, including schema versioning and deployment automation.
• Perform database performance tuning and indexing strategies.
• Ensure data integrity, security, and HIPAA/HITRUST compliance for PHI data.
• Manage database lifecycle across environments using RedGate Flyway.
• Design and implement ETL/ELT processes from multiple sources.
• Build event-driven processing with Azure Service Bus and Event Grid.
• Develop internal data APIs using Python (FastAPI/Flask) on Azure.
• Create data transformation logic and orchestration workflows.
• Ensure data quality, lineage, and governance across the platform.
• Collaborate with stakeholders to translate business requirements into solutions.
• Provide mentorship and contribute to best practices and architecture reviews.
• Participate in on-call rotation and support production incidents.

Skills

T-SQL

Python

REST APIs

Event-driven architectures

Azure data services

Data pipelines/ETL/ELT

Power BI development

Git / CI/CD

HIPAA/HITRUST compliance

OpenAPI/Swagger

Terraform / IaC

Azure DevOps

FHIR/HL7/HIE knowledge

EHR/EMR integrations

Education

Bachelor's degree in Computer Science / Information Systems / Data Engineering

Tools

Azure Data Factory

Azure Synapse

Azure SQL Database

SQL Managed Instance

PostgreSQL

CosmosDB

Azure Blob Storage

Data Lake

Power BI

RedGate Flyway

OpenAPI/Swagger

Terraform / IaC

Container Apps / Functions

Git

CI/CD tooling

Job description

We are seeking an experienced Lead Data Engineer to join our healthcare technology team with a primary focus on healthcare interoperability. This role will be instrumental in designing, building, and maintaining our Azure-based data infrastructure, including databases, data pipelines, analytics platforms, and business intelligence solutions - with an emphasis on integrating with Electronic Health Record (EHR) systems and healthcare data exchange standards (FHIR, C-CDA, HL7). The ideal candidate will have deep expertise in the Microsoft data stack, strong architectural thinking, and experience with healthcare data compliance requirements. This senior-level position will also provide technical leadership, mentorship to the broader engineering team and reports to the Director of Data Engineering.

Duties & Responsibilities

• Design and implement scalable, secure data architectures on Azure to support business intelligence, analytics, and operational systems
• Build and maintain data pipelines using Azure Data Factory, Azure Synapse and related services
• Contribute to database designs across multiple platforms (Azure SQL Database, SQL Managed Instance, PostgreSQL, CosmosDB)
• Optimize data storage strategies across Azure Blob Storage, Data Lake, and structured databases
• Design data models and structures that enable efficient analytics and reporting
• Design, develop, and maintain complex stored procedures, functions, triggers, and views
• Implement database DevOps processes including schema versioning, deployment automation, and rollback procedures
• Perform database performance tuning, indexing strategies, and query optimization
• Ensure data integrity, security, and compliance with HIPAA/HITRUST requirements for PHI data
• Manage database lifecycle across development, pre-production, and production environments utilizing RedGate Flyway
• Design and implement ETL/ELT processes to integrate data from multiple sources
• Build event-driven data processing solutions including message producers, consumers, and workers using Azure Service Bus, Event Grid, and related messaging services
• Integrate with external REST APIs for data ingestion and develop internal data APIs using Python (FastAPI/Flask) on Azure Container Apps or Functions
• Develop data transformation logic and orchestration workflows
• Ensure data quality, consistency, and lineage across the data platform
• Integrate with Azure AI services and machine learning endpoints as needed
• Review designs of Power BI solutions including semantic models, reports, & dashboards
• Collaborate with stakeholders to translate business requirements into technical solutions
• Optimize data structures for reporting and analytics performance
• Provide technical guidance and mentorship to junior developers and engineers
• Contribute to data engineering best practices, standards, and patterns
• Participate in architecture reviews and technical decision-making
• Collaborate with DevOps and Infrastructure teams on platform improvements
• Drive continuous improvement in data quality, performance, and reliability
• Create and maintain comprehensive technical documentation including data dictionaries, architecture diagrams, and process flows
• Document data lineage, transformation logic, and business rules
• Ensure all data handling practices meet HIPAA/HITRUST compliance requirements
• Maintain audit trails and documentation for compliance purposes
• Troubleshoot and resolve complex data-related issues across the platform
• Provide escalation support for production incidents
• Collaborate with cross-functional teams to support business operations
• Participate in on-call rotation as needed

Preferred

• Build and maintain integrations with EHR systems using FHIR resources (e.g., Patient, DocumentReference) and C-CDA document parsing/transformation
• Support HL7 v2/MDM/ADT message flows where needed, including message parsing and acknowledgment handling
• Define and maintain OpenAPI specifications and API versioning; write contract tests to prevent breaking changes
• Lead the document templating framework and server-side rendering pipeline for HTML-to-PDF output; ensure accessibility and compliance requirements

Required

Experience & Qualifications

• Bachelor's degree in computer science, Information Systems, Data Engineering, or related field, or equivalent work experience
• 8+ years of experience in data engineering, database development, or related roles
• Expert-level proficiency in T-SQL and Microsoft SQL Server
• Expert-level proficiency of Python
• Experience building REST APIs and background workers in Python (FastAPI/Flask)
• Understanding of event-driven architectures and asynchronous processing patterns
• Strong experience with Azure data services (Azure SQL, Data Factory, Synapse, Blob Storage, etc.)
• Hands-on experience building and maintaining data pipelines and ETL/ELT processes
• Knowledge of Power BI development skills including DAX, data modeling, and performance optimization
• Solid understanding of database design principles, normalization, and data modeling
• Experience with version control systems (Git) and CI/CD practices
• Strong analytical and problem-solving abilities with attention to detail
• Excellent written and verbal communication skills
• Ability to work both independently and collaboratively in a team environment
• Microsoft certification (Azure Data Engineer Associate, Azure Database Administrator, Power BI Data Analyst)
• Knowledge of Infrastructure as Code (Terraform, Bicep, ARM templates)
• Knowledge of additional Azure services (Container Apps, Functions, Logic Apps)
• Experience with other database platforms (PostgreSQL, CosmosDB)
• Understanding of HIPAA/HITRUST compliance requirements for healthcare data
• Experience PowerShell for automation and scripting
• Experience with Azure DevOps or similar platforms for CI/CD
• Experience with data governance, cataloging, and metadata management
• Background in healthcare technology or regulated industries
• Experience with OpenAPI/Swagger specification design and contract testing
• Proficient in advanced usage of AI development tooling (e.g., Claude Code, GitHub Copilot)
• Azure API Management and private networking patterns
• Travel up to 15%.

Preferred

• Practical experience with FHIR (resources, search parameters, OAuth2/SMART on FHIR) and C-CDA parsing/transformation
• Experience integrating with Epic, Cerner, Athena, or other EHR/EMR systems
• Experience with HL7 v2 (MLLP/MDM/ADT) message handling