ON-SITE - Healthcare System Architect

• 84 months experience in the area of: Public health information Systems such as Medicaid or the Childs Health Insurance Program

• 84 months experience using Oracle products including: SQL Developer, SQL plus and executing SQL scripts using DBeaver to query Vertica and Oracle Databases

• 84 months experience Working with Stakeholders and vendor in the entire project life cycle from requirement gathering to Implementation.

• 84 months experience with Center for Medicaid/Medicare Systems Standards and Codes such as EDI 837, EDI 834, ICD Codes, HIPPA etc. and various CMS Medicaid Reports such as TMSIS, CMS64 etc.

• 64 Months experience in the analysis, design and testing of enterprise applications using JAVA/J2EE, XML, SOAP, DB2/Oracle and Web Services

• 36 months experience in a large volume Data Warehouse Environment processing billions of health care records, understanding of various ETL Databases like Source, Staging and Publishing and the related Row and Column Level security.

• Masters/ Bachelor’s Degree in Computer Science/Information Technology

Detailed Job Description: 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.