Business Intelligence Analyst

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:

Business Intelligence & Automated Reporting:

• 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.

Performance Metrics & Analytics:

• 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.

Data Governance & System Integration:

• 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, New York City residency is generally required within 90 days of appointment. However, City Employees in certain titles who have worked for the City for 2 continuous years may also be eligible to reside in Nassau, Suffolk, Putnam, Westchester, Rockland, or Orange County. To determine if the residency requirement applies to you, please discuss with the agency representative at the time of interview.

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. To be appointed to Assignment Level II and above, candidates must have:

2. 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
3. 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
4. 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., Programming & Data Manipulation: Advanced proficiency in Python for robust data manipulation, exploratory analysis, and visualization. - Database & SQL Expertise: Deep expertise in SQL, with a strong ability to write optimized queries, navigate complex relational databases, and extract data from enterprise data warehouses. - Data Visualization & BI: Extensive experience designing, building, and maintaining interactive, executive-ready dashboards using tools like Tableau, Dash, or Power BI. - Automation & Deployment: Demonstrated experience developing, deploying, and automating server- based analytical resources, including scheduling recurring reports and maintaining automated data pipelines. - Applied Analytical Skills: Solid foundation in applied statistical modeling, performance tracking, and identifying actionable trends within large, complex datasets. - Domain Experience: Prior experience working with public sector, criminal justice, operational, or highly regulated administrative data is desirable. - Project Management & Communication: 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.

Public Service Loan Forgiveness

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.