Payroll Data Analyst at After School MattersChicago, Illinois, United States — full-time

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.

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

Abilit