Payroll Clerk – Payroll Systems Migration

About Knightscope Knightscope (NASDAQ: KSCP) is a security technology company building the nation's 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: Sunnyvale, CA HQ