Hybrid Risk-Adjustment Data Engineer: SQL & Healthcare Analytics

MetroPlusHealth; New York (NY); Hybrid; USD 120,000 - 160,000; Full time

Job summary

MetroPlusHealth is seeking a Risk Adjustment Data Engineer to establish and manage data processes in the Enterprise Data Warehouse, respond to ad-hoc data requests, and coordinate ongoing data exchanges with external vendors.

The ideal candidate will be comfortable in a SQL Server environment, write complex SQL, develop ETL processes with SSIS, and translate business needs into technical requirements for stakeholders. Experience with healthcare data formats (837/834/C-CDA/FHIR) is a plus.

Qualifications

• Bachelor’s degree or equivalent in Information Systems, CS, Database Management, or related field.
• 5+ years of programming in SQL Server database object development (SPs, functions, views).
• 5+ years of experience with healthcare data such as Claims, Enrollment, Providers, and EHR extracts.
• Experience with BI platforms such as Tableau or Power BI.
• Knowledge of .Net development, Python, JavaScript, JSON, XML.
• Excellent analytical and problem-solving skills.
• Experience managing the application development lifecycle.
• Ability to work effectively in a team and adapt to multiple projects quickly.
• Knowledge of standard healthcare data formats such as 837, 834, C-CDA, etc.

Responsibilities

• Represent Risk Adjustment in technical discussions; translate business requirements into technical specs.
• Monitor, maintain, and enhance data processes.
• Document workflows, data processing, and reporting logic.
• Write complex SQL scripts; develop stored procedures, SSIS, TSQL, and processing modules.
• Develop test cases to validate data processes, ETL workflows, and report logic.
• Generate monthly extracts of claims, provider, and member data for external partners.
• Extract and transform data from the EDW to meet external partner needs.

Skills

SQL Server development

T-SQL

SSIS

ETL

Healthcare data

Python

JavaScript

JSON

XML

Analytical skills

Team collaboration

Education

Bachelor's degree in Information Systems / CS / Database Management

Tools

SSIS

Tableau

Power BI

.NET development

Python

Job description

MetroPlusHealth is seeking a Risk Adjustment Data Engineer to establish and manage data processes in the Enterprise Data Warehouse, respond to ad-hoc data requests, and coordinate ongoing data exchanges with external vendors.

The ideal candidate will be comfortable in a SQL Server environment, write complex SQL, develop ETL processes with SSIS, and translate business needs into technical requirements for stakeholders. Experience with healthcare data formats (837/834/C-CDA/FHIR) is a plus.