Technical Business Analyst: QA, Data Validation & SQL

Confidential; Pittsburgh (Allegheny County); On-site; USD 90,000 - 120,000; Full time

Job summary

Confidential is seeking a Technical Business Systems Analyst to lead requirements analysis, data validation, and testing across enterprise technology solutions. You will collaborate with business users and technical teams, write SQL-based validations, and ensure acceptance testing aligns with approved requirements and business expectations.

You will document processes, data mappings, and integration designs, while guiding testers and coordinating defect resolution to drive quality outcomes.

Qualifications

• Bachelor’s degree or equivalent in IT, CS, business, or related field.
• At least 3 years of experience in business analysis, software quality assurance, or related roles.
• Hands-on SQL experience for data analysis, validation, or test verification.
• Experience creating test plans, traceable test cases, defect documentation, and UAT support materials.

Responsibilities

• Elicit, clarify, document, and approve business requirements; lead stakeholder workshops.
• Document current and future state processes, data flows, gaps, and changes.
• Write and execute SQL to profile data, validate rules, and reconcile records.
• Coordinate system, integration, regression, and UAT testing; work with developers on defects.
• Develop test strategies, plans, and reusable cases with clear steps and acceptance criteria.
• Maintain traceability matrix linking requirements to test cases and coverage.

Skills

Business analysis

Quality assurance

Test analysis

Stakeholder management

SQL data analysis

Documentation

Education

Bachelor’s degree or equivalent

ISTQB / CSTE / IIBA or similar certification

Tools

Azure DevOps

Power BI

SSRS

SQL Server

Job description

Confidential is seeking a Technical Business Systems Analyst to lead requirements analysis, data validation, and testing across enterprise technology solutions. You will collaborate with business users and technical teams, write SQL-based validations, and ensure acceptance testing aligns with approved requirements and business expectations.

You will document processes, data mappings, and integration designs, while guiding testers and coordinating defect resolution to drive quality outcomes.