"Alerted.org

Summary of Position:  The Payroll Coordinator role is different from a typical payroll role as it is heavily focused on data manipulation and analysis. Teens participating in After School Matters programs either earn a stipend for their participation or earn an hourly wage. The Payroll Service Coordinator will use various functions in Microsoft Excel (such as VLOOKUP, pivot tables, sorting/filtering, etc.) in order to prepare our teen participant payroll data for our analysts who will run the payroll. This crucial role will ensure data accuracy, which is essential for teens to be paid properly.

The Payroll Coordinator is a full-time position.

Major Duties and Responsibilities:

Preparing teen data:

+ Audit teen enrollment and attendance data in preparation for payroll

+ Run reports and manipulate data to verify social security numbers; identify duplicate social security numbers and work with staff, teens and parents to correct information

Changing data in the payroll system:

+ Make changes in the payroll system to accurately capture new hires, rehires, terminations, and transfers between program session

+ Update departments and service name in the payroll system for each session to match the current session’s programs; scrub the program Activity Data Report to ensure that all active departments have a contract ID and all programs run within the scheduled period

+ Enroll teens in their preferred payment method by uploading direct deposit and pay card data

Payroll delivery and customer service:

+ Assist with sorting and distributing pay checks

+ Prepare and distribute pay status reports to teens, instructors, and staff

+ Maintain a log of outstanding checks

+ Assist in the distribution of the 1099s and W-2s

+ Facilitate meeting with new Program staff to explain stipend rules, including pay eligibility, pay timelines, and procedures for reporting late start, absences, and transfers

+ Support the Teen Stipend Hotline, responding to inquiries with speed, accuracy and professionalism

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

+ 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

+ Ability to clearly communicate detailed information to a variety of stakeholders

+ Energetic team player who works well in collaborative situations

+ Ability to work independently and take ownership of projects

Qualifications:

+ Bachelor’s degree or two years of related (data manipulation or payroll) work experience required; high school diploma or equivalency required

+ Experience using Microsoft Excel (v-lookup, pivot tables, sorting/filtering data, etc.) is required.

+ Cook County residency required

Compensation: $47,271.52

About Us: After School Matters is a Chicago-based nonprofit organization that annually offers after-school and summer programs to nearly 19,000 Chicago high school teens to explore and develop their talents while gaining critical skills that will set them up for success in college and beyond.

ASM has engaged more than 400,000 Chicago teens and is the nation’s largest and most successful provider of after-school and summer programs for high school teens.

ASM offers paid apprenticeships led by professionals in the fields of arts, communications and leadership, sports, and STEM (Science, Technology, Engineering, and Math). Our nationally respected youth development model has been replicated in cities across the country and earned us the City Livability Award from the U.S. Conference of Mayors.

Programs take place at community locations throughout the city, including three ASM buildings: downtown at Gallery 37 Center for the Arts, the Michael and Karyn Lutz Center in Belmont Cragin, and the Pullman community at Gately Park. Currently, After School Matters’ annual operating budget is approximately $35M and employs approximately 500 staff across the organization.

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.

Powered by JazzHR