Data Analyst

Posted: 10/6/2021

Join our team of professionals seeking to improve the experience of justice-involved individuals in the NYC Courts!

 

ABOUT CJA

The New York City Criminal Justice Agency (CJA) is a not-for-profit service and research organization that operates in partnership with the New York City Mayor’s Office of Criminal Justice.  CJA is the City’s main pretrial services agency, combining operations, pilot projects, and research under one roof.  CJA utilizes procedural justice practices to provide pretrial services to approximately 200,000 persons arrested annually in New York City. Information collected about these arrestees and subsequent case processing is maintained in the agency’s internal and externally shared database systems, which are used to conduct descriptive and evaluation research on arrestee characteristics, case processing and court outcomes, and on issues and potential reforms to criminal justice policy in New York City. CJA’s programs operate in the criminal courts and detention facilities 24 hours a day seven days a week within the 5 boroughs of NYC, employing over 250 employees, citywide.

­­­­­­­­­­­­­­CJA VALUES

Each employee at CJA is guided by these values in our work:

  • Commitment: We are committed to being active partners in criminal justice reform through initiatives and creative problem-solving that evaluates different methods and strategies for alternatives to detention.
  • Fairness: We are guided by fairness and the presumption of innocence for those who are detained and work with integrity and without bias to protect the privacy and interest of court-involved people and their families.
  • Innovation: We value curiosity as a driving force to lead the way in pretrial services. We use innovative techniques in research, pilot programs, and engaging justice-involved communities to execute our mission of reducing unnecessary pretrial detention.

POSITION SUMMARY

The Data Analyst will process, manage, and assemble quantitative datasets for CJA’s Research Department. This individual will support the ongoing restructuring of CJA’s database and the production of new measures by collaborating closely with colleagues in the Research and IT Departments. The Data Analyst also will track and report on key statistical metrics related to case processing and court outcomes.

PRIMARY RESPONSIBILITIES

  • Program complex measures via SQL syntax
  • Create and shape research datasets
  • Respond to user feedback by modifying stored procedures
  • Create data-cleaning routines for research datasets
  • Design procedures to optimize automation for recurring projects
  • Document design of data processing and quality through technical memos, codebooks, comments, and good programming practices
  • Investigate and problem solve data issues with high level of complexity
  • Maintain syntax stored in code repository
  • Prepare statistical tables to display research findings
  • Participate in writing and editing reports

REQUIRED QUALIFICATIONS

  • Bachelor's degree required in data science, criminal justice, economics, political science, public policy, sociology, or related field
  • At least 1 year of experience with SQL (Microsoft SQL Server/T-SQL preferred)
  • Export data efficiently and accurately from relational databases, using advanced SQL techniques
  • Experience with at least one of the following: Python, R, SPSS, or Stata
  • Experience merging and analyzing large quantitative datasets
  • Experience with Excel
  • The ability to work both independently and collaboratively, with a high level of organization
  • The ability to handle a variety of tasks and assignments concurrently while adhering to specific instructions, technical direction, and deadlines
  • Keen attention to detail
  • Desire to learn about the idiosyncrasies of processing criminal justice system data
  • A willingness to take initiative and see complex tasks through to completion

The ideal candidate will also have experience with inferential statistical methods (e.g., chi-square tests, t-tests, factor analysis, multivariate regression) and the use of Power BI.

LOCATION: Lower Manhattan

SALARY: $58-$62K

BENEFITS: CJA offers a very generous benefit plan including health, dental and vision insurance, a comprehensive mental health and wellness (EAP) plan, four weeks’ vacation, paid holidays and a retirement plan with employer matching contributions.  CJA is also strongly committed to professional learning and development for its staff members and offers staff varied opportunities for learning and development through partnerships and vendor services for web based, in-person professional development training, as well as in-house job training and development.

Note: This position is expected to operate on a hybrid schedule with in-person work at least 3 days per week through the end of 2021.  The successful hire must be able to assume responsibilities that are both remote and on-site, in accordance with CJA policy at the time of hire. Terms and conditions are subject to change based on business needs and prevailing public health guidelines.

COVID-19 GUIDELINES

Effective October 1, 2021 all new hires must be fully vaccinated and show proof of vaccination on, or before their official start date. Failure to provide proof of vaccination will result in revocation of CJA’s offer of employment.

The New York City Criminal Justice Agency is an Equal Opportunity Employer

