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 manages payment for teen apprentices, interns, and assistants, and assists with all functions related to the administration of stipends and wages.

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

• Oversees 2–3 seasonal staff members

• 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 detailed oriented
• Knowledge of ADP’s Workforce Now 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

• 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

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.

$54,590

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.