Data Quality & QA Analyst at New York City… · Manhattan

Summary: The New York City Criminal Justice Agency (CJA) is a not-for-profit organization focused on reducing jail overcrowding and unnecessary detention in New York City. They are seeking a Data Quality & QA Analyst to support software testing, KPI validation, and data migration efforts, ensuring data accuracy and integrity across their applications and platforms. 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 Required Qualifications: - 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 Preferred Qualifications: - Experience with Microsoft Dynamics - Exposure to AI or machine-learning driven testing - Experience within the criminal justice system or familiarity with criminal justice datasets Required Skills: SQL, Relational databases, Python, R, Excel, Power BI, Statistical concepts, Data validation techniques, Data warehousing, Azure Data Factory, Azure Data Lake Storage (ADLS), Azure Synapse, Agile software development, Azure DevOps, Microsoft Dynamics, AI-driven testing, Machine learning testing, Data analysis, Data profiling, Data reconciliation, Software testing, KPI validation, Data migration, Analytical skills Benefits: Health, dental and vision insurance, A comprehensive mental health, and wellness, Employee Assistance Program (EAP) plan, Four weeks’ vacation, Paid holidays, A 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