Business Intelligence Analyst

The New York City Department of Correction is hiring a Business Intelligence Analyst to turn operational data into actionable dashboards, automated reporting pipelines, and strategic insights. The role supports agency leadership and operational divisions with reliable visibility into performance, compliance, 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

Company

• Municipal government providing public services
• New York, New York, USA
• http://www1.nyc.gov/
• Founded in 1898
• 10001+ employees

Qualifications

• 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
• 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
• 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
• 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
• Glassdoor
• 3.7
• Municipal government providing public services.
• New York, New York, USA
• http://www1.nyc.gov
• Late Stage
• Leadership Team
• Carl G Esposito
• Chief Information Security Officer
• Denise Clay
• NYC Chief Efficiency Officer
• Recent News
• IndiaTimes
• As US marks 25 years since September 11, Zohran Mamdani launches free online portal for documents, releasing the first 170,000 pages that prove ...
• 2026-09-12
• New York Mayor Zohran Mamdani is hiring software engineers, designers, researchers for his 'tech crew': Here's what the job actually is
• 2026-07-22
• PR Newswire
• Legionnaires' Disease Lawsuit Filed Against the City of New York in Harlem Legionnaires' Disease Outbreak
• 2026-07-16
• Company data provided by
• AI Tools
• Customize Your Resume
• Maximize your interview chances
• Build Cover Letter
• Make your application stand out
• Analyze How Well You Fit
• Understand your strength & weakness

Required skills

• Administrative experience, Biological sciences, City Research Scientist Level I experience, Doctoral degree, Environmental sciences, Master's degree, Physical sciences, Public health, Research experience, Social sciences, Supervisory experience

Experience

• 2+ years