Business Intelligence Analyst

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

Job summary

The City of New York Department of Correction is seeking a skilled Business Intelligence Analyst to transform complex operational data into actionable dashboards, automated reporting, and strategic insights. You will bridge data engineering and visual analytics to support executive leadership and agency performance monitoring.

Ideal candidates hold a master’s (or doctorate) in a relevant science or public health field and have experience translating policies into KPIs, building data pipelines

Qualifications

• Master's degree in an appropriate field and at least two years in a supervisory, administrative or research capacity for Level II.
• A doctorate plus one year of relevant experience qualifies for higher levels; alternate equivalent combinations may apply.

Responsibilities

• Write, optimize, and maintain complex SQL queries across relational databases and data warehouses.
• Design, build, and maintain automated data pipelines and executive dashboards using Tableau, Dash, or Power BI.
• Establish and monitor automated data validation scripts to identify gaps or discrepancies.
• Translate workflows and policy mandates into KPIs and performance scorecards.
• Conduct exploratory and descriptive data analysis to detect trends and gaps.
• Prepare recurring executive briefings, compliance summaries, and ad-hoc extracts.
• Collaborate with IT to reconcile front-end apps with data warehouses.
• Contribute to standardizing data dictionaries, field mappings, and master data management.
• Document data extraction methodologies and reporting logic for continuity.

Education

Master's degree in a relevant field (physical, biological, environmental science or public health)

Doctorate degree in a relevant field (physical, biological, environmental or social science)

Tools

SQL

Tableau

Power BI

Python (Dash)

Job description

Job Description

The New York City Department of Correction (DOC) is an integral part of the City’s evolving criminal justice system, participating in reform initiatives and strategies aimed to move the City towards a smaller jail system without compromising public safety. The DOC is responsible for maintaining a safe and secure environment for our employees, visitors, volunteers, and people in our custody. Importantly, safe jails enable DOC to provide people in custody with the tools and opportunities they need to successfully re-enter their communities. The DOC operates facilities and court commands across the five boroughs with more than 7,500 diverse professionals and knowledgeable experts.

The Office of Management, Analysis, and Planning (OMAP) is seeking a skilled and proactive Business Intelligence Analyst to transform complex operational data into actionable dashboards, automated reporting pipelines, and strategic insights. Working at the intersection of data engineering and visual analytics, this role supports executive leadership and operational divisions by ensuring high-integrity, real-time visibility into agency performance, compliance metrics, and strategic initiatives.

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 like Tableau, Python (Dash), or Power BI.
• Establish and monitor automated data validation scripts to proactively identify system entry gaps, data discrepancies, or pipeline failures.
• Collaborate with operational stakeholders to translate operational workflows and policy mandates into structured KPIs and performance scorecards.
• Conduct exploratory and descriptive data analysis to detect 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 diverse operational units.
• Document data extraction methodologies, reporting logic, and pipeline workflows to ensure institutional continuity.

City Research Scientist - 21744

Qualifications

• For Assignment Level I (only physical, biological and environmental sciences and public health) A master's degree from an accredited college or university with a specialization in an appropriate field of physical, biological or environmental science or in public health.
• To be appointed to Assignment Level II and above, candidates must have: 1. A doctorate degree from an accredited college or university with specialization in an appropriate field of physical, biological, environmental or social science and one year of full-time experience in a responsible supervisory, administrative or research capacity in the appropriate field of specialization; or 2. A master's degree from an accredited college or university with specialization in an appropriate field of physical, biological, environmental or social science and three years of responsible full-time research experience in the appropriate field of specialization; or 3. Education and/or experience which is equivalent to "1" or "2" above. However, all candidates must have at least a master's degree in an appropriate field of specialization and at least two years of experience described in "2" above. Two years as a City Research Scientist Level I can be substituted for the experience required in "1" and "2" above.

NOTE: Probationary Period

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

Additional Information

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.