Simon & Schuster

QA Test/Automation Engineer

Simon & Schuster New York, New York, United States · $120K–$150K/yr

Book and Periodical Publishing · 1,001-5,000 employees

21 h ago
qa Senior (5-10 yrs) Full-time United States
Log in to apply, save this posting, or score it against your profile with AI.

About the role

The QA Test Automation Engineer will own the data-comparison and reconciliation process for system modernization, ensuring legacy and replacement systems produce equivalent outputs. This role involves building automated regression suites, validating data integrity across large datasets, and assembling evidence packages to gate production cutovers.

What they look for

SQL Test automation Data reconciliation Regression testing C# .NET Data validation ETL AI tooling Performance testing System migration Batch processing EDI Root-cause analysis Technical communication

Requirements

Candidates must have at least 5 years of QA experience with a strong focus on test automation and advanced SQL skills for data validation. Experience with system migrations, AI-assisted testing, and the ability to perform root-cause analysis on complex data discrepancies is required.

Benefits

Medical Dental Vision 401(k) plan Life insurance Disability benefits Tuition assistance program PTO Broad Based Ownership program

Full description

Simon & Schuster was named to Forbes magazine list of America's Best Mid-Size Employers 2022. Simon & Schuster is a global leader in general interest publishing, dedicated to providing the best in fiction and nonfiction for readers of all ages, and in all printed, digital and audio formats. Its distinguished roster of authors includes many of the world's most popular and widely recognized writers, and winners of the most prestigious literary honors and awards. It is home to numerous well-known imprints and divisions such as Simon & Schuster, Scribner, Atria Books, Gallery Books, Pocket Books, Adams Media, Simon & Schuster Children's Publishing and Simon & Schuster Audio and international companies in Australia, Canada, India and the United Kingdom, and proudly brings the works of its authors to readers in more than 200 countries and territories. For more information visit our website at www.simonandschuster.com.

About the Role

Simon & Schuster, one of the world's leading publishers, is investing in a multi-year modernization of the core systems that power order management, fulfillment, partner integration, and financial transactions. We are replacing long-established technology with modern .NET and SQL solutions using an AI-assisted approach.

The QA / Test Automation Engineer is the evidence engine of the program. Nothing replaces a production process here until it has been proven equivalent: every replacement runs in parallel with the existing system, writing to isolated validation tables, and its output is reconciled against the existing output row by row. This role owns that proof, building the automated regression and data-reconciliation checks, running the first-pass comparison on every parallel run, chasing every discrepancy to a root cause, and assembling the evidence package that gates each production cutover.

This is not a test-script-execution role. It is a data-heavy engineering role: most validation happens in SQL against large production datasets, wrapped in repeatable, automated harnesses, with AI tooling used to accelerate test generation and analysis.

Key Responsibilities

  • Own first-pass reconciliation — Run and maintain the data-comparison process for every parallel ("shadow") run: legacy output vs. replacement output, row counts to column-level differences. Classify every discrepancy( defect, timing artifact, or explained difference) before it reaches business review.
  • Build automated regression and parity tests — Create repeatable, automated test suites that verify converted functionality preserves required business behavior across releases, including edge cases identified during discovery.
  • Test integrations and performance — Validate interfaces to warehouse, EDI, and financial systems; verify replacements meet or beat legacy runtimes and batch windows under production-scale volume.
  • Gate production cutovers with evidence — Define and enforce the "green-run" standard (consecutive clean parallel runs); assemble the cutover evidence package reviewed by the business and the Modernization Lead.
  • Coordinate business user testing — Organize UAT with business stakeholders alongside the Systems Analyst, translating validation results into terms business owners can sign off on.
  • Harden the validation framework — Improve shared reconciliation procedures, test data management, and run-telemetry checks so each successive replacement is cheaper and safer to validate.
  • Use AI tooling critically — Apply AI-assisted test generation, data analysis, and documentation, with the judgment to validate generated output before relying on it.

Required Qualifications

  • 5+ years of QA experience with a strong test-automation focus, including ownership of test strategy for production systems (not solely manual test execution).
  • Strong SQL skills — able to write substantial queries against large datasets for data validation and reconciliation: joins, aggregation, and set comparison across systems. This is the core daily skill of the role.
  • Automated testing experience — building and maintaining automated test suites (e.g., NUnit/xUnit, pytest, or equivalent) and integrating them into a repeatable pipeline.
  • Data-centric testing background — validating batch processes, ETL/data pipelines, or system migrations where correctness is proven by comparing datasets, not clicking through screens.
  • Experience using AI tools in testing or analysis — e.g., AI-assisted test generation, data analysis, or documentation — with the judgment to critically validate generated output.
  • Root-cause discipline — demonstrated ability to chase a data discrepancy through multiple systems to a definitive explanation, and to communicate findings clearly.
  • Clear written communication — validation reports and evidence summaries that non-technical stakeholders can act on.

Preferred Qualifications

  • Experience validating a system migration, replatforming, or legacy-modernization program (parallel-run / reconciliation-based testing).
  • Exposure to legacy or mainframe-style environments (e.g., COBOL-era batch systems) — enough familiarity to work effectively with legacy specialists. No COBOL skills required.
  • C# / .NET familiarity — able to read the code under test and write test harnesses in the team's stack.
  • Order processing, fulfillment, supply-chain, or EDI domain experience.
  • Performance and load testing of batch or high-volume data processes.
  • Batch scheduling environments (AutoSys or similar) and overnight batch operations.
  • Experience coordinating user acceptance testing with business stakeholders.

What Success Looks Like

  • Every cutover is backed by a complete, auditable evidence package — and post-cutover defect rates stay near zero.
  • Discrepancies are caught in parallel-run validation, not in production.
  • Reconciliation and regression suites become faster and more reusable with each replacement package.
  • Business stakeholders trust the validation process enough that sign-offs are routine, not contentious.

Simon & Schuster US is an equal opportunity employer (EOE). At Simon & Schuster US, the spirit of inclusion feeds into everything that we do. From employee benefits/programs and social impact outreach initiatives, we believe that opportunity, access, resources and rewards should be available to and for the benefit of all. We are committed to equal employment opportunity regardless of race, color, national origin, religion, creed, sex (including pregnancy, sexual orientation, gender, gender identity or expression), age, citizenship status, marital status, and Veteran status where protected by law or any other characteristic protected by applicable federal, state, or local law. The hiring salary range for this position applies to New York City, California, Colorado, Washington state, and most other geographies. Starting pay for the successful applicant depends on a variety of job-related factors, including but not limited to geographic location, market demands, experience, training, and education. The benefits available for this position include medical, dental, vision, 401(k) plan, life insurance coverage, disability benefits, tuition assistance program and PTO or, if applicable. Additionally, employees have access to our industry-first, Broad Based Ownership program, which makes all employees partners in our shared success. We are committed to providing reasonable accommodations to qualified individuals in accordance with applicable law. If you need a reasonable accommodation during the application or interview process, please contact us at [insert contact information]. Unrelated emails, such as following up on an application, will not receive a response.

Candidates hired for this or any other posted Simon & Schuster role will be employees of Simon & Schuster, LLC, subject to all policies, including the Workplace Privacy Notice, and eligible solely for the benefits plans thereof.

Similar roles