Business Intelligence Analyst

Description

The New York City Department of Correction (DOC) is part of the city's criminal justice system, taking part in reform efforts aimed at shrinking the jail system while keeping the public safe. The DOC runs facilities and court commands across the five boroughs and employs more than 7,500 people.

The Office of Management, Analysis, and Planning (OMAP) is hiring a Business Intelligence Analyst to turn complex operational data into dashboards, automated reports and strategic insights. The role combines data engineering with visual analytics and supports executive leadership and operational divisions with accurate, near real-time views of agency performance, compliance metrics and strategic initiatives.

Responsibilities

• Build and maintain complex SQL queries across relational databases and central data warehouses to pull, transform and check operational records.
• Create and run scheduled data pipelines and executive dashboards in tools such as Tableau, Python (Dash) or Power BI.
• Set up and watch automated validation scripts that flag missing system entries, data mismatches and pipeline failures before they cause problems.
• Work with operational stakeholders to turn workflows and policy requirements into structured KPIs and performance scorecards.
• Run exploratory and descriptive analysis to find trends, gaps in system use and changes in performance over time.
• Prepare recurring executive briefings, compliance summaries and ad hoc data extracts for leadership.

Requirements

• For Assignment Level I, you need a master's degree from an accredited college or university in a relevant field of physical, biological or environmental science, or in public health.
• For Assignment Level II and above, you need one of the following: a doctorate from an accredited college or university in a relevant field of physical, biological, environmental or social science, plus one year of full-time supervisory, administrative or research experience in that field; or a master's degree from an accredited college or university in a relevant field of physical, biological, environmental or social science, plus three years of responsible full-time research experience in that field; or education and/or experience equivalent to either option.
• Under the equivalency route, you must still hold at least a master's degree in a relevant field and have at least two years of the experience described in the second option. Two years as a City Research Scientist Level I can replace the experience required in either option.

Conditions

Appointments to this position are subject to a probationary period of at least one year.

The company is an equal opportunity employer and bars discrimination and harassment based on any legally protected status or characteristic.