Ensemble Health Partners LLC logo

ETL Engineer

Job Overview

Location

Remote - Nationwide

Job Type

Full-time

Category

Software Engineering

Date Posted

June 23, 2026

Full Job Description

đź“‹ Description

  • • Design, develop, and maintain ETL solutions using Microsoft SSIS and SQL Server Relational Database technologies to support healthcare revenue cycle operations.
  • • Enhance and troubleshoot legacy ETL processes to improve performance, reduce runtime, and align with evolving business requirements.
  • • Monitor production ETL jobs regularly to ensure data integrity, reliability, and timely execution.
  • • Collaborate with cross-functional teams to design, model, and develop SQL database objects required for business solutions.
  • • Translate business requirements into technical specifications for data integration and reporting systems.
  • • Optimize slow-running ETL workflows through redesign, indexing, query optimization, and improved data flow architecture.
  • • Ensure all data solutions comply with healthcare industry standards and regulatory requirements.
  • • Participate in code reviews, provide technical guidance, and mentor junior team members on ETL best practices.
  • • Contribute to continuous improvement initiatives by identifying inefficiencies in current data pipelines and proposing scalable enhancements.
  • • Work closely with Business Intelligence teams to support the development of data models and reporting infrastructure.
  • • Maintain documentation for ETL processes, data mappings, and system dependencies to ensure knowledge transfer and operational continuity.
  • • Support end-to-end testing of data solutions, including unit testing, integration testing, and UAT coordination.
  • • Stay current with emerging technologies in data engineering and evaluate opportunities to modernize existing SSIS-based workflows.
  • • Ensure data security and confidentiality in alignment with HIPAA and other healthcare data protection standards.
  • • Engage in agile development practices, including sprint planning, daily stand-ups, and backlog refinement.

🎯 Requirements

  • • Proficiency in Microsoft SSIS for designing and maintaining ETL workflows
  • • Strong experience with SQL Server Relational Database design, querying, and optimization
  • • Demonstrated ability to troubleshoot and enhance legacy ETL processes
  • • Experience working in healthcare or regulated industries with compliance requirements (e.g., HIPAA)
  • • Ability to collaborate with cross-functional teams including BI, data analysts, and software engineers
  • • Strong problem-solving skills and attention to data accuracy and system reliability

🏖️ Benefits

  • • Comprehensive healthcare, retirement, and well-being benefits package
  • • Professional certification reimbursement and tuition assistance for career growth
  • • Quarterly and annual incentive programs recognizing high performance
  • • Remote work flexibility with nationwide availability

Skills & Technologies

Go
Remote

Ready to Apply?

You will be redirected to an external site to apply.

AI Job Fit Analysis
Pro

See exactly how your profile matches this role — strengths, skill gaps, and what to do about them.

Ensemble Health Partners LLC logo
Ensemble Health Partners LLC
Visit Website

About Ensemble Health Partners LLC

Ensemble Health Partners provides revenue cycle management services to hospitals and health systems. The company offers coding, billing, accounts receivable, denial management, and patient access solutions supported by data analytics and automation tools. Clients include academic medical centers, community hospitals, and physician practices across the United States. Ensemble focuses on improving cash collections, reducing administrative costs, and ensuring regulatory compliance within healthcare organizations.

Get more remote jobs like this

Subscribe to the weekly newsletter for similar remote roles and curated hiring updates.

Newsletter

Weekly remote jobs and featured talent.

No spam. Only curated remote roles and product updates. You can unsubscribe anytime.

Similar Opportunities

Expired
India
Full-time
Expired Jun 8, 2026
Remote
Degree Required

3 months ago

Expired
London Office
Full-time
Expired Jun 22, 2026
Onsite

2 months ago

Expired
San Francisco
Full-time
Expired Jun 8, 2026
Python
JavaScript
Node.js
+2 more

3 months ago

Malta
Full-time
Expires Aug 12, 2026
Remote

15 days ago