Business Intelligence Analyst

The New York City Department of Correction (DOC) is hiring a Business Intelligence Analyst in the Office of Management, Analysis, and Planning. The role turns operational data into dashboards, automated reporting pipelines, and strategic insights, supporting leadership and operational divisions with performance, compliance, and initiative metrics.

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

Preferred

• Advanced proficiency in Python for robust data manipulation, exploratory analysis, and visualization
• Deep expertise in SQL, with a strong ability to write optimized queries, navigate complex relational databases, and extract data from enterprise data warehouses
• Extensive experience designing, building, and maintaining interactive, executive-ready dashboards using tools like Tableau, Dash, or Power BI
• Demonstrated experience developing, deploying, and automating server- based analytical resources, including scheduling recurring reports and maintaining automated data pipelines
• Solid foundation in applied statistical modeling, performance tracking, and identifying actionable trends within large, complex datasets
• Prior experience working with public sector, criminal justice, operational, or highly regulated administrative data is desirable
• Highly organized and detail-oriented, with a proven ability to manage multiple deliverables, track cross-functional dependencies, and clearly communicate complex data findings to non-technical stakeholders and agency leadership
• Python
• Data Manipulation
• Exploratory Data Analysis
• Data Visualization
• SQL
• Query Optimization
• Relational Databases
• Enterprise Data Warehousing
• Tableau
• Dash
• Power BI
• Dashboard Development
• Analytical Resource Deployment
• Process Automation
• Report Scheduling
• Automated Data Pipelines
• Statistical Modeling
• Performance Tracking
• Trend Analysis
• Large-Scale Data Analysis
• Public Sector Data
• Criminal Justice Data
• Operational Data
• Regulated Administrative Data
• Stakeholder Reporting
• Executive Reporting
• Organization
• Attention to Detail
• Multitasking
• Cross-Functional Coordination
• Communication

Benefits

• You may be eligible for federal loan forgiveness programs and state repayment assistance programs.

Company

• New York City public health agency
• Queens, New York, USA
• https://www.nyc.gov/site/doh/index.page
• Founded in 1866
• 5001-10000 employees

Qualifications

• 1. 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
• 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
• Advanced proficiency in Python for robust data manipulation, exploratory analysis, and visualization
• Deep expertise in SQL, with a strong ability to write optimized queries, navigate complex relational databases, and extract data from enterprise data warehouses
• Extensive experience designing, building, and maintaining interactive, executive-ready dashboards using tools like Tableau, Dash, or Power BI
• Demonstrated experience developing, deploying, and automating server- based analytical resources, including scheduling recurring reports and maintaining automated data pipelines
• Solid foundation in applied statistical modeling, performance tracking, and identifying actionable trends within large, complex datasets
• Prior experience working with public sector, criminal justice, operational, or highly regulated administrative data is desirable
• Highly organized and detail-oriented, with a proven ability to manage multiple deliverables, track cross-functional dependencies, and clearly communicate complex data findings to non-technical stakeholders and agency leadership

Required skills

• Criminal Justice Data, Dash, Data Pipelines, Data Warehousing, Performance Tracking, Power BI, Public Sector Data, Python, Relational Databases, SQL, Statistical Modeling, Tableau

Experience

• 2+ years