IT Specialist

About the role

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.

Responsibilities include analyzing, developing, and revising flow charts, process models and technical specifications describing as-is or to-be Information Technology (IT) systems or business processes; reviewing business requirements documentation with technical project manager and programmers to ensure clarity in implementation of technical design; participating in business requirement and joint application development sessions to inform report options; implementing systems and program design to meet complex business needs and authoring technical design documents; creating appropriate documentation in work assignments such as program code and technical documentation; assisting project manager in development of report time estimates and completing assigned tasks; participating in development as data expert, with specialization in report development; ensuring report development through coding, testing, debugging, implementing, and documenting programs, and developing test plans to verify logic programs and output; troubleshooting end user technical issues, identifying report problems and leading solutions; supporting release management process including technical steps to promote, test and release through the development environment, coordinating with infrastructure staff; using waterfall, iterative and agile software development life cycle methodologies.

Additional duties include writing queries to support the reconciliation of the MDW, CMS 64 and eMedNY utilizing MARS reports to facilitate claim reporting to the Centers for Medicaid/Medicine systems – T-MSIS; assisting in querying data sources to determine the validity of project outputs; and documenting data architecture.

Mandatory Qualifications

• 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 vendors 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, HIPAA etc. and various CMS Medicaid Reports such as T-MSIS, 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
• Master’s/Bachelor’s Degree in Computer Science/Information Technology