Healthcare System Architect - HBITS-08-14980

About the role

The position is being requested for the Medicaid Data Warehouse Bureau. Medicaid Data Warehouse is the primary repository for Medicaid in New York State and is the main provider of Business Intelligence on Medicaid Data.

Responsibilities

• Work with stakeholders and vendors throughout the entire project lifecycle from requirement gathering to implementation.
• Analyze, design, and test enterprise applications using Java/J2EE, XML, SOAP, DB2/Oracle, and web services.
• Process billions of healthcare records in a large-volume data warehouse environment.
• Understand various ETL databases (source, staging, publishing) and related row and column-level security.

Requirements

• 84 months of experience in public health information systems such as Medicaid or the Children’s Health Insurance Program.
• 84 months of experience using Oracle products including SQL Developer, SQL*Plus, and executing SQL scripts using DBeaver to query Vertica and Oracle databases.
• 84 months of experience working with stakeholders and vendors across the project lifecycle.
• 84 months of experience with Center for Medicaid/Medicare Systems standards and codes such as EDI 837, EDI 834, ICD codes, HIPAA, and various CMS Medicaid reports such as TMSIS and CMS64.
• 64 months of experience in the analysis, design, and testing of enterprise applications.
• 36 months of experience in a large-volume data warehouse environment.
• Master’s or Bachelor’s degree in Computer Science or Information Technology.