Data-Driven Business Systems Analyst - QA & UAT Lead

Confidential

Pittsburgh (Allegheny County)

On-site

USD 80,000 - 110,000

Full time

18 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Confidential in Pittsburgh seeks a Technical Business Systems Analyst to lead requirements analysis, document specifications, and coordinate QA activities across enterprise technology solutions. You will translate business needs into testable criteria and collaborate with stakeholders and technical teams to ensure delivered systems meet approved expectations.

The role requires hands-on SQL for data profiling and validation, plus experience with UAT, data mappings, and reporting integrations.

Qualifications

  • Bachelor’s degree in information technology, computer science, business, or equivalent work experience.
  • At least 3 years of combined experience in business analysis, software quality assurance, test analysis, or a related role.
  • Experience eliciting and documenting business requirements and converting them into testable acceptance criteria.
  • Hands-on SQL experience for data analysis, validation, reconciliation, or test verification.
  • Experience creating test plans, traceable test cases, defect documentation, and UAT support materials.

Responsibilities

  • Elicit, clarify, document, and obtain approval for business, functional, and non-functional requirements; lead stakeholder workshops, process walkthroughs, and solution reviews.
  • Document current- and future-state processes, data flows, gaps, acceptance criteria, and approved changes; act as liaison between business users and technical teams.
  • Learn core operational systems, database structures, business rules, integrations, and key data flows.
  • Write and execute SQL to profile source data, confirm relationships, validate business rules, and reconcile records across systems.
  • Document data mappings, field specifications, transformation logic, expected behavior, error handling, and exceptions; analyze integrations with CRM, reporting, and third-party applications.
  • Review data models, stored procedures, reporting specifications, and integration designs; identify data-quality issues and source limitations.
  • Develop test strategies, plans, and reusable cases with clear steps, representative data, expected results, and acceptance criteria.
  • Maintain a requirements traceability matrix linking approved requirements to test cases and identifying coverage gaps.
  • Execute data validation and reconciliation tests for integrations, conversions, and reports, including record counts and source-to-target comparisons.
  • Coordinate system, integration, regression, performance, and UAT testing; work with developers on defect resolution.
  • Manage defects from classification and prioritization through triage, retesting, resolution, and closure.
  • Report test coverage, results, defects by severity, risk, and readiness; support evidence-based sign-off decisions.
  • Maintain testing standards, templates, naming conventions, evidence practices, reusable cases, and regression suites; recommend practical requirements, testing, traceability, and automation tools.
  • Guide business testers, translate technical scenarios into business steps, review vendor testing deliverables against requirements and contracted scope, and train peers and testers.
  • Support data-conversion and migration validation, including reconciliation against source systems.

Skills

SQL
Requirements analysis
UAT coordination
Data validation
Stakeholder management
Documentation

Education

Bachelor's degree in IT/CS/Business or equivalent
Equivalent work experience

Tools

SSRS
Power BI
Azure DevOps
ERP systems

Job description

Confidential in Pittsburgh seeks a Technical Business Systems Analyst to lead requirements analysis, document specifications, and coordinate QA activities across enterprise technology solutions. You will translate business needs into testable criteria and collaborate with stakeholders and technical teams to ensure delivered systems meet approved expectations.

The role requires hands-on SQL for data profiling and validation, plus experience with UAT, data mappings, and reporting integrations.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Technical Business Systems Analyst - SQL, QA & UAT Lead
Technical Business Systems Analyst - SQL, QA & UAT Lead

Confidential Careers • Pittsburgh

Hybrid
USD 70,000 - 100,000
Technical Business Systems QA & Data Validation Analyst
Technical Business Systems QA & Data Validation Analyst

Confidential • Pittsburgh

On-site
USD 75,000 - 105,000
Technical Business Analyst: QA, Data Validation & SQL
Technical Business Analyst: QA, Data Validation & SQL

Confidential • Pittsburgh

On-site
USD 90,000 - 120,000
Senior Business Systems Analyst - Data, Testing & UAT
Senior Business Systems Analyst - Data, Testing & UAT

TALENT Software Services • Pittsburgh

On-site
USD 70,000 - 90,000
Technical Business Systems Analyst
Technical Business Systems Analyst

Confidential Careers • Pittsburgh

Hybrid
USD 70,000 - 100,000
Technical Business Systems Analyst
Technical Business Systems Analyst

Confidential • Pittsburgh

On-site
USD 75,000 - 105,000
Senior Business & QA Analyst (SDLC/UAT)
Senior Business & QA Analyst (SDLC/UAT)

Ask IT Consulting, Inc. • Hyattsville (MD)

On-site
USD 120,000 - 160,000
Business Analyst
Business Analyst

Visionet Systems Inc. • Pittsburgh

On-site
USD 70,000 - 90,000
Technical Business Analyst
Technical Business Analyst

Confidential • Pittsburgh

On-site
USD 90,000 - 120,000
Data-Driven Business Analyst: SQL, UAT & Banking
Data-Driven Business Analyst: SQL, UAT & Banking

Strategic Data Systems, Inc. • Cincinnati (OH)

Hybrid
USD 90,000 - 120,000
Competitive base salary
Medical, dental, and vision insurance
401(k) with company match
+4