Payroll Clerk - Payroll Systems Migration

Knightscope Inc
  • Sunnyvale, CA
  • $30–$33 Per Hour
1 day ago

Job Description

About KnightscopeKnightscope (NASDAQ: KSCP) is a security technology company building the nations first Autonomous Security Force - autonomous machines, AI-driven software, and elite security professionals operating as one integrated managed service. The Company is on a mission to make the United States of America the safest country in the world. One Team. One Force.

About the Role Knightscope is seeking a detail-oriented and highly organized Payroll Clerk to play a key role in a major payroll systems migration and to provide ongoing support to the Payroll team. In this role, you will gather, organize, and verify a large and time-sensitive volume of payroll-related data - historical payroll and multi-year tax records from ADP TotalSource and ADP Workforce Now, plus benefits and retirement plan data - and perform meticulous, large-scale comparisons to ensure a smooth and accurate transition to Knightscope's new payroll system. This requires coordinating directly with ADP, People Operations, Finance/Accounting, and employees. Once the migration is complete, this role continues as an ongoing member of the Payroll team, supporting repetitive, comparison-heavy work - reconciling reports and data sets, checking work for accuracy, and maintaining organized, audit-ready records in Excel.

Location: ONSITE - Sunnyvale, CA HQ

Key Responsibilities

Support the end-to-end payroll systems migration: download, extract, and organize multi-year historical payroll, timekeeping, and tax data from ADP TotalSource and ADP Workforce Now, including prior-year Forms 941/940, state and local withholding/unemployment filings, and W-2/W-3 records. Coordinate directly with ADP account representatives and the new system's implementation team to confirm data extraction formats, file specifications, and migration timelines. Collect and reconcile benefits and retirement plan data processed through payroll, and verify employee-level records as needed. Perform detailed side-by-side comparisons across multiple payroll reports, pay periods, and data exports to confirm accuracy and completeness - often across five or more data sets at a time. Build, maintain, and troubleshoot Excel workbooks and formulas (VLOOKUP/XLOOKUP, pivot tables, conditional formatting) to support payroll reconciliation and reporting. Identify and document discrepancies, escalate issues, and help build repeatable processes for future data migrations or system changes. Provide ongoing payroll support after go-live: collect and verify timesheets, confirm overtime/double-time/shift differential calculations, and verify new hire tax, direct deposit, and onboarding payroll data. Maintain strict confidentiality and data accuracy standards when handling sensitive employee and payroll information.

Required Qualifications

Strong Microsoft Excel skills, including VLOOKUP/XLOOKUP, pivot tables, and multi-file/report comparison techniques - this is the core skill set for the role. An associate degree (2 years of college) in accounting, business administration, or a related field, OR 1-2 years of experience in bookkeeping, accounting, payroll, or payroll support. Working knowledge of basic payroll or accounting principles (gross-to-net calculations, deductions, tax withholdings, general ledger basics). Experience with ADP TotalSource and/or ADP Workforce Now strongly preferred - candidates with direct payroll software experience will be considered for the top of the pay range. Exceptional attention to detail, organization, and accuracy when working with large volumes of repetitive or comparative data. Strong time management skills, a self-starter mindset, and the ability to meet recurring payroll deadlines while managing a temporary increase in project workload.

Compensation & Benefits Base Pay: $30.00 - $33.00 per hour, based on experience (ADP TotalSource/Workforce Now experience considered for top of range) Equity: Stock options Benefits: medical/dental/vision, 401(k), PTO Location Requirement: Remote (U.S.)

Numbers & Facts

LocationSunnyvale, CA
Salary$30–$33 Per Hour

Skills

  • ADPunmatched
  • Accountingunmatched
  • Artificial Intelligence (AI)unmatched
  • Bookkeepingunmatched
  • Business Administrationunmatched
  • Compensation and Benefitsunmatched
  • Data Formatsunmatched
  • Data Migrationunmatched
  • Data Processingunmatched
  • Data Qualityunmatched
  • Data Setsunmatched
  • Detail Orientedunmatched
  • File Comparisonunmatched
  • Financeunmatched
  • General Ledger Accountingunmatched
  • Identify Issuesunmatched
  • Microsoft Excelunmatched
  • Onboardingunmatched
  • Organizational Skillsunmatched
  • Payroll Accountingunmatched
  • Payroll Administrationunmatched
  • Payroll Software/Servicesunmatched
  • Pivot Tablesunmatched
  • Reconciliationunmatched
  • Retirement Planunmatched
  • System Migrationunmatched
  • Time Managementunmatched
  • Vlookupsunmatched

Be found by employers

5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Free resume builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Free resume builder