> Markdown version of [/jobs/ext/2310735-expert-it-specialist](https://www.wearedevelopers.com/jobs/ext/2310735-expert-it-specialist). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Expert, IT Specialist - **Company:** MVP CONSULTING, INC - **Location:** New York, NY, United States (Remote available) - **Experience:** Expert - **Contract:** Temporary contract - **Skills:** Agile Methodology, Information Systems, Databases, Extract Transform Load (ETL), Data Warehousing, IBM DB2, Software Debugging, Document-Oriented Databases, Java Platform Enterprise Edition (J2EE), Integrated Development Environments, Joint Application Design, Oracle Databases, Oracle (Applications), Program Design Languages, Release Management, Simple Object Access Protocol (SOAP), SQL*Plus, SQL Databases, Web Services, Extensible Markup Language (XML), Information Technology, Vertica, Database Tools and Utilities - **Published:** August 30, 2026 - **Apply:** https://www.dice.com/job-detail/4a18fc32-8dcf-4969-b50f-022bc6677d76 ## About the Role 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 Masters/ Bachelor's Degree in Computer Science/Information Technology 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. ## 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. --- Day-to-Day Tasks --- 1. Analyze, develop, and revise flow charts, process models and technical specifications describing as-is or to-be Information Technology (IT) systems or business processes 2. Review business requirements documentation with technical project manager and programmers to ensure clarity in implementation of technical design. 3. Participate in business requirement and joint application development sessions to inform report options. 4. Implement systems and program design to meet complex business needs and author technical design document. Create appropriate documentation in work assignments such as program code and technical documentation. 5. Assist project manager in development of report time estimates and completes assigned tasks. 6. Participate in development as data expert, with specialization in report development. Ensure report development through coding, testing, debugging, implementing, and documenting programs, and developing test plans to verify logic programs and output. 7. Troubleshoot end user technical issues, identifying report problems and leading solutions. 8. Support release management process including technical steps to promote, test and release through the development environment, coordinating with infrastructure staff. 9. Use waterfall, iterative and agile software development life cycle methodologies. 10. Write Queries - support the reconciliation of the MDW, CMS 64 and eMedNY utilizing MARS reports - this facilitates claim reporting to the Centers for Medicaid/Medicare systems - T-MSIS. 11. Assist in querying Data sources to determine the validity of project outputs. 12. Document data architecture. ## Related Videos - [Data Fabric in Action - How to enhance a Stock Trading App with ML and Data Virtualization](https://www.wearedevelopers.com/videos/253-data-fabric-in-action-how-to-enhance-a-stock-trading-app-with-ml-and-data-virtualization) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Why make use of an integration platform in today's software developments and infrastructure?](https://www.wearedevelopers.com/videos/758-why-make-use-of-an-integration-platform-in-today-s-software-developments-and-infrastructure) - [Building with IBM Bob](https://www.wearedevelopers.com/videos/100275-building-with-ibm-bob) ## Related Articles - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Data Science & more: The Lopez dilemma](https://www.wearedevelopers.com/magazine/10-data-science-more-the-lopez-dilemma) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Résumé-Driven Development: How IT trends affect the job market for software developers](https://www.wearedevelopers.com/magazine/59-resume-driven-development-how-it-trends-affect-the-job-market-for-software-developers) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)