The Kings County District Attorney’s Office (KCDA) is one of the largest prosecutors’ offices in the country and is committed to developing and implementing innovative prosecutorial strategies that will fulfill our vision of keeping Brooklyn safe while at the same time ensuring fairness and justice for all. KCDA has an exciting opportunity to work as a Data Analyst in its Case Management Services Unit. The Office’s Case Management Services Unit (CMS) provides essential support to the Office’s legal practice, ensuring the collection, entry, and auditing of complete, timely, and high-quality data from court proceedings and other sources. CMS data is relied upon by assigned prosecutors preparing their cases, prosecutors appearing in court, and supervisors throughout the Office and supports the Office’s reporting, analysis, and transparency initiatives, and its staff are a critical part of the Office’s mission to keeping Brooklyn safe while building community trust by ensuring fundamental fairness in the criminal justice system. In this position, reporting directly to the Director of CMS, the Data Analyst will prepare various data integrity reports and will resolve data discrepancies. The Data Analyst will also be responsible for collaborating with other departments on data-driven projects consistent with Office priorities.
Responsibilities:
- Review and analyze information captured by CMS staff-- including previously entered data-- for completeness and accuracy using knowledge of practice and procedure as well as all available sources of information to identify and resolve inaccurate, inconsistent, or incomplete entries.
- Create SQL data audit reports as needed by CMS and other departments.
- Audit and review data for accuracy, completeness and consistency.
- Identify discrepancies, errors, or missing information and provide corrective actions.
- Provide daily reports from on-the-record proceedings using all relevant information entered according to the Office’s standardized case data structure into the appropriate Office data systems.
- Understand the workflow of the Office and provide problem-solving strategies
- Collaborate with IT and other departments to further improve efficiency of in-house applications.
- Facilitate communication between the District Attorney’s Office, Office of Court Administration, Police Department, and other various parties involved in the justice system when discrepancies arise.
- Inform the Office of Court Administration of various discrepancies to avoid incorrect adjournments, pleas, sentencing and other issues that could lead to incorrect information on criminal history reports.
- The CMS Data Analyst may attend various training courses required for court testimony and professional development as an analyst.
- Perform related tasks and assignments as required.
Preferred Skills
- Must be able to perform under pressure and prioritize tasks among competing needs.
- Proven experience in Microsoft SQL Server, Microsoft SQL Reporting Services, Power BI and Microsoft Office Suite.
- Must be very detail-oriented, self-motivated, highly organized, and must possess a very high concern for data accuracy.
- Must be a dependable team player.
- Possess strong communication skills with an ability to interact with all levels of staff, with a high regard for confidentiality and diplomacy.
- Possess strong analytical and problem-solving skills.
COMMUNITY ASSOCIATE - 56057
Qualification Requirements
1. High school graduation or equivalent and three years of experience in community work or community centered activities in an area related to duties described above; or
2. Education and/or experience which is equivalent to "1" above.
The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.

The City of New York is the most iconic and dynamic city on the planet. With a population of more than 8.4 million people, New York is not only the largest city in the United States — it is the academic, cultural, commercial, and financial capital of the world.
City government is filled with opportunities for talented individuals seeking to improve their communities and make a meaningful difference in the lives of their fellow New Yorkers. Every day, the City’s more than 300,000 employees improve infrastructure, provide vital social services, build technology, protect health and safety, and so much more. Join us today at: http://www1.nyc.gov/jobs
The City of New York offers its employees:
• A chance to build the future of this city. New York City government is at the crossroads of where policy, great ideas, city services, and smart urban planning meet the lives and needs of every day New Yorkers.
• Competitive salary and benefits. Hiring packages include a competitive salary, health benefits, various pension plans, employee assistance programs, and individual retirement accounts.
• Diverse career opportunities. As the largest local government in the United States with more than 40 agencies, the City of New York offers a broad spectrum of opportunities — from education, housing development, and public health to sustainability, economic growth, technology, and emergency management.
• Career Satisfaction. As a City employee, you will have the chance to shape the future of New York City and improve the quality of life for your family, neighbors, and fellow New Yorkers.
• Equal Opportunity and Inclusion. The City of New York is an equal opportunity employer that prohibits discriminatory action against City employees and applicants for employment based on their actual or perceived race, color, national origin, ethnicity alienage, citizenship status, gender, religion, creed and all other protected categories.