Back to jobs
New

Senior Data Engineer

Manhattan, New York

 

SENIOR DATA ENGINEER
INFORMATION TECHNOLOGY

Posted: 8/19/2025

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 over 100,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 300 employees, citywide.

PROGRAM SUMMARY 

NYCJA’s Information Technology team provides strategic vision, leadership, and innovative solutions so that our 300+ staff at 13 locations have the trusted data and applications they need to deliver high-quality pretrial services and research. IT staff have a strong customer focus, partnering with business units and stakeholders to pilot new programs and create custom applications with an eye toward future business needs. Our dedicated professionals meet challenges head-on by being flexible, embracing change, and supporting each other in a culture of mutual respect, trust, and teamwork that encourages personal and professional growth. 

PRIMARY RESPONSIBILITIES 

PLATFORM OPERATIONS & MAINTENANCE 

  • Support the Azure SQL Server environment powering operational applications and analytics. 
  • Support NYCJA’s event-driven, real-time data processing system that computes and delivers live KPIs and measures to dashboards, applications, and external partners. 

PIPELINE ENGINEERING 

  • Partner with Product, Analytics, and DevOps teams as NYCJA expands its data platform to support modern analytics use cases. 
  • Collaborate cross-functionally with Product, Analytics, DevOps, and Data teams to build reliable streaming and batch pipelines 
  • Document, version, and test all pipelines to support current and future business requirements. 
  • Manage daily operation of Lakehouse pipeline engineering and technical projects 

DATA STORAGE & MODELING 

  • Collaborate with the Data Architect and IT leadership to design and evolve layered data storage and analytics environments. 
  • Implement dimensional models and data structures to enable unified reporting and analytics across systems. 
  • Implement big data solutions in a Cloud data platform. 

REPORTING & BI  

  • Support and optimize existing SSRS and Power BI reports sourced from SQL Server. 
  • Publish certified datasets and semantic models in Power BI, integrating SQL Server and Azure sources. 

DEVOPS & INFRASTRUCTURE AS CODE 

  • Embed CI/CD as a cornerstone of sustainable delivery using Azure DevOps or equivalent pipelines. 
  • Provision cloud resources using infrastructure-as-code tools and manage SQL Server schemas with automation. 

QUALITY, SECURITY & MONITORING 

  • Automate data quality checks, enforce RBAC, encryption, and auditing across SQL Server and Azure. 
  • Surface metrics, configure proactive alerts, and manage incident response. 
  • Support data cataloging, lineage, and sensitivity classification for CJIS and HIPAA compliance. 

TEAM 

  • Participate in code reviews, backlog refinement, and cost-optimization sessions. 
  • Participate in a rotating 24×7 on-call schedule to support SQL Server and Azure data operations 

REQUIRED QUALIFICATIONS AND SKILLS

  • Bachelor’s degree in data science, Computer Science, Information Technology or equivalent experience.   
  • 4+ years building and operating data solutions in SQL Server and Azure or equivalent cloud environments. 
  • 2+ years of experience with event streaming technologies such as Kafka or Azure Event Hubs. 
  • 2+ Big data Cloud Data Platform experience is required
  • 2+ years of technical leadership (sprint planning, code review, mentoring) in an agile environment. 
  • Expert T-SQL performance-tuning skills and advanced scripting or data engineering experience (e.g., Python). 
  • Hands-on experience with complex data integration, orchestration, monitoring, and reporting tools. 
  • Excellent written and verbal communication skills; able to translate justice-domain needs into scalable hybrid-cloud solutions. 
  • Able to work independently with minimal guidance.  

Schedule: Tues-Thurs on site/ Mon & Friday work from home 

**Please note this role may occasionally require additional in office days

SALARY: $115,000- $125,000 annually

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.

BENEFITS: CJA offers a very generous benefit plan including health, dental and vision insurance, a comprehensive mental health, and wellness, Employee Assistance Program (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: Only those candidates being considered will be contacted.

CJA is seeking applicants who pursue professional development pathways by participating in educational opportunities, reading professional publications, maintaining professional networks, and engaging with professional associations

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

CJA is committed to creating a diverse work environment and is proud to be an equal opportunity employer. We do not discriminate based on race, color, national origin, sex, gender identity, religion, sexual orientation, age, disability, parental status, veteran status, or any other protected status under applicable laws. We encourage individuals of all backgrounds to apply.

 

Create a Job Alert

Interested in building your career at NYC Criminal Justice Agency? Get future opportunities sent straight to your email.

Apply for this job

*

indicates a required field

Resume/CV*

Accepted file types: pdf, doc, docx, txt, rtf

Cover Letter

Accepted file types: pdf, doc, docx, txt, rtf

Education

Select...
Select...
Select...
Select...
Select...
Select...

U.S. Standard Demographic Questions

We invite applicants to share their demographic background. If you choose to complete this survey, your responses may be used to identify areas of improvement in our hiring process.
Select...
Select...
Select...
Select...
Select...
Select...

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey. 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.

As set forth in NYC Criminal Justice Agency’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.

Select...
Select...
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 the 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.

Select...

Voluntary Self-Identification of Disability

Form CC-305
Page 1 of 1
OMB Control Number 1250-0005
Expires 04/30/2026

Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, 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?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

  • Alcohol or other substance use disorder (not currently using drugs illegally)
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
  • Blind or low vision
  • Cancer (past or present)
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or serious difficulty hearing
  • Diabetes
  • Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
  • Epilepsy or other seizure disorder
  • Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
  • Intellectual or developmental disability
  • Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
  • Missing limbs or partially missing limbs
  • Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
  • Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
  • Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
  • Partial or complete paralysis (any cause)
  • Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
  • Short stature (dwarfism)
  • Traumatic brain injury
Select...

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.