> Markdown version of [/jobs/ext/557731-edi-database-programmer](https://www.wearedevelopers.com/jobs/ext/557731-edi-database-programmer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # EDI Database Programmer - **Company:** Metroplus Health Plan Inc - **Location:** New York, NY, United States - **Experience:** Experienced - **Salary:** $120,000.0 - $130,000.0 - **Contract:** Permanent contract - **Skills:** Data Analysis, ASC X12 Standards, Microsoft Biztalk Servers, Information Systems, Computer Programming, Databases, Data Files, Electronic Data Interchange (EDI), Microsoft Visual Studio, Microsoft SQL Server, SQL Stored Procedures, SQL Server Reporting Services, SQL Server Integration Services, Tableau (Software), Test Data, Extensible Markup Language (XML), Freeform SQL, Sap Business Objects, Information Technology - **Published:** June 13, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=1da9220514ffc380 ## About the Role Do you have experience in XML?, Do you have a Bachelor's degree?, * 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. * Bachelor's degree required in Information Systems, Computer Science, or Database Management * 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. ## Description 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. ## Related Videos - [Database DevOps with Containers](https://www.wearedevelopers.com/videos/145-database-devops-with-containers) - [Dirty Tests And How To Clean Them](https://www.wearedevelopers.com/videos/515-dirty-tests-and-how-to-clean-them) - [Introduction to TXT](https://www.wearedevelopers.com/videos/30-introduction-to-txt) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [From Bedside Beeps to Interoperable Bytes – Getting your medical devices ready to talk the IEEE 11073 language](https://www.wearedevelopers.com/videos/771-from-bedside-beeps-to-interoperable-bytes-getting-your-medical-devices-ready-to-talk-the-ieee-11073-language) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) ## Related Articles - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [7 Important Tips That Every Software Developer Should Know](https://www.wearedevelopers.com/magazine/101-7-important-tips-that-every-software-developer-should-know) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)