Remote Healthcare Data Engineer: HL7 ETL & Migration

Clearsense; United States; On-site; USD 110,000 - 165,000; Full time

Benefits offered by this job

Fully remote flexibility

Onboarding and ramp-up support

Growth into senior-level ownership

Job summary

Clearsense is seeking a remote, full-time data engineer to focus on healthcare data migration, ETL development, SQL optimization, reporting, and data validation. You will work with legacy healthcare systems to extract, transform, validate, and deliver high-quality data for reporting and archival solutions.

The role emphasizes designing ETL processes, writing efficient SQL, building SSRS reports, and ensuring HIPAA-compliant data integrity across EHR/EMR sources.

Qualifications

• 3–5+ years of experience in Data Engineering, ETL Development, Database Development, or BI.
• Strong SQL skills including complex queries, joins, stored procedures, and performance tuning.
• Experience with SQL Server, T-SQL, SSIS, or similar ETL technologies.
• Experience developing or supporting SSRS, Crystal Reports, Power BI, or similar reporting platforms.
• Experience working directly with healthcare data.
• Strong understanding of source-to-target mapping, ETL development, data validation, reconciliation, and data quality.

Responsibilities

• Design, develop, and maintain ETL processes for healthcare data migration.
• Extract, transform, and load data from legacy healthcare applications, databases, flat files, and APIs.
• Perform source-to-target mapping and data transformation activities.
• Develop scalable SQL and ETL solutions supporting multiple healthcare implementations.
• Write and optimize complex SQL queries, stored procedures, and data transformation logic.
• Analyze large healthcare datasets to identify inconsistencies and ensure data accuracy.
• Troubleshoot SQL performance and resolve data-related issues.
• Build and maintain SSRS reports and support other reporting solutions.
• Perform data reconciliation, validation, and quality assurance throughout migration projects.
• Validate migrated data against business requirements and source systems.
• Produce clear reconciliation and validation documentation.
• Work directly with healthcare data from EHR/EMR systems.
• Interpret clinical, patient, financial, and operational healthcare data.
• Ensure HIPAA compliance and maintain data integrity throughout migration efforts.
• Partner with Product, QA, Integration, and Client Delivery teams.
• Assist with troubleshooting production data issues.
• Document mapping logic, validation rules, and technical solutions.

Skills

SQL

ETL development

Data engineering

Data validation

Performance tuning

Tools

SQL Server

T-SQL

SSIS

SSRS

Power BI

Job description

Clearsense is seeking a remote, full-time data engineer to focus on healthcare data migration, ETL development, SQL optimization, reporting, and data validation. You will work with legacy healthcare systems to extract, transform, validate, and deliver high-quality data for reporting and archival solutions.

The role emphasizes designing ETL processes, writing efficient SQL, building SSRS reports, and ensuring HIPAA-compliant data integrity across EHR/EMR sources.