What are the responsibilities and job description for the Data Engineer position at MetroPlus Health Plan?
Data Engineer
Job Ref : 117607
Category : Information Technology
Department : ANALYTICS AND REPORTING
Location : 50 Water Street, 7th Floor,
New York,
NY 10004
Job Type : Regular
Employment Type : Full-Time
Hire In Rate : $125,000.00
Salary Range : $125,000.00 - $135,000.00
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
MetroPlus Health 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, MetroPlus Health's network includes over 27,000 primary care providers, specialists and participating clinics. For more than 30 years, MetroPlus Health has been committed to building strong relationships with its members and providers to enable New Yorkers to live their healthiest life.
Position Overview
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.
Job Description
- 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
MPH50
LI-Hybrid
Salary : $125,000 - $135,000
