AI-Driven Technical BA: Data Validation & SQL

SimonsChustr; New York; Hybrid; USD 90,000 - 140,000; Full time

Job summary

Simon & Schuster is modernizing core systems powering order management, fulfillment, partner integration, and finance with .NET/SQL and AI-assisted approaches. The Technical Business Analyst translates business needs into data-focused specifications, maintains test data and reconciliation artifacts, and guides developers on validation criteria.

You will own comparison rules, test data, and reconciliation evidence, work with developers on automation, and validate outputs before production

Qualifications

• 5+ years of technical business analysis, systems analysis, or data-focused QA.
• Strong SQL skills with joins, aggregation, and set comparisons.
• Requirements and process analysis translating needs into specs.
• Data-centric validation across reports, ETL, or migrations.
• Experience preparing test data, running automated checks, and tracking issues.
• Clear communication with concise specifications and evidence-based conclusions.
• Experience using AI tools for analysis or testing with independent validation.

Responsibilities

• Define requirements and processes with stakeholders and document acceptance criteria.
• Trace data and system behavior; document mappings, dependencies, and exceptions.
• Reconcile replacement outputs by running parallel-run comparisons and defects.
• Prepare test data and repeatable checks with extended validation coverage.
• Validate reports and interfaces against requirements with reproducible findings.
• Coordinate UAT and cutover evidence to support informed business decisions.
• Use AI tooling to assist analysis while validating output against rules.

Skills

SQL skills

Requirements analysis

Data validation

Stakeholder comms

AI tooling

UAT coordination

Job description

Simon & Schuster is modernizing core systems powering order management, fulfillment, partner integration, and finance with .NET/SQL and AI-assisted approaches. The Technical Business Analyst translates business needs into data-focused specifications, maintains test data and reconciliation artifacts, and guides developers on validation criteria.

You will own comparison rules, test data, and reconciliation evidence, work with developers on automation, and validate outputs before production