Apply Now

EDI Database Programmer

New York, NY, US • Posted 20 hours ago • Updated 7 hours ago

Full Time

On-site

USD $120,000.00 - 130,000.00 per year

Fitment

Dice Job Match Score™

✨ Finding the perfect fit...

Job Details

Skills

Database
Analytics
Medicare
Medicaid
Data Quality
Writing
Documentation
Process Flow
Network
Recovery
Payments
Regulatory Compliance
Regulatory Reporting
KPI
SQL
Training
Information Systems
Computer Science
Database Administration
Microsoft SQL Server
Stored Procedures
Microsoft SSIS
Microsoft SSRS
Mapping
Health Care
Electronic Data Interchange
ASC X12
Business Intelligence
Reporting
Business Objects
Tableau
Microsoft Power BI
Microsoft Visual Studio
XML
Microsoft BizTalk Server
Management
Communication
Collaboration
Teamwork
Analytical Skill
Conflict Resolution
Problem Solving

Database
Analytics
Medicare
Medicaid
Data Quality
Writing
Documentation
Process Flow
Network
Recovery
Payments
Regulatory Compliance
Regulatory Reporting
KPI
SQL
Training
Information Systems
Computer Science
Database Administration
Microsoft SQL Server
Stored Procedures
Microsoft SSIS
Microsoft SSRS
Mapping
Health Care
Electronic Data Interchange
ASC X12
Business Intelligence
Reporting
Business Objects
Tableau
Microsoft Power BI
Microsoft Visual Studio
XML
Microsoft BizTalk Server
Management
Communication
Collaboration
Teamwork
Analytical Skill
Conflict Resolution
Problem Solving

Summary

Position Overview

The EDI Database Programmer position in the Analytics and Reporting Department is responsible for managing data error reconciliation and submission to the New York State Department of Health (NYSDOH), Centers for Medicare and Medicaid Services (CMS), and other regulatory entities, as required. This role includes troubleshooting Electronic Data Interchange (EDI) mapping issues and encountering data reporting errors; monitoring encounter data quality reports; and ensuring adherence to EDI standards. Additional responsibilities include writing complex SQL queries and stored procedures; developing and maintaining SQL Server Integration Services (SSIS) jobs for EDI file submissions; troubleshooting EDI error records; and maintaining comprehensive EDI documentation, including process flows. The role also involves collaborating cross-functionally to identify and resolve EDI issues, as well as preparing test data, conditions, and expected outcomes to validate new EDI updates and logic related to Social Care Network claims, Health Recovery Plan (HRP) transitions, retroactive rate changes, State Directed Payments, and risk adjustment encounter submissions.

The successful candidate will possess strong SQL programming and EDI analytical skills, excellent communication abilities, and healthcare experience, including knowledge of membership, provider, and claims data.

Scope of Role & Responsibilities

Monitor encounter fallouts and reconcile and re-submit fallout encounter data files to NYSDOH OSDS and CMS.
Collaborate with vendors/end users on correcting EDI error transactions and resubmissions to NYSDOH and CMS for Retro Rate adjustments, State Directed payments and Risk adjustments.
Automate manual processes for encounter data error re-submissions.
Support compliance and regulatory for any inquiry on encounter data processes.
Support MMCOR reporting and other regulatory reporting.
Create KPI reports on encounter reconciliation reporting.
Create SQL stored procedures, SSIS packages, flow diagrams and document the process for Encounter Data Reporting.
Develop and test EDI mapping for encounter submissions.
Troubleshoot EDI errors and keep track of all the resubmissions.

Required Education, Training & Professional Experience

Bachelor's degree required in Information Systems, Computer Science, Database Management, or a related field; or an equivalent combination of education and experience.
Minimum of 7 years of experience in SQL Server database development, including stored procedures, functions, views, SSIS, SSRS, X12 EDI mapping and development, and troubleshooting EDI errors.
Minimum of 4 years of experience working with complex healthcare data, including claims, enrollment, and provider data.
Strong knowledge of EDI X12 standards, particularly transactions 837, 834, 277CA, and 999.
Prior experience submitting encounters to NYSDOH is preferred but not required.
Experience with BI reporting tools such as BusinessObjects, Tableau, or Power BI.
Working knowledge of Visual Studio, NET development, XML, BizTalk, and Health Rules Payor.

Professional Competencies

Integrity and Trust
Collaboration and Time management skills
Functional/Technical skills
Written/Oral Communication
Teamwork
Excellent analytical and problem-solving skills.
Ability to work effectively in a team environment and adapt quickly to changing projects and priorities.

#LI-Hybrid

#MPH50

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 80185017
Position Id: 6b97b8abd727104ecc2be96216b2d5b5
Posted 20 hours ago

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

New York, New York

•

Today

The position of Data Engineer in Analytics and Reporting Department is responsible in managing data process design and development of ETL in SQL Server environment. This role also involves understanding business requirements and designing and developing regulatory and operational reports in a timely and consistent manner. The Successful candidate must be self-motivated and technically strong individuals with minimum of five years of experience in SQL Server and other database development. The in

Full-time

USD 120,691.00 - 130,691.00 per year

Medical Management Data Analyst

New York, New York

•

Today

Empower. Unite. Care. MetroPlusHealth is committed to empowering New Yorkers by uniting communities through care. We believe that Health care is a right, not a privilege. If you have compassion and a collaborative spirit, work with us. You can come to work being proud of what you do every day. About NYC Health + Hospitals MetroPlusHealth provides the highest quality healthcare services to residents of Bronx, Brooklyn, Manhattan, Queens and Staten Island through a comprehensive list of produc

Full-time

USD 89,000.00 - 91,000.00 per year

Data Analyst

New York, New York

•

Today

Reporting to the Director of Reporting Systems within the Analytics and Reporting Department, the position of Data Analyst performs in-depth analysis of healthcare data, supporting regulatory reporting and encounter data submission. Scope of Role & Responsabilities: Analyze claim and encounter data to ensure data submission is meeting regulatory requirements. Reconcile data with regulatory reporting and gap analysis to identify areas for improvement. Develop database in SQL Server environment An

Full-time

USD 80,000.00 - 90,000.00 per year

EDI Production Issue Coordinator/Tester

Remote

•

Today

EDI Production Issue Coordinator/Tester Location:Remote Description: Seeking a highly motivated and self-directed EDI Production Issue Coordinator/Tester to join our team supporting Veterans. The EDI Production Issue Coordinator serves as the dedicated analytical and technical troubleshooting lead for VA's Payer Electronic Data Interchange (EDI) operations. This senior technical role requires deep expertise in healthcare X12 EDI transactions, data mapping, and root cause analysis to rapidly r

Full-time

Search all similar jobs

More jobs at MetroPlusHealth in New York, NY

EDI Database Programmer

Dice Job Match Score™

Job Details

Skills

Summary

Similar Jobs