CJA is committed to creating and retaining a workforce of diverse talent and a culture of inclusion and belonging that honors and welcomes people with a variety of backgrounds, experiences, and perspectives. We are proud to be an equal opportunity employer with a track record of encouraging and supporting the employment of people with lived experiences in the legal system. We are dedicated to advancing our mission and work by recruiting and building multi-disciplinary teams that reflect the racial, ethnic, culture and gender identities of the clients and communities we serve.

We encourage individuals of all backgrounds to apply. Our employment practices are equitable and fair, without consideration of race, color, national origin, sex, gender identity, religion, sexual orientation, age, disability, prior arrest or conviction, employment status, parental status, veteran status, or any other protected status under applicable laws.

 

 

Apply for this Job

* Required
  
  
When autocomplete results are available use up and down arrows to review
+ Add Another Education


Diversity, Equity and Inclusion

At CJA, we are committed to intentional talent management  that  seeks to recruit, retain and develop employees whose racial, ethnic, cultural, gender, orientation, and identities  contribute to a rich workforce of varied experiences and abilities at all levels. We seek to build and sustain a workforce reflective of the communities we serve within the City of New York.

The information requested supports our pursuit of a diverse and talented workforce rooted in inclusion and belonging.  Your individual responses are not visible to hiring managers or any administrator of CJA.  Demographic and personal data is only provided as aggregate reports of the entire applicant pool to Human Resources for strategic planning.  No information is attributed to any individual person and will have no influence on your candidacy for positions for which you qualify. 

We hope that you will choose to participate in the Talent Diversity Survey and help us build dynamic teams of talented and experienced people. 

Ethnicity (Optional) : To the extent you feel comfortable, please indicate your ethnicity (Note: These options were adapted from the US Census.)



Race (Optional): To the extent you feel comfortable, please select all the options that best describe your race. (Check all that apply) (Note: These options were adapted from the US Census.)









Gender Identification (Optional): To the extent you feel comfortable, please indicate which of these gender identities best describes you.




Ability Optional): To the extent you feel comfortable, please indicate whether you identify as a person with a disability or exceptionality, or are differently-abled



Lived Experience (Optional): To the extent you feel comfortable please indicate whether you identify as a person with lived experience in the criminal justice system, substance use, mental or behavioral health



U.S. Equal Opportunity Employment Information (Completion is voluntary)

Individuals seeking employment at NYC Criminal Justice Agency are considered without regards to race, color, religion, national origin, age, sex, marital status, ancestry, physical or mental disability, veteran status, gender identity, or sexual orientation. You are being given the opportunity to provide the following information in order to help us comply with federal and state Equal Employment Opportunity/Affirmative Action record keeping, reporting, and other legal requirements.

Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.


Form CC-305

OMB Control Number 1250-0005

Expires 05/31/2023

Voluntary Self-Identification of Disability

Why are you being asked to complete this form?

We are a federal contractor or subcontractor required by law to provide equal employment opportunity to qualified people with disabilities. We are also required to measure our progress toward having at least 7% of our workforce be individuals with disabilities. To do this, we must ask applicants and employees if they have a disability or have ever had a disability. Because a person may become disabled at any time, we ask all of our employees to update their information at least every five years.

Identifying yourself as an individual with a disability is voluntary, and we hope that you will choose to do so. Your answer will be maintained confidentially and not be seen by selecting officials or anyone else involved in making personnel decisions. Completing the form will not negatively impact you in any way, regardless of whether you have self-identified in the past. For more information about this form or the equal employment obligations of federal contractors under Section 503 of the Rehabilitation Act, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

You are considered to have a disability if you have a physical or mental impairment or medical condition that substantially limits a major life activity, or if you have a history or record of such an impairment or medical condition.

Disabilities include, but are not limited to:

  • Autism
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, or HIV/AIDS
  • Blind or low vision
  • Cancer
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or hard of hearing
  • Depression or anxiety
  • Diabetes
  • Epilepsy
  • Gastrointestinal disorders, for example, Crohn's Disease, or irritable bowel syndrome
  • Intellectual disability
  • Missing limbs or partially missing limbs
  • Nervous system condition for example, migraine headaches, Parkinson’s disease, or Multiple sclerosis (MS)
  • Psychiatric condition, for example, bipolar disorder, schizophrenia, PTSD, or major depression

1Section 503 of the Rehabilitation Act of 1973, as amended. For more information about this form or the equal employment obligations of Federal contractors, visit the U.S. Department of Labor's Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.