Quality Assurance and Data Tester

Seneca Holdings; Buffalo (NY); On-site; USD 70,000 - 110,000; Full time

Job summary

Seneca Holdings, including its Great Waters Federal unit, seeks a Quality Assurance/Data Tester to support data pipelines on the Halo platform for FDA-related workloads in a FISMA High environment.

The role emphasizes validating data onboarding, transformations, and AI/ML use cases with strong SQL, Databricks, and cloud testing experience. Join a collaborative team delivering secure, auditable testing across complex federal programs.

Qualifications

• Hands-on software or data QA testing experience.
• Experience with functional, integration, regression, and backend testing.
• Strong SQL skills with complex queries and aggregations.
• Ability to identify defects early and communicate clearly.
• Experience testing data pipelines and data migrations to cloud.
• Familiarity with Databricks, Delta tables, and lakehouse concepts.

Responsibilities

• Design, validate, and QA data pipelines across Halo platform.
• Validate data onboarding for accuracy and reliability.
• Test Halo use cases ensuring data is fit for analytics.
• Verify data migration from on-prem to cloud architectures.
• Validate analytics outputs against requirements.
• Test AI agent use cases in a federal environment.
• Create traceable test cases and scripts from requirements.
• Execute functional, integration, and regression testing.
• Perform backend data testing with SQL in Delta Lake.
• Identify, document, and track defects with reproduction steps.
• Collaborate with data engineers, developers, and stakeholders.
• Maintain test docs and evidence for audits in a FISMA High environment.
• Participate in Agile ceremonies.

Skills

QA testing

SQL

Data quality

Agile/Scrum

Documentation

Communication

Tools

Jira

Azure DevOps

TestRail

Databricks

AWS

Job description

Great Waters Federal i is part of the Seneca Nation Group (SNG) portfolio of companies. SNGis Seneca Holdings' federal government contracting business that meets mission-critical needs of federal civilian, defense, and intelligence community customers. Our portfolio comprises multiple subsidiaries that participate in the Small Business Administration 8(a) program. To learn more about SNG, visitthe website and follow us onLinkedIn.

Our team of talented individuals is what makes us successful. To support our team, we provide a balanced mix of benefits and programs.Your total rewards package includes competitive pay, benefits, and perks, flexible work-life balance, professional development opportunities, and performance and recognition programs. We offer a comprehensive benefits package that includes medical, dental, vision, life, and disability, voluntary benefit programs (critical illness, hospital, and accident), health savings and flexible spending accounts, and retirement 401K plan. One of our fundamental principles is to offer competitive health and welfare benefits to our team members, providing coverage and care for you and your family. Full-time employees working at least 30 hours a week on a regular basis are eligible to participate in our benefits and paid leave programs. We pride ourselves on our collaborative work environment and culture, which embraces our mission of providing financial and non-financial benefits back to the members of the Seneca Nation.

We are seeking a detail-oriented Quality Assurance / Data Tester to support the design, validation, and quality assurance of data pipelines and integration workflows across the agency-wide Halo enterprise cloud platform.

Halo serves as a central data infrastructure layer for multiple FDA centers and programs, supporting data onboarding and a range of use-case development efforts that prepare data for advanced analytics and AI agent consumption.

This role operates within a Databricks E2 on AWS environment governed by FISMA High and multi-tenant security requirements. The position requires close collaboration across a complex, matrixed federal environment.

The ideal candidate is a hands-on tester who can identify defects early, validate the integrity, accuracy, and reliability of legacy on-premises systems migrating to cloud-based architectures, and confirm that advanced analytics and AI agent use cases meet defined business and technical requirements.

Key Responsibilities

• Support the design, validation, and quality assurance of data pipelines and integration workflows across the Halo enterprise cloud platform.
• Validate data onboarding processes to ensure new data sources are ingested, transformed, and made available accurately and reliably for downstream use cases.
• Support the development and testing of Halo use cases, ensuring data is properly prepared and fit for purpose for required analytics.
• Verify the integrity, accuracy, and reliability of data migrated from legacy on-premises systems to cloud-based architectures.
• Validate that advanced analytics outputs meet defined functional, technical, and business requirements.
• Test and validate AI agent use cases operating across a complex, matrixed federal environment, confirming that outputs are accurate, consistent, and aligned with intended behavior.
• Create clear, thorough, and traceable test cases and test scripts derived from requirements, source-to-target mappings, and use-case documentation.
• Execute functional testing to confirm that pipelines, transformations, and platform features perform as designed.
• Perform integration testing across interconnected systems, services, and data flows to validate end-to-end behavior.
• Conduct regression testing to ensure new releases, pipeline changes, or platform updates do not introduce defects into existing functionality.
• Perform backend and data-level testing, including SQL-based validation of tables, transformations, and aggregations within Delta Lake and Databricks.
• Identify, document, and track defects with clear reproduction steps, prioritizing early detection to reduce downstream rework and risk.
• Collaborate with data engineers, developers, and business stakeholders to clarify requirements, resolve defects, and continuously improve test coverage.
• Maintain test documentation, traceability matrices, and evidence of test execution to support audit and compliance needs within a FISMA High environment.
• Participate in Agile ceremonies, contributing to sprint planning, backlog refinement, and iterative test cycles.

Required Qualifications

• Proven, hands-on experience in software or data quality assurance testing, including test case design and execution.
• Strong experience with functional testing, integration testing, regression testing, and backend/data testing.
• Solid SQL skills for validating backend data, including complex queries, joins, and aggregations.
• Demonstrated ability to identify defects early in the development lifecycle and communicate them clearly to technical teams.
• Experience testing data pipelines, ETL/ELT processes, or data migration efforts from legacy systems to cloud platforms.
• Familiarity with cloud data platforms such as Databricks and AWS, including exposure to Delta tables and data lakehouse concepts.
• Experience developing and maintaining test cases, test plans, and traceability documentation.
• Strong analytical and problem-solving skills, with close attention to data accuracy, consistency, and edge cases.
• Experience working within Agile/Scrum project methodologies.
• Excellent written and verbal communication skills, with the ability to work across cross-functional, matrixed teams.

Preferred Skills

• Experience testing or validating AI/ML model outputs or AI agent-based use cases.
• Familiarity with medallion architecture, including Bronze, Silver, and Gold layers, and modern data lakehouse design.
• Experience with test automation tools and frameworks for data or API testing.
• Experience operating within FISMA High, FedRAMP, or other regulated, multi-tenant federal environments.
• Familiarity with defect-tracking and test-management tools, such as Jira, Azure DevOps, or TestRail.

Equal Opportunity Statement

Seneca Holdings provides equal employment opportunities to all employees and applicants without regard to race, color, religion, sex/gender, sexual orientation, national origin, age, disability, marital status, genetic information and/or predisposing genetic characteristics, victim of domestic violence status, veteran status, or other protected class status. This policy applies to all terms and conditions of employment, including, but not limited to, hiring, placement, promotion, termination, layoff, recall, transfer, leave of absence, compensation and training. The Company also prohibits retaliation against any employee who exercises his or her rights under applicable anti-discrimination laws. Notwithstanding the foregoing, the Company does give hiring preference to Seneca or Native individuals. Veterans with expertise in these areas are highly encouraged to apply.