Loading...
Entry LevelFull-time
Salary Range
$25,500 - $34,500 /year
This salary is estimated based on similar roles. The actual salary may vary.
About the Role
The New York City Department of Correction (DOC) is seeking a Fiscal Operations Analyst to support the Finance and Budget Division. This role involves developing and maintaining data systems that support financial operations, workforce tracking, and management reporting.
Key Responsibilities
- →Design, develop, and maintain relational databases that consolidate financial and operational data from multiple Finance and Budget units.
- →Write and optimize SQL queries to extract, validate, and analyze data from various source systems.
- →Develop and maintain applications using Microsoft PowerApps and related Microsoft tools to automate financial and operational processes.
- →Analyze agency financial data, including OTPS budgets, PS budgets, banking operations, and payment activity, to support reporting and oversight.
- →Maintain and analyze workforce and headcount data, including employee names, titles, ranks, assignments, and movement history.
- →Create, publish, and maintain dashboards and reports using Tableau and/or Power BI to provide at-a-glance views of agency performance.
- →Produce recurring and ad hoc reports for executive leadership, management, and operational units.
- →Ensure data accuracy, consistency, and compliance with agency and City data standards.
- →Document system requirements, data definitions, processes, and reporting methodologies.
- →Collaborate with IT staff and business users to troubleshoot issues and improve system functionality.
Requirements
- ✓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.
- ✓Experience working with relational databases and data modeling.
- ✓Strong proficiency in SQL.
- ✓Experience developing dashboards and reports using Tableau and/or Power BI.
- ✓Experience developing applications using Microsoft PowerApps.
- ✓Experience working with financial, budget, payroll, or banking data.
- ✓Knowledge of FMS/2 & FMS/3, PassPort a plus.
- ✓Strong analytical, organizational, and communication skills.
- ✓Ability to work independently and manage multiple priorities.
Free to sign up. Takes 30 seconds.
