Medicaid Data Warehouse Consultant

Description 

The position is to support the Medicaid Enterprise Systems (MES). The IT Specialist position will support architecture review of projects in the Division of Systems (DOS) Portfolio and support major architecture initiatives of New York State Medicaid Enterprise.

Duties 

• The IT Specialist will perform report development tasks as it relates to health information technology including development of reports, workflows, data transformation, programming solutions, writing and executing unit test plans, researching, resolving, and testing reporting defects, and close collaboration with the technical team .
• Analyze, develop, and revise flow charts, process models and technical specifications describing as-is or to-be Information Technology (IT) systems or business processes .
• Review business requirements documentation with technical project manager and programmers to ensure clarity in implementation of technical design.
• Participate in business requirement and joint application development sessions to inform report options.
• Implement systems and program design to meet complex business needs and author technical design document. Create appropriate documentation in work assignments including technical documentation.
• Assist project manager in development of report time estimates and complete assigned tasks.
• Participate in development as data expert, with specialization in report development.
• Troubleshoot end user technical issues, identifying report problems and leading solutions.
• Support release management process including technical steps to promote, test and release through the development environment, coordinating with infrastructure staff.
• Use waterfall, iterative and agile software development life cycle methodologies.
• Assist in querying Data sources to determine the validity of project outputs.
• Document data architecture.

Mandatory Requirements 

• Experience (10+ Years)
• Works in the field of Information Technology, experienced in the usage and support of a collection of development platforms, technical architectures or business applications and products that run on those platforms - beyond that of a Programmer

Requirements 

• This is an 100% Onsite.
• 84 months experience in the area of public health information Systems such as Medicaid or the Childs Health Insurance Program
• 48 months experience using Oracle products including: SQL Developer, SQL plus and executing SQL scripts 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.
• 48 months experience with Center for Medicaid/Medicare Systems Standards and Codes such as EDI 837, EDI 834, ICD Codes, HIPPA etc.
• 48 months reviewing new projects for overall architectural impact and providing Architecture Assurance.
• 36 months experience in a Data Warehouse Environment processing billions of health care records
• 48 months of experience in research and evaluation of software / hardware products and industry trends to assist in Enterprise Portfolio Assessment and development of the Enterprise Roadmap.
• 24 months of experience developing technical RFP content for major System and Data Integration procurements.
• 24 months of experience in reviewing Cloud-based solutions and AI use cases.
• Bachelor’s Degree in Computer Science/Information Technology
• Résumé
• Copy of Candidate Identification (i.e., Driver’s License/Green Card/Visa and Passport if applicable)
• Any documents referenced in the above Requested Qualifications(i.e., professional certifications, degrees, etc.)