Job Title: Data Engineer
PVN ID: JJ-2212-005281
Category: Administrative Services
Location: JOHN JAY COLLEGE OF CRIMINAL JUSTICE

Job Description

General Description

The Data Collaborative for Justice 
The Data Collaborative for Justice (DCJ) is a research institute launched at John Jay College of Criminal Justice in 2013. DCJ seeks to advance justice and equity through rigorous research on mass incarceration, racial disparities, bail reform, case backlog, pretrial diversion, low-level enforcement, and other justice reform topics. DCJ partners with reformers, think tanks, and state and local agencies in New York and maintains a small portfolio of partnerships around the nation. DCJ also provides technical assistance to the Mayor’s Office of Criminal Justice of New York City to process administrative data and conduct criminal justice research, including data analysis, data engineering, and data product development. This position is for a Data Engineer under the technical assistance project. DCJ operates under the Research Foundation of the City University of New York (RF-CUNY).

The Mayor’s Office of Criminal Justice
The successful applicant will work on a daily basis with the Executive Director of Information Technology at the Mayor’s Office of Criminal Justice (MOCJ). MOCJ advises the Mayor of the City of New York on criminal justice policy. MOCJ develops and implements strategies to reduce crime and incarceration and promote fairness and legitimacy. MOCJ works with other city agencies, law enforcement, nonprofits, foundations, and others to implement data-driven strategies that address current crime conditions, prevent offending, and build the strong neighborhoods that ensure enduring safety. Over the past decade, the office has an extensive record of quality in-house research, funding and supporting research by partner agencies, and publishing important data on criminal justice reforms and trends. To perform its work effectively, MOCJ houses, maintains, and analyzes data from multiple city and state systems.

Position
DCJ is seeking a Data Engineer to join our unit responsible for providing technical assistance to MOCJ. The position will primarily work with the Data and Technology group and the Executive Director of Information Technology at MOCJ. The Data Engineer will assist in managing and supporting the agency’s data platform and data pipelines and addressing new needs as they arrive. The Data Engineer will also participate in the implementation of City’s new data exchange platform. Work will include migrating existing data pipelines and development of new procedures. The candidate is expected to work independently, possess a variety of analytic and data management skills and be actively involved in the full life cycle of data management including acquisition, processing, quality assurance/quality control, documenting and cataloging.

Other Duties

Responsibilities:
The Data Engineer’s responsibilities include, but are not limited to:

  • Maintain, extend and support the agency’s data platform and data pipelines;
  • Develop new data pipelines in collaboration with agency business owners;
  • Work with technologies and platforms including Redshift, Snowflake, Azure, Tableau, Informatica, Python, JavaScript and SQL.
  • Ensure agency compliance with all relevant data security and privacy policies;
  • Develop and oversee quality assurance/quality control procedures;
  • Develop processes to automate testing and deployment of code, and 
  • Document all processes and procedures.

Qualifications

Core Competencies:

  • Ability to secure any necessary security clearances;
  • Ability to monitor and evaluate the work of others, consistent with RF policies and contracts; 
  • Ability to communicate effectively with technical and program staff; 
  • Knowledge of policies regarding intellectual property, use of facilities and equipment, allocation of time and materials to project costs, and utilization of IT resources, and
  • Knowledge of protocols for safe conduct of research, including but not limited to the study of human subjects and establishment of safety reporting procedures. 

Qualifications:
The successful candidate must be highly organized, pay close attention to detail, and be results- driven, flexible, a problem-solver, and a self-starter. In addition, the preferred candidate should possess the following:

  • Bachelor’s Degree and a minimum of 3 years of experience.
  • Knowledge of the principles, practices, and methods of data management.
  • Knowledge of data structures, formats, metadata and cataloging standards, and database technologies.
    Programming proficiency in SQL, Python and JavaScript.
  • Demonstrated experience with the aforementioned tools. 
  • Experience managing data and automating data pipelines. 
  • Ability to balance competing priorities, complex situations and tight deadlines. 
  • Ability to work independently in a fast-paced environment.
  • Ability to work comfortably with a wide variety of people at different levels within and outside the organization.
  • While not required, prior work related to the criminal justice system and an interest in learning about ongoing criminal justice reforms in New York City is desirable;
  • Well organized with strong communication skills.

Work Model: Hybrid of in-person and remote. Offices in Midtown/ Downtown Manhattan.


Salary: Range of $115,000 to $130,000 per year in New York, NY. Final salary will be based on the skills and experience of the successful applicant; extensive relevant experience will be required for the upper end of the advertised range.

Benefits: Competitive health insurance plan with vision and dental; generous annual leave time and holiday schedule; 403b and Group Retirement Annuity; Life & disability insurance, and more benefits of RFCUNY system available immediately or after a period of service.

To Apply: 
Please go to www.rfcuny.org. Under “About RF” there is a link for “Careers.”  Please choose John Jay College of Criminal Justice to find the position.  

For Additional Information: 
DCJ website: https://datacollaborativeforjustice.org/ 
MOCJ website: http://www1.nyc.gov/site/criminaljustice/index.page

For any questions about the position, please contact Richie Lin at tlin@jjay.cuny.edu.

About the Research Foundation

The Research Foundation of The City University of New York (RFCUNY) was established as a not-for-profit educational corporation chartered by the State of New York in 1963. RFCUNY supports CUNY faculty and staff in identifying and obtaining external support (pre-award) from government and private sponsors and is responsible for the administration of all such funded programs (post-award).

RFCUNY stands between CUNY’s principal investigators (PIs) and the sponsors who support them and strives to fulfill its essential responsibilities to both groups. Working closely with individual PIs and Grants Officers on the campuses, RFCUNY oversees employment, accounting, audit, reporting, purchasing, and special responsibilities that include management of a planned giving program; liaison with governmental agencies and foundations; negotiation of agreements; facility construction and renovation; protection and commercialization of intellectual property; and compliance with applicable standards in research involving human subjects, animal care, environmental and radiological safety, and conflicts of interest.

Equal Employment Opportunity Statement

The Research Foundation of the City University of New York is an Equal Opportunity/Affirmative Action/Americans with Disabilities Act/E-Verify Employer. It is the policy of the Research Foundation of CUNY to provide equal employment opportunities free of discrimination based on race, color, age, religion, sex, pregnancy, childbirth, national origin, disability, marital status, veteran status, sexual orientation, gender identity, genetic information, marital status, domestic violence victim status, arrest record, criminal conviction history, or any other protected characteristic under applicable law.

Key Features

Department
Status
Full Time
Annual Salary Range
$115,000.00 - $130,000.00
Closing Date
Feb 01, 2023 (Or Until Filled)
Bargaining Unit
No

Actions