Technical Business Systems Analyst

Confidential Careers; Pittsburgh (Allegheny County); Hybrid; USD 70,000 - 100,000; Full time

Job summary

Confidential Careers seeks a Technical Business Systems Analyst to lead requirements analysis, document processes, and perform SQL-based data validation across enterprise systems. You will coordinate testing activities including UAT and ensure traceability from requirements to test cases with strong collaboration across business users and technical teams.

The role requires hands-on SQL, experience in test planning, and ability to translate business needs into clear acceptance criteria.

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-based data analysis

Requirements elicitation

Test planning & execution

UAT coordination

Stakeholder management

Documentation

Data reconciliation

Analytical thinking

Education

Bachelor's degree in information technology, computer science, business

Tools

SSRS

Power BI

Azure DevOps

Job description

The Technical Business Systems Analyst defines, tests, and validates enterprise technology solutions supporting business operations. The position leads requirements analysis and documentation, performs SQL-based data and systems validation, and coordinates quality assurance, traceability, and user acceptance testing (UAT) to ensure delivered solutions meet approved requirements and business expectations.Key Responsibilities

Key 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.

Minimum Education & Experience Requirements

• 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.

Special Requirements

No additional special requirements specified.

Knowledge, Skills, and Abilities

• SQL-based data analysis, reconciliation, and verification; understanding of relational data, business rules, data mappings, and integrations.
• Business and functional requirements analysis, process documentation, acceptance criteria, and requirements traceability.
• Test planning, test case design, defect management, system/integration/regression testing, and UAT coordination.
• Ability to analyze data models, stored procedures, reporting specifications, integration designs, and data-quality issues.
• Strong analytical, problem-solving, prioritization, stakeholder-management, and written and verbal communication skills.
• Ability to collaborate with business users, technical teams, and vendors and independently verify solutions against requirements.

Additional Desired Characteristics

• Testing experience with ERP, integrations, data conversions, reporting, or multi-system implementations.
• Operational systems experience in transportation, logistics, dispatch, routing, or field service.
• Experience with SSRS or Power BI.
• Experience working with external implementation partners or software vendors.
• ISTQB, CSTE, IIBA, or comparable testing or business analysis certification.
• Hands-on Azure DevOps experience with requirements, test plans, traceability, defects, team adoption, or user training.
• Experience with test automation frameworks.

Hybrid remote position in the Pittsburgh, Pennsylvania area. Works with business stakeholders, technical teams, and vendors. Specific office attendance, hours, travel, and on-call expectations were not stated.

Other Duties

This job description is intended to describe the general nature and level of work performed in this position. It is not intended to be an exhaustive list of all responsibilities, duties, and qualifications. Additional duties may be assigned as business needs require.