Technical Business Analyst – AI-Driven Data Validation

Simon and Schuster Books; New York (NY); On-site; USD 90,000 - 130,000; Full time

Job summary

Simon & Schuster, a global publishing leader, is modernizing core systems for order management, fulfillment, partner integration, and financials. You will bridge business needs with data-focused analysis, map processes, and translate legacy behavior into actionable specs and validation criteria.

The role emphasizes strong SQL, data validation, and cross-functional collaboration with developers, testers, and business users.

Qualifications

• 5+ years of relevant technical business analysis, systems analysis, or data-focused QA experience, including requirements analysis and hands-on validation of production business systems.
• Strong SQL skills — independently write queries using joins, aggregation, and set comparisons; recognize data-grain, duplicate-record, missing-data, and timing issues that can distort reconciliation.
• Requirements and process analysis — translate stakeholder needs into process maps, functional and technical specifications, data definitions, and actionable acceptance criteria.
• Data-centric validation experience — investigate reports, batch processing, ETL/data pipelines, or migrations by comparing datasets and explaining discrepancies.
• Experience preparing test datasets, running established automated checks, coordinating UAT, and tracking issues through resolution.
• Clear communication with business users and engineers, supported by concise specifications, reproducible issue reports, and evidence-based conclusions.
• Experience using AI tools for analysis or testing, with the judgment to validate their output independently.

Responsibilities

• Define requirements and processes — Work with business stakeholders to document current and future workflows, business rules, reporting needs, change impacts, and testable acceptance criteria.
• Trace data and system behavior — Investigate batch processes, interfaces, SQL logic, and reports with developers and legacy specialists; document data mappings, dependencies, and exceptions.
• Reconcile replacement outputs — Run established parallel-run comparisons, investigate record-level differences, and distinguish defects from timing artifacts or intended changes.
• Prepare test data and repeatable checks — Maintain representative datasets, expected results, and comparison queries; work with developers to extend validation coverage and retain regression checks for resolved defects.
• Validate reports and interfaces — Check calculations, totals, completeness, and exchanged data against agreed requirements; provide reproducible findings and follow issues through retesting.
• Coordinate UAT and cutover evidence — Organize business testing, maintain requirements-to-test traceability, and summarize results and unresolved issues so business owners can make informed acceptance decisions.
• Use AI tooling critically — Apply AI-assisted analysis, SQL generation, and documentation while checking generated output against actual system behavior and approved business rules.

Skills

Strong SQL skills

Requirements and process analysis

Data-centric validation experience

Experience preparing test datasets

Clear communication with business and

Experience using AI tools for analysis

5+ years technical business analysis

Tools

Microsoft SQL Server

Stored procedures

ETL/data pipelines

Job description

Simon & Schuster, a global publishing leader, is modernizing core systems for order management, fulfillment, partner integration, and financials. You will bridge business needs with data-focused analysis, map processes, and translate legacy behavior into actionable specs and validation criteria.

The role emphasizes strong SQL, data validation, and cross-functional collaboration with developers, testers, and business users.