Sr. Business Data Analyst with Medicaid Eligibility

About the role

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.

Responsibilities

• Perform report development tasks related to health information technology, including development of reports, workflows, and data transformation.
• Write and execute unit test plans, research and resolve reporting defects, and collaborate closely with the technical team.
• Analyze, develop, and revise flow charts, process models, and technical specifications describing IT systems or business processes.
• Review business requirements documentation with the 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 documents.
• Create appropriate documentation for work assignments such as program code and technical documentation.
• Assist the project manager in developing report time estimates and completing assigned tasks.
• Participate in development as a 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.
• Troubleshoot end-user technical issues, identifying report problems and leading solutions.
• Support the 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.
• Write queries to support the reconciliation of the MDW, CMS 64, and eMedNY using MARS reports to facilitate claim reporting to the Centers for Medicaid/Medicare systems T-MSIS.
• Assist in querying data sources to determine the validity of project outputs.
• Document data architecture.

Requirements

• 14+ years of experience in Information Technology, with experience beyond that of a Programmer in development platforms, technical architectures, or business applications.
• 100% onsite role.
• 84 months of experience in Public health information systems such as Medicaid or the Children’s Health Insurance Program.
• 84 months of experience using Oracle products including SQL Developer, SQL*Plus, and executing SQL scripts using DBeaver to query Vertica and Oracle databases.
• 84 months of experience working with stakeholders and vendors throughout the entire project life cycle from requirement gathering to implementation.
• 84 months of experience with Centers for Medicaid/Medicare Systems Standards and Codes such as EDI 837, EDI 834, ICD Codes, HIPAA, and various CMS Medicaid Reports such as T-MSIS and CMS 64.
• 64 months of experience in the analysis, design, and testing of enterprise applications using Java/J2EE, XML, SOAP, DB2/Oracle, and Web Services.
• 36 months of experience in a large-volume Data Warehouse Environment processing billions of healthcare records, including understanding of various ETL databases like Source, Staging, and Publishing and related Row and Column Level security.
• Master’s or Bachelor’s degree in Computer Science or Information Technology.