City Research Scientist II: Data Analytics and Transparency

City of New York; New York (NY); On-site; USD 88,000 - 110,000; Full time

Job summary

The City of New York's Department Advocate's Office seeks a City Research Scientist II to join a team of analysts at 1 Police Plaza, NY. You will support disciplinary tracking, perform trend analyses, and develop dashboards to inform executive decisions and transparency goals.

Responsibilities include collaborating with attorneys, prioritizing data requests, and presenting clear findings to non-technical audiences, with a strong emphasis on data-driven process improvement.

Qualifications

• Strong verbal and written communication skills.
• Proficiency in performing statistical analyses with large datasets.
• Experience using Excel spreadsheets and relational databases.
• Proficiency in programming, data analytic and visualization software (SQL, Python, R, Excel Macros, Power Query, Power BI, Dynamics 365, etc.).

Responsibilities

• Test new changes and document results for the enhancement and project development of the disciplinary tracking system utilized within DAO.
• Perform trend analysis and assist DAO in conducting research, investigations and the design and execution of future database projects.
• Assist with the development and maintenance of Power BI dashboards and reports.
• Articulate data findings in a clear and concise manner to non-data audiences.
• Monitor and analyze the effectiveness of key metrics established for the various case flow procedures.
• Identify trends, demographics, and other valuable information to enable the NYPD to take proactive steps related to the discipline of its employees.
• Utilize data to evaluate processes and prepare reports which include detailed analyses and findings.
• Conduct long-term and short-term analytic projects to endure the goals of the Department regarding transparency and the expeditious resolution of cases are met.
• Collaborate with Attorneys to build process flows and tracking tools for cases.
• Ability to prioritize deadlines based on the volume of data requests and source of request.

Skills

Verbal communication

Written communication

Statistical analysis

Excel

Relational databases

Data analysis

Power BI

Python

R

SQL

Dynamics 365

Office Suite

Education

Master's degree in physical/biological/public health sciences

Doctorate degree in relevant field

Tools

SQL

Python

R

Excel Macros

Power BI

Power Query

Dynamics 365

Excel

Job description

The City of New York's Department Advocate's Office seeks a City Research Scientist II to join a team of analysts at 1 Police Plaza, NY. You will support disciplinary tracking, perform trend analyses, and develop dashboards to inform executive decisions and transparency goals.

Responsibilities include collaborating with attorneys, prioritizing data requests, and presenting clear findings to non-technical audiences, with a strong emphasis on data-driven process improvement.