Risk Adjustment Data Engineer | SQL Server & ETL Expert

MetroPlusHealth; New York (NY); On-site; USD 120,000 - 150,000; Full time

Job summary

MetroPlusHealth in New York seeks a Risk Adjustment Data Engineer to establish and manage data processes for risk adjustment. You will maintain tables in the Enterprise Data Warehouse, respond to ad-hoc requests, and coordinate data exchanges with external vendors.

You will serve as the technical liaison for the Risk Adjustment team, translating business needs into technical requirements and delivering automated solutions in an SQL Server environment.

Qualifications

• Bachelor's degree required in Information Systems, Computer Science, Database Management, or a related field.
• 5+ years of SQL Server database object development (stored procedures, functions, views).
• 5+ years’ experience with healthcare data (Claims, Enrollment, Providers, 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.
• Knowledge of healthcare data formats (837, 834, C-CDA).

Responsibilities

• Represent Risk Adjustment team in technical discussions with stakeholders; translate business requirements into technical specs.
• Monitor, maintain, and enhance existing data processes.
• Document workflows, data processing, and reporting logic.
• Write complex SQL scripts; develop stored procedures, SSIS packages, T-SQL.
• Develop test cases to validate data processes, ETL workflows, and reports.
• Generate monthly extracts of claims, provider, and member data for exchange with external partners.
• Extract and transform data from Warehouse to meet partner needs.

Skills

SQL Server

Tableau

Power BI

.NET development

Python

JavaScript

JSON

XML

Analytical thinking

Communication

Education

Bachelor's degree in Information Systems/Computer Science/Database Management or related field

Tools

Tableau

Power BI

.NET

Job description

MetroPlusHealth in New York seeks a Risk Adjustment Data Engineer to establish and manage data processes for risk adjustment. You will maintain tables in the Enterprise Data Warehouse, respond to ad-hoc requests, and coordinate data exchanges with external vendors.

You will serve as the technical liaison for the Risk Adjustment team, translating business needs into technical requirements and delivering automated solutions in an SQL Server environment.