Business Systems Analyst

Minimum years of experience required : 8+ years

Key Skills which the client is focused on : State client experience and Medicaid experience are a must.

Seeking a Business Systems Analyst Expert (testing exp.) for a Contract position, and this is a 100% Remote role. Ideally, looking for applicants with a solid background in Testing, ETL, Cognos, and SQL .

Job Summary :

We are seeking a detail-oriented MES Tester to support the Medicaid Data Warehouse Migration Project. The successful candidate will be responsible for testing and validating ETL data pipelines and Cognos reports to ensure data accuracy, completeness, and integrity across key Medicaid data domains - including member, claims, encounters, and provider datasets. This role demands hands-on experience in data validation, report testing, and ETL verification within a Medicaid or healthcare data environment.

Key Responsibilities :

• Validate ETL pipelines after data migration from legacy systems to new data warehouses or cloud platforms.
• Test and verify Cognos reports for accuracy, completeness, formatting, and compliance with defined business rules.
• Develop and execute test plans, test cases, and scripts for both ETL and reporting validation.
• Perform data reconciliation between source, staging, and target systems to ensure integrity and correctness.
• Collaborate with data engineers and business analysts to understand reporting requirements and ETL transformations.
• Identify, log, and track defects or discrepancies using JIRA.
• Support the state team during User Acceptance Testing (UAT) for migrating data and reports.
• Document testing activities, results, and provide summary reports and recommendations.
• Ensure testing adheres to HIPAA, CMS, and state Medicaid compliance standards.

Required Skills and Experience :

Preferred Qualifications :