Technical Business Analyst

Job Summary

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

• 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

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