Technical Business Analyst: SQL & AI-Assisted Validation

Simons; New York; Hybrid; USD 100,000 - 150,000; Full time

Job summary

Simon & Schuster is modernizing core order management and financial systems using .NET and SQL with AI-assisted approaches. The Technical Business Analyst connects business needs to data-driven requirements and acceptance criteria for developers to implement.

You will own reconciliation rules, test data, and validation evidence, working with developers who own the automation framework and application implementation. Strong SQL skills are central to the role.

Qualifications

• 5+ years in technical business analysis, systems analysis, or data-focused QA with requirements and validation.
• Strong SQL skills to write joins, aggregations, and comparisons; identify data issues affecting reconciliation.
• Translate stakeholder needs into process maps, specifications, data definitions, and acceptance criteria.
• Experience validating reports, ETL/pipelines, or migrations with data comparisons.
• Prepare test datasets, run checks, coordinate UAT, and track issues through resolution.
• Communicate clearly with business users and engineers, with concise, evidence-based reports.
• Experience using AI tools for analysis or testing, with independent validation.

Responsibilities

• Define requirements and processes with stakeholders, documenting workflows and testable acceptance criteria.
• Trace data and system behavior; document mappings, dependencies, and exceptions.
• Reconcile replacement outputs; run parallel-run comparisons and investigate differences.
• Prepare test data and repeatable checks; extend validation coverage with developers.
• Validate reports and interfaces; ensure calculations and totals meet requirements.
• Coordinate UAT and cutover evidence; summarize results for business decisions.
• Use AI tooling critically; compare AI outputs with actual system behavior and rules.

Skills

Experience with BA/TA in tech projects

SQL skills

Requirements & process analysis

Data-centric validation

Test data preparation

Clear communication

AI tooling usage

Tools

Microsoft SQL Server

AutoSys

Job description

Simon & Schuster is modernizing core order management and financial systems using .NET and SQL with AI-assisted approaches. The Technical Business Analyst connects business needs to data-driven requirements and acceptance criteria for developers to implement.

You will own reconciliation rules, test data, and validation evidence, working with developers who own the automation framework and application implementation. Strong SQL skills are central to the role.