About the New York City Police Pension Fund
The New York City Police Pension Fund (NYCPPF or the “Fund”) is dedicated to providing superior service to its 36,000 active members and 43,000 retired members of the New York City Police Department (NYPD). We remain committed to providing courteous, professional service by providing customized attention throughout our lifelong partnership with the uniformed staff of the NYPD and their families. We are looking for individuals with passion, dedication and commitment to excellence and innovation who are interested in adding to our dynamic and collaborative work environment. Please visit us at www.nyc.gov/nycppf to learn more.

Job Description
Under the supervision of the Director of the Management Analysis and Planning (MAP) Unit, the employee will be responsible for the processing of member annual statements, preparation of reports, performing analyses and assessing data quality. Duties and responsibilities include, but are not limited to, the following:

- Completing bi-weekly verifications and validations of pension transactions for the accounting operations within the Pension Administration System;
- Running and monitoring batch imports. Evaluating exception reporting and driving the batch process to completion;
- Analysis of SQL reports using the data available in the existing pension administration system (Oracle Based);
- Monitoring and reporting on data quality assurance issues;
- Responding to business questions using data / system analysis;
- Assisting the business units with inquiries and performing quality assurance tasks related to large, annual processing of member annual statements and data audits;
- Reviewing and auditing computer output accuracy and coordination of activities with other units within the agency;
- Performs other special projects as may be required;
- Assisting the unit supervisor with COPS 2.0 related tasks.

Qualification Requirements
1. High school graduation or equivalent and three years of experience in community work or community centered activities in an area related to duties described above; or
2. Education and/or experience which is equivalent to "1" above.

- Strong computer skills, including proven expertise with Microsoft Office Word, Excel and PowerPoint - SQL and data report experience, including batch processing - Strong math and computation skills - Experience with business and data analysis - A baccalaureate degree from an accredited college in computer science or a related field.

As a prospective employee of the City of New York, you may be eligible for federal loan forgiveness programs and state repayment assistance programs. For more information, please visit the U.S. Department of Education’s website at https://studentaid.gov/pslf/.

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 eligible to 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 of interview.

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.