Medicaid Datawarehouse Consultant

Greetings from Sligo Software Solutions, Inc.

This is Abhijith from SLIGO. We have an urgent requirement for Medicaid Datawarehouse Consultant position with our client.

Title : Medicaid Datawarehouse Consultant

Location : Albany, New York

Duration : 30 Months

Client : NY State - NYS Department of Health

Job ID: SLG - 19 - 10649

Respond by: 05/22/25 5:00 PM

Greetings from Sligo Software Solutions, Inc.

SLIGO is a Software Development and IT Consulting company. We have around 100 IT associates working with our esteemed clients across several domains such as IT, Banking, Healthcare, and Government.

We have an urgent requirement for Medicaid Datawarehouse Consultant position with our client.

Role: Medicaid Datawarehouse Consultant

Location: Albany, New York

Duration: 30 Months

Job ID: SLG - 19 - 10649

Client: NY State

Description

The position is being requested for the Medicaid Data Warehouse (MDW) and the Medicaid Enterprise Systems (MES).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.

Duties

Participate in Annual Enterprise Portfolio Assessment. Analyze, develop, and revise flow charts, process models and technical specifications describing as-is or to-be systems and business processes

Perform Architecture Assurance reviews for priority initiatives in the portfolio.

Provide solution recommendation on emerging capabilities including Cloud-based solutions and AI/ML.

Review data pipelines, review data quality issues and provide recommendation to resolve reporting issues.

Mandatory Requirements

Experience (12 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

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.

36 months experience designing, building, and testing cloud architecture using AWS, GCP, Azure, or Oracle Cloud.

48 months experience in IAM controls and design patterns based on and general industry standards.

60 months experience with handling transaction types such as EDI 837, EDI 834, FHIR etc., HIPAA standards, and various CMS Medicaid Reports such as TMSIS, CMS64 etc.

60 months experience in providing solution recommendation for enterprise applications and developing POCs for emerging technologies including AI/ML.

36 months experience in a large volume, billions of health care records 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

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.)

Abhijith Mallavajhula

Senior Talent Acquisition Specialist

Sligo Software Solutions Inc.

Direct:

Oracle, SQL Developer, Azure, DBeaver, AWS, GCP, EDI 837, EDI 834, cloud Architecture, designing, query Vertica, AI/ML, ETL Databases, IAM controls, or Oracle Cloud, Data Warehouse Environment

Permanent