Payroll Data Analyst

Summary of Position: The Payroll Data Analyst’s primary focus is data manipulation and analysis to prepare complex teen participant data for payroll processing. The Payroll Data Analyst manages payment for teen apprentices, interns, and assistants, and assists with all functions related to the administration of stipends and wages. Major Duties and Responsibilities: Data manipulation and analysis to complete payroll processing: Scope and cost management — ensures timely delivery of payroll Collect and build data sets from our program database (Cityspan) while thinking strategically about the uses of data as it pertains to payroll Process manual checks, replacement checks, and payroll corrections; investigate and resolve payroll discrepancies Identify areas for process improvement using technology and propose alternatives Payroll delivery and customer service: Manage the logistics of check and pay card distribution; work with Programs to ensure delivery details are accurate Collaborate with various departments for all aspects of the payroll process, from ensuring that teens are properly enrolled in programs to successfully paying teens; contact program liaisons when teens are missing requirements needed to be eligible for payment Maintain and audit the outstanding and replacement check logs Support the Teen Stipend Hotline and respond to email inquiries Reporting and recordkeeping: Prepare and distribute accurate payroll reports and metrics, including the weekly Dashboard/Stipend report, to communicate percentages of teens and programs who were paid Complete quarter‑end and year‑end processes for each payroll Manage the distribution of W‑2s and 1099s Assist in gathering data requested by external auditors Other duties as assigned. Supervisory Responsibilities: Oversees 2–3 seasonal staff members Knowledge, Skills and Abilities: Strong working knowledge of Microsoft Office Word and Excel including pivot tables and v‑lookups Exceptional analytical and problem‑solving skills Ability to compile, enter, audit and verify data Highly detail oriented Knowledge of ADP’s WorkforceNow preferred Working knowledge of payroll‑related requirements and regulations Ability to clearly communicate detailed information to a variety of stakeholders Ability to multi‑task and adjust to rapidly changing priorities in order to address and resolve the most critical and sensitive issues on a timely basis Strong orientation to customer service in a fast‑paced, high‑energy environment Energetic team player who works well in collaborative situations Ability to work independently and take ownership of projects Qualifications: Bachelor’s degree required Experience using Microsoft Excel is required 1–2 years of work experience required; data manipulation and payroll experience preferred Cook County residency required Additional Requirements: Staff are required to provide proof of COVID‑19 vaccination or have an approved medical or sincerely held religious beliefs exemption prior to starting employment. If a medical or sincerely held religious belief exemption is approved, weekly Polymerase Chain Reaction (PCR) testing is required as part of any reasonable accommodation. Compensation: $54,590 EEO: After School Matters is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, ancestry, national origin, religion, sex, sexual orientation, gender identity, disability, protected veteran status, military discharge status, age, marital status, parental status, or source of income. #J-18808-Ljbffr After School Matters