Data Engineer

NYC Health + Hospitals • Full-time • United States • $125k / year • 1m ago

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 products, including, but not limited to, New York State Medicaid Managed Care, Medicare, Child Health Plus, Exchange, Partnership in Care, MetroPlus Gold, Essential Plan, etc. As a wholly-owned subsidiary of NYC Health + Hospitals, the largest public health system in the United States, MetroPlusHealth's network includes over 27,000 primary care providers, specialists and participating clinics. For more than 30 years, MetroPlusHealth has been committed to building strong relationships with its members and providers.

The position of Data Engineer in the Analytics and Reporting Department is responsible in managing encounter data submission to NYSDOH, CMS and other regulatory entities as required. The responsibility includes troubleshooting EDI mapping issues, Encounter data reporting errors, monitoring Encounter Data Quality reports, ensuring adherence to EDI standards, writing complex SQL Queries and stored procedures, SSIS jobs for EDI file submission, and troubleshooting EDI error records. Additionally, this role is responsible for developing and maintaining EDI documentation including process flow and cross-functional team collaboration regarding identification of EDI problem areas. Lastly, the Data Engineer is responsible for preparing test data, conditions and expected results to verify new EDI updates and logic.

The successful candidate must have strong SQL programming skills, EDI Analytical skills, communication skills, and healthcare experience with knowledge in membership, provider, and claims data.

Work Shifts

9:00 A.M – 5:00 P.M

Duties & Responsibilities

Monitor and submit Encounter Data files to NYSDOH OSDS and CMS.
Collaborate with vendors/end users on correcting EDI error transactions and resubmissions to NYSDOH and CMS.
Automate manual processes for Encounter Data submissions.
Support the Compliance and Regulatory department for any inquiry on Encounter Data processes.
Support MMCOR reporting
Create KPI reports on Encounter Data reporting.
Create SQL stored procedures and flow diagrams and document the process for Encounter Data Reporting.
Troubleshoot EDI Errors and keep track of all the resubmissions.

Minimum Qualifications

Bachelor’s degree in Information Systems, Computer Science, Database Management, or related field.
Minimum 5 years of programming experience in SQL Server database object development including but not limited to stored procedures, functions, views, SSIS and SSRS, X12 EDI mapping and development, and troubleshooting EDI errors.
Minimum 3 years’ experience in complex healthcare data like Claims and Enrollment.
Working knowledge of EDI X12 Standards
Previous experience in BI reporting tools, such as BusinessObjects, Tableau, or Power BI
Knowledge of Visual Studio, .Net Development, XML, BizTalk

Licensure and/or Certification Required:

NONE

Professional Competencies:

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

Benefits

NYC Health and Hospitals offers a competitive benefits package that includes:

Comprehensive Health Benefits for employees hired to work 20+ hrs. per week
Retirement Savings and Pension Plans
Paid Holidays and Vacation in accordance with employees' Collectively bargained contracts
Loan Forgiveness Programs for eligible employees
College tuition discounts and professional development opportunities
College Savings Program
Union Benefits for eligible titles
Multiple employee discounts programs
Commuter Benefits Programs