SSIS - Healthcare Data Integration Engineer

Job Description: Healthcare Data Integration Engineer

Company: Hvantage Technologies Inc.

Location: Remote (Global HQ: Los Angeles, USA | Offshore Centers: Hong Kong & India)

Department: Healthcare IT Solutions

Employment Type: Full-Time

About Hvantage Technologies Inc.

Hvantage Technologies Inc. is a global leader in delivering innovative IT solutions, with a specialized focus on the Healthcare and BFSI sectors. We empower organizations to achieve operational excellence through scalable, data-driven technologies, with a strong emphasis on compliance, security, and transformative outcomes.

Role Overview

We are seeking a Healthcare Data Integration Engineer with deep expertise in healthcare data processes, ETL pipelines, and provider operations. The ideal candidate will have 4+ years of experience in data load/integration solutions and 3+ years of hands-on experience in health plan projects, particularly in provider data management. This role requires a blend of technical proficiency, domain knowledge, and collaboration skills to align IT systems with healthcare business goals.

Key Responsibilities

Data Integration & Pipeline Development

Design, develop, and maintain scalable data load and integration processes for healthcare systems, ensuring seamless data flow across platforms.

Build and optimize ETL/ELT pipelines using SSIS (SQL Server Integration Services) and Azure Data Factory (ADF), leveraging connectors for diverse data sources (e.g., EHRs, claims systems, provider databases).

Healthcare Data Expertise

Apply in-depth knowledge of health plan operations, particularly provider data management (e.g., credentialing, network adequacy, demographics), to ensure solutions meet regulatory and business requirements.

Collaborate with stakeholders to translate healthcare operational needs into technical specifications (e.g., FHIR standards, HIPAA compliance).

Data Modeling & Optimization

Architect and implement data models to support analytics, reporting, and operational workflows.

Perform database tuning, query optimization, and code refactoring to enhance performance and scalability.

Establish data quality standards and monitoring processes to ensure accuracy and integrity.

Cross-Functional Collaboration

Work closely with healthcare operations teams, data analysts, and IT stakeholders to align technical solutions with business objectives.

Communicate complex technical concepts to non-technical audiences, ensuring clarity and alignment.

Process Monitoring & Maintenance

Implement tools for data orchestration, pipeline monitoring, and error handling to ensure reliability.

Troubleshoot and resolve data discrepancies, latency issues, and integration bottlenecks.

Technical Requirements

Core Skills:

4+ years of hands-on experience in data integration (ETL/ELT), pipeline development, and workflow orchestration.

Expertise in SSIS and Azure Data Factory (ADF) for constructing scalable data pipelines.

Proficiency in SQL (query optimization, stored procedures, indexing) and relational databases (SQL Server, MySQL).

Strong background in data modeling (star/snowflake schemas, normalization) and database tuning.

Healthcare Domain Knowledge:

3+ years of experience in health plan projects, with a focus on provider data management (e.g., NPPES, CAQH, provider directories).

Familiarity with healthcare standards: HL7, FHIR, HIPAA, and payer-provider workflows.

Soft Skills:

Excellent communication skills with proven ability to collaborate across technical and non-technical teams.

Agile mindset with experience in iterative project delivery.

Nice-to-Have Skills

Exposure to cloud platforms (Azure, AWS) and healthcare analytics tools (e.g., SAS, Tableau).

Knowledge of data governance frameworks and master data management (MDM).

Experience with real-time data streaming (Kafka, Event Hubs).

Preferred Qualifications

Bachelors or Masters degree in Computer Science, Health Informatics, or a related field.

Certifications in Azure Data Engineer, SSIS, or healthcare IT (e.g., CPHIMS).

Proven track record of delivering data solutions in Medicaid/Medicare, payer, or provider environments.

Why Join Hvantage Technologies?

Industry Impact: Drive innovation in healthcare IT, directly improving provider operations and patient outcomes.

Growth Opportunities: Access to cutting-edge projects, certifications, and mentorship in a global team environment.

Work Flexibility: Remote-friendly culture with competitive compensation, health benefits, and performance bonuses.

How to Apply

Submit your resume and a cover letter detailing your experience in healthcare data integration, provider operations, and ETL/SSIS/ADF projects to neelesh@hvantage.com. Include examples of past projects where you optimized data workflows or resolved complex healthcare data challenges.

Hvantage Technologies Inc. is an equal opportunity employer committed to diversity and inclusion.