Data Quality & QA Analyst

NYC Criminal Justice Agency•New York, NY

4h•$90,000 - $115,000•Hybrid

About The Position

CJA's work seeks to reduce jail overcrowding and unnecessary detention in New York City. Join our team of multi-disciplined professionals! 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. NYCJA’s Information Technology team provides strategic vision, leadership, and innovative solutions to ensure that our 300+ staff across 13 locations have the trusted data and applications needed to deliver high-quality pretrial services and research. The IT team maintains a strong customer focus, partnering with business units and stakeholders to pilot new programs and develop custom applications with an eye toward future needs. Our team operates in a culture of mutual respect, trust, and collaboration, where flexibility, adaptability, and continuous improvement are expected. NYCJA is seeking a Data Quality & QA Analyst to support software testing, KPI validation, and data migration efforts across our data platform and applications. In this role, you will validate system outputs, ensure data accuracy across pipelines and reports, and work closely with developers, data engineers, and business stakeholders to confirm that business logic is correctly implemented. You will play a key role in testing data integrations, validating KPI calculations, and ensuring data integrity during system changes and migrations. Work within evolving requirements, shaping and refining KPI definitions and program logic.

Requirements

3+ years of experience in data analysis, data validation, or QA with large and incomplete datasets
Bachelor’s degree in statistics, mathematics, computer science, or equivalent experience
Strong SQL skills and experience working with relational databases (SQL Server / Azure SQL)
Proficiency in using Python or R to aid in automation or debugging
Experience with Excel and Power BI (or similar visualization tools)
Familiarity with statistical concepts and data validation techniques
Familiarity with data warehousing concepts and cloud platforms Azure (Data Factory, ADLS, Synapse)
Experience working in an Agile software development organization (Azure DevOps test plans, work tracking)
Strong analytical, problem-solving, and troubleshooting skills
Highly organized, detail-oriented, and able to manage multiple priorities
Strong communication skills with the ability to collaborate across technical and non-technical teams
Ability to evaluate and adopt new testing tools, frameworks, and practices.
Self-motivated and able to work independently with minimal supervision

Nice To Haves

Experience with Microsoft Dynamics is preferred
Exposure to AI or machine-learning driven testing
Experience within the criminal justice system or familiarity with criminal justice datasets is desired

Responsibilities

Perform data profiling, validation, anomaly detection, and reconciliation across large datasets to assess data quality and integrity
Write and optimize SQL queries to identify data exceptions and support data cleansing and remediation
Analyze data from multiple sources to identify trends, inconsistencies, and gaps
Collaborate with development and data engineering teams to improve data collection, validation, and storage processes
Act as a bridge between business logic and technical implementation, ensuring data reflects real-world program definitions
Design and execute test cases focused on data accuracy, transformations, and business logic
Validate end-to-end data flows across systems (ingestion → transformation → reporting)
Use SQL to validate backend data against application outputs and reports
Participate in sprint testing cycles, including regression and release validation
Document defects clearly with supporting data evidence and work with teams to resolve issues
Report data quality findings, trends, and risks to stakeholders to inform business decisions and system improvements
Prepare and present data, reports, and dashboards for both technical and non-technical audiences
Support QA/QC efforts across the department and contribute to documentation and process improvements

Benefits

health insurance
dental insurance
vision insurance
comprehensive mental health, and wellness, Employee Assistance Program (EAP) plan
four weeks’ vacation
paid holidays
retirement plan with employer matching contributions
professional learning and development for its staff members
varied opportunities for learning and development through partnerships and vendor services for web based, in-person professional development training
in-house job training and development