Business Intelligence Analyst
About The Position
The New York City Department of Correction (DOC) is seeking a skilled and proactive Business Intelligence Analyst in the Office of Management, Analysis, and Planning (OMAP). The role transforms complex operational data into actionable dashboards, automated reporting pipelines, and strategic insights. It supports executive leadership and operational divisions by providing high-integrity, real-time visibility into agency performance, compliance metrics, and strategic initiatives. The DOC maintains a safe and secure environment for employees, visitors, volunteers, and people in its custody. It operates facilities and court commands across the five boroughs and has more than 7,500 professionals. The role contributes to this work by supporting operational analysis, reporting, and data governance.
Requirements
- For City Research Scientist Assignment Level II and above, candidates must meet one of the stated education and experience pathways: a doctorate in an appropriate physical, biological, environmental, or social science specialization and one year of responsible supervisory, administrative, or research experience; a master's degree in an appropriate specialization and three years of responsible full-time research experience; or equivalent education and/or experience.
- Under the equivalent pathway, candidates must have at least a master's degree in an appropriate specialization and at least two years of the specified research experience.
- Two years as a City Research Scientist Level I may substitute for the experience required in the doctorate or master's pathways.
- Appointments are subject to a minimum one-year probationary period.
Responsibilities
- Write, optimize, and maintain complex SQL queries across relational databases and centralized data warehouses to extract, transform, and validate operational records.
- Design, build, and maintain automated scheduled data pipelines and executive dashboards using tools such as Tableau, Python (Dash), or Power BI.
- Establish and monitor automated data validation scripts to identify system entry gaps, data discrepancies, or pipeline failures.
- Collaborate with operational stakeholders to translate workflows and policy mandates into structured KPIs and performance scorecards.
- Conduct exploratory and descriptive data analysis to identify trends, system utilization gaps, and longitudinal performance shifts.
- Prepare recurring executive briefings, compliance summaries, and ad hoc data extracts for leadership, legal, or oversight reviews.
- Partner with enterprise IT to reconcile discrepancies between front-end data entry applications, legacy administrative systems, and centralized data warehouses.
- Contribute to standardizing data dictionaries, field mappings, and master data management practices across operational units.
- Document data extraction methodologies, reporting logic, and pipeline workflows to ensure institutional continuity.
