• SQL Jira Analyst

    COOLSOFT (Lincoln, NE)


    SQL Jira Analyst

     

    (Jobs in Lincoln, NE)

     

    Requirement id 155815

     

    Job title Analyst

     

    Job location in Lincoln, NE

     

    Skills required Bachelor Degree In Computer Science, Software Testing, ETL Processes, SQL Jira

     

    Open Date 04-Nov-2025

     

    Close Date

     

    Job type Contract

     

    Duration 16 Months

     

    Compensation DOE

     

    Status requirement ---

     

    Job interview type ---

     

    Email Recruiter:coolsoft

     

    Job Description Analyst: Bachelor Degree In Computer Science, Software Testing, ETL Processes, SQL Jira

     

    Start date : 01/01/2026

     

    End Date : 05/01/2027

     

    Submission deadline : 11/14/2025

     

    Client Info : NeDHHS

    Note:

    * Remote

    Description:

    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 migrated 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:

    • Bachelors degree in computer science, Information Systems, or a related field

    • 5–7 years of experience in software testing, preferably in Medicaid or healthcare data systems.

    • Knowledge of Medicaid data (eligibility, enrollment, claims, encounters, providers).

    • Hands-on experience validating ETL processes and data migration projects.

    • Strong experience testing Cognos reports

    • Proficiency in SQL for data validation and troubleshooting.

    • Familiarity with data warehouses, staging, and OLAP environments.

    • Experience with test management tools (JIRA, Selenium etc ).

    • Strong analytical, documentation, and problem-solving skills.

    Preferred Qualifications:

    • Experience with Medicaid Cloud data warehouse implementations and migrations.

    • Exposure to ETL tools such as IBM DataStage.

    • Familiarity with AWS based data management solutions and applications.

     

    Call502-379-4456 Ext 100for more details. Please provide Requirement id: 155815 while calling.

     

    EOE Protected Veterans/Disability