Data Analyst

Job Description

The New York City Department of Investigation (DOI) is one of the oldest law enforcement agencies in the country with a mission of combating municipal corruption. It serves the people of New York City by acting as an independent and nonpartisan watchdog for New York City government, City agencies, and City employees, vendors with City contracts, individuals and entities that receive City funds.

DOI seeks a Data Analyst who will support the criminal and policy-driven investigations of the Inspectors General. The Data Analyst will assist DOI investigators with building and enhancing complex investigations through large scale data collection and analysis.
The Data Analyst is expected to:
* Develop and enhance practices for identifying patterns and trends related to fraudulent financial activity.
* Ensure the collection, management, and analysis of quality data from external sources.
* Conduct quality assurance of data.
* Maintain, summarize, and report on outcomes of data searches.
* Work collaboratively with DOI investigators to generate investigative leads, create reports, and interpret data.
* Present findings in a cogent manner through detailed and accessible reports to key decision-makers.

If selected, the candidate will be fingerprinted and undergo a background investigation. In addition, for positions that have a law enforcement and/or investigative function, the candidate's consumer credit history will be reviewed during the background investigation, and as otherwise permitted by NYC Administrative Code * 8-107(24)(b)(2)(A).

Minimum Qual Requirements

1. A four-year high school diploma or its educational equivalent approved by a State's Department of Education or a recognized accrediting organization and four years of satisfactory full-time experience in an industrial or governmental agency in the field of investigation, auditing, law enforcement, security, inspections, or in a major operational area of the agency in which the appointment is to be made; or

2.A baccalaureate degree from an accredited college or university; or

3. Education and/or experience equivalent to "1" or "2" above.

Preferred Skills

* Experience working with data analytics.
* Bachelor's degree in Finance, Accounting, or Information Technology, Computer Science, or Information Systems.
* Advance knowledge in MS Excel: VBA, Data Models, and ability to create Pivot Tables and complex nested formulas.
* Strong written and verbal communication skills.
* Knowledge in SQL and experience with any RDBMS: MS SQL Server (T-SQL), Oracle (PL/SQL), MySQL (SQL/PSM), and PostgreSQL (PL/pgSQL).
* Knowledge in Python, R, C++ ,and/or Java.
* Knowledge in analytics software (i2 Analyst Notebook, Palantir, Cognos, etc.).
* Database related certifications from Oracle or Microsoft.
* Demonstrated interest in law enforcement, criminal justice, or social service.

To Apply

All current City Employees may apply by going to Employee Self Service (ESS) http://cityshare/ess then click on Recruiting Activities/Careers and Search for the specific Job ID# 435571.

All other applicants please go to www.nyc.gov/career/search and search for the specific Job ID# 435571.

Please do not email, mail or fax your resume to DOI directly. Submissions of resumes does not guarantee an interview. Due to the high volume of resumes DOI receives for positions, only selected candidates will be contacted.

Appointments are subject to Office of Management & Budget approval for budgeted headcount.

The City of New York is an equal opportunity employer and is strongly committed to a policy of non-discrimination. We are committed to recruiting a diverse and inclusive talent pool.

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 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. PDN-90b4b284-378a-49da-be0a-e6018dc2d220