P/T College Aide, Level II

POLICE DEPARTMENT; New York (NY); On-site; USD 2,480,000 - 3,306,000; Full time

Benefits offered by this job

Health insurance

Dental and vision coverage

Paid annual leave

Paid sick leave

Paid holidays

Pension

Deferred Compensation

IRA

Flexible spending account

Job summary

The New York City Police Department (NYPD) is hiring a College Aide to support the IT Fiscal Affairs team. You will assist with financial workflows from IT fiscal requests through final payments, including procurement and contract tracking, data organization, and ad hoc tasks.

This role offers exposure to budgeting, encumbrances, and cross-departmental data analysis in a structured college-aide program with varying hours.

Qualifications

• For Assignment Level I: Matriculation at an accredited college or graduate school.
• For Assignment Level II IT: college student with IT-related coursework and 9 credits.
• For Assignment Level III IT Fellow: student with IT coursework incl. 9 credits; selection by committee.

Responsibilities

• Assist with end-to-end financial workflows including procurement and contract vault updates.
• Clean, organize and compile cross-departmental financial data in Excel for division reporting.
• Complete ad hoc administrative, research, or operational assignments as assigned.

Skills

VLOOKUP

XLLOOKUP

SUMIFS

Pivot tables

Dataset structuring

Education

Matriculation at accredited college

Information technology focus with 9 credits

IT-related studies for Level III

Tools

Excel

Job description

The mission of the New York City Police Department is to enhance the quality of life in New York City by working in partnership with the community to enforce the law, preserve peace, protect the people, reduce fear, and maintain order. The New York City Police Department strives to foster a safe and fair city through the strategic deployment of resources, focusing on both crime prevention and addressing quality-of-life concerns while building lasting community relationships.

The Fiscal Affairs Division (FAD) is seeking a detail oriented, highly organized, and analytical College Aide to support the IT Fiscal Affairs team. In this role you will assist with operational financial workflows, including procurement and contract vault tracking, point of contract tracker centralization, invoice intake and monitoring and document compilation. Through maintaining clean datasets and financial spreadsheets, you will gain direct, practical experience across the complete financial workflows, from initial IT fiscal requests, budget and funding authorization, and procurement and contract actions, to involving and final payment reconciliations.

The selected candidate will perform the following duties:

• Assist with end-to-end financial workflows, including procurement and contract vault updates, invoice intake and verification against active contracts, as well as aligning encumbrance cash positions with line-item budgets.
• Clean, organize and compile cross-departmental financial data in Excel for division reporting dash boarding.
• Complete ad hoc administrative, research, or operational assignments as assigned by department leadership.

HOURS/SHIFT

Varies

ADDITIONAL INFORMATION

In compliance with federal Law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification document form upon hire. The City of New York offers a comprehensive benefits package including health insurance for the employee and his or her spouse or domestic partner and unemancipated children under age 26, union benefits such as dental and vision coverage, paid annual leave and sick leave, paid holidays, a pension, and optional savings and pre-tax programs such as Deferred Compensation, IRA, and a flexible spending account.

COLLEGE AIDE - ASSIGNMENT LEVE - 1020B

Minimum Qualifications

For Assignment Level I: Matriculation at an accredited college or graduate school. Employment is conditioned upon continuance as a student in a college or graduate school.

For Assignment Level II (Information Technology): Matriculation at an accredited college or graduate school. Employment is conditioned upon continuance as a student in a college or graduate school with a specific course of study in information technology, computer science, management information systems, data processing, or closely related field, including or supplemented by 9 semester credits in an acceptable course of study.

For Assignment Level III (Information Technology Fellow): Matriculation at an accredited college or graduate school. Employment is conditioned upon continuance as a student in a college or graduate school with a specific course of study in information technology, computer science, management information systems, data processing, or other area relevant to the information technology project(s) assigned, including or supplemented by 9 semester credits in an acceptable course of study. Appointments to this Assignment Level will be made by the Technology Steering Committee through the Department of Information Technology and Telecommunications.

SPECIAL NOTE

Maximum tenure for all Assignment Levels in the title of College Aide is 6 years. No student shall be employed more than half-time in any week in which classes in which the student is enrolled are in session. Students may be employed full-time during their vacation periods.

Preferred Skills

• Working knowledge of formulas (e.g. VLOOKUP/XLLOOKUP, SUMIFS), Pivot tables, and dataset structuring
• Strong numerical aptitude with an ability to spot discrepancies, patterns, and errors in raw data
• High attention to detail, strong time management and the ability to track multiple requests simultaneously
• Clear written and verbal communication skill for team collaboration and administrative coordination
• Currently enrolled undergraduate or graduate student in Business, Finance, Accounting, Data Analytics, Public Administration, Computer Science, or a related field

Residency Requirement

New York City residency is generally required within 90 days of appointment. However, City Employees in certain titles who have worked for the City for 2 continuous years may also be eligibleto reside in Nassau, Suffolk, Putnam, Westchester, Rockland, or Orange County. To determine if the residency requirement applies to you, please discuss with the agency representative at the time ofinterview.

Additional Information

The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.