Senior Planning Analyst - Office of the District Attorney, Bronx County

JOB SUMMARY:

The Bronx District Attorney's Office in New York City serves a multicultural, international community of 1.4 million residents. Led by District Attorney Darcel D. Clark, the Bronx District Attorney's Office is one of the country's leading prosecutorial offices. The Office's mission of "Pursuing Justice With Integrity" captures its commitment to pursue a safer Bronx through fair justice.

BXDA's Strategic Planning and Analytics Unit serves as the internal management consulting arm of the Office. The unit uses cutting-edge data science and research analytics to support the Office's application of data-driven policies and practices. This unit is responsible for measuring office performance on prosecution indicators, evaluating the effects of policies and initiatives, conducting strategic analysis, and promoting transparency.  The unit also manages the Office's grants, which provide critical funding to support prosecutorial practices and victims of crime in the Bronx.

The data engineer will be an integral member of our data analytics team working collaboratively with a diverse team of analysts and alongside information technology and justice system practitioners. This position demands strong SQL and data management skills to assist with the expansion and maintenance of workflows in a Microsoft Azure data analytics and reporting pipeline. This position offers an opportunity to apply strong technical and analytic abilities to inform the implementation of fair and objective public safety policies and procedures. 

JOB RESPONSIBILITIES:

Specific duties will include, but are not limited to the following:

• Helping lead a system of reporting and analytic operations including database queries, updating and expanding stored procedures by leveraging programming languages (e.g., SQL, R, Azure data factory) to support reports and Power BI dashboards;
• Develop, implement, and document data management procedures and standards to ensure data quality and accuracy in the Unit’s reporting;
• Use advanced data transformation techniques (i.e., ETL) to standardize, check, clean, merge, and integrate disparate datasets from complex criminal justice databases; 
• Work closely with data analysts conducting quantitative data analysis and research or evaluation projects using a range of criminal justice administrative data sources;
• Collaborate with members of the Information Technology Unit in support of the goals of the Strategic Planning & Analytics unit;
• Help identify relevant data for measuring office performance and outcomes, and for use in statistical analysis to assess impacts and trends where accuracy is paramount; 
• Perform all other related duties and projects as assigned.

QUALIFICATIONS:

• Minimum of a bachelor’s degree in computer science, Information Systems, Information Technology, Data Science, or a related field.
• Minimum of four years of proven experience with SQL databases, ORACLE, XML, JSON or similar data systems  a related;  master’s degree may substitute for two years .
• Experience using SQL, Azure Data Factory, SSIS, or similar database pipeline solutions.
• Experience with data analysis programming languages such as R, SAS, PYTHON, Stata or similar.
• Excellent interpersonal, organizational, and communication skills
• Strong project management skills in a team-oriented environment
• Strong analytic ability with knowledge of research and statistical analyses
• Prefer knowledge of the criminal justice system and criminal justice databases
• Ability to multi-task and meet deadlines.

To Apply

We appreciate your interest in a position with the Bronx District Attorney's Office. To apply, cut and paste the following link into the browser: https://us.smrtr.io/3yj2X, or go to https://cityjobs.nyc.gov/ à Locate the "Search open jobs" field à Enter the Job ID 680965.

Upon your completion of the city application through Smartrecruiter, we will review your application and contact you if you are selected for an interview. If you have any questions or concerns, don't hesitate to contact Recruitment at 718-590-2258 or via email at bxdarecruit@bronxda.nyc.gov.

**LOAN FORGIVENESS: The federal government provides student loan forgiveness through its Public Service Loan Forgiveness Program (PLF) to all qualifying public service employees. Working with Bronx District Attorney’s Office qualifies you as a public service employee and you may be able to take advantage of this program while working full-time and meeting the program's other requirements. Please visit the Public Service Loan Forgiveness Program site to view the eligibility requirements: https://studentaid.ed.gov/sa/repay-loans/forgiveness-cancellation/public-service.

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.