Why This Role Stands Out
This hybrid role offers a fantastic opportunity to shape enterprise technology solutions, leveraging your SQL and validation skills to ensure seamless business operations. You'll thrive here if you excel at bridging the gap between business needs and technical execution, contributing to impactful projects within a reputable company. Apply now to advance your career in a dynamic and collaborative environment.
Quick Overview
Job Description
**************NO C2C OR VISA SPONSORSHIP CANDIDATES*****************
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.
Similar jobs
- CA
Business Analyst
NewCatalyx
Ambler, PA🇺🇸On-siteYesterdayBusiness AnalysisOperations & Project Management - RT
Product Analyst
NewResolution Technologies
Atlanta, GA🇺🇸HybridYesterdaySQLSalesforceSnowflake+5 - KT
Business Systems Analyst II
Kforce Technology Staffing
Newport Beach, CA🇺🇸Hybrid3 weeks agoExpressScrumAgile+1Technology - TC
Senior Manager, Business Insights and Analytics
NewThe Coca-Cola Company
Atlanta, GA🇺🇸HybridYesterdayBusiness AnalysisGenerative AIStakeholder Management - AK
IT Business Analyst
NewAkkodis
San Antonio, TX🇺🇸$40 - $75/hrHybridYesterdayAgileCapacity PlanningOperations & Project Management - HU
Business Analyst, AI & Automation
NewAuto ApplyHuckberry
Austin, Texas🇺🇸Hybrid11 hours agoSQLBigQueryFinancial Reporting+2Operations & Project Management - CS
Business System Analyst
NewCGT Staffing
Pittsburgh, PA🇺🇸HybridYesterdaySQLAzureBusiness Analysis+5Technology - IN
Business Analyst – PA MMIS Prior Authorizations
NewInfiCare
Quincy, MA🇺🇸HybridYesterdayAgileBusiness AnalysisOperations & Project Management - AL
Professional - Business Analyst
NewArthur Lawrence
Dallas, TX🇺🇸HybridYesterdayOperations & Project Management - HA
Lead, IT Business Analysis
Harris Corporation
Melbourne, FL🇺🇸Hybrid5 weeks agoAccounts PayableBackground ChecksFinancial Reporting+3 - SS
Business Analyst
NewSteck Systems
Tallahassee, FL🇺🇸On-siteYesterdayScrumAgileBusiness Analysis+2Operations & Project Management - NI
PLM Teamcenter Business Analyst
NewNityo Infotech Corporation
Sunnyvale, CA🇺🇸On-siteYesterdayOperations & Project Management