Financial Reporting Analyst

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

Job summary

The City of New York invites applications for a City Research Scientist in the Budget and Finance division. The role focuses on consolidating financial and workforce data, producing accurate reports, and developing dashboards for executive leadership. Strong Excel skills and experience with budget management are essential.

Applicants should have advanced analytics capabilities and a background in public sector finance. Residency is typically required within 90 days of appointment.

Qualifications

• Master’s degree in an appropriate field of physical, biological, environmental science or public health.
• Doctorate degree in an appropriate field of physical, biological, environmental or social science with significant supervisory/research experience.
• Equivalent combination of education/experience acceptable with master’s degree and two+ years of relevant work (if applicable).

Responsibilities

• Serve as the primary reporting liaison for Finance and Budget units.
• Develop and maintain executive oversight reports.
• Analyze Expense Budget and Capital Budget for trends, variances and risks.
• Track facility cash operations, banking activity, payments processing, and reconciliations.
• Prepare recurring and ad hoc reports for senior leadership and managers.
• Develop dashboards and reporting templates using Excel for at-a-glance insights.

Skills

Advanced Excel proficiency

Analytical and quantitative skills

Public budgeting experience

Data visualization familiarity

Excellent written and verbal skills

Education

Master’s degree in physical/biological/environmental science or public health

Doctorate degree in physical/biological/environmental or social science

Tools

Microsoft Excel

Power BI

Tableau

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 DOC’s Budget and Finance division is looking for a detailed oriented and experienced candidate to serve as the central reporting point for the Division, working closely with the Director of Financial Operations Analysis to consolidate, analyze, and report on financial and operational data across all units.

Responsibilities

The selected candidate will support executive oversight of the agency’s Expense Budget, Capital Budget, facility cash operations, payments analysis, and bank reconciliations. This position is responsible for integrating financial and workforce data from multiple sources and producing accurate reports that inform leadership decision-making. This role emphasizes strong analytical capabilities and attention to detail, with a sub and advanced proficiency in Microsoft Excel. Limited technical experience with reporting or visualization tools is desirable but not required. The duties and responsibilities of this position include, but are not limited to, the following:

• Serve as the primary reporting liaison for all Finance and Budget units, centralizing financial data and ensuring consistency in reporting.
• Work closely with the Director of Financial Operations Analysis to develop and maintain comprehensive financial oversight reports for executive leadership.
• Analyze and monitor the agency’s Expense Budget (OTPS and PS) and Capital Budget, identifying trends, variances, and risks.
• Track and report on facility cash operations, banking activity, payments processing, and bank reconciliations.
• Maintain and reconcile financial tracking spreadsheets and internal reporting tools.
• Track and report on workforce and headcount data, including employee names, titles, ranks, assignments, and personnel movements.
• Prepare recurring and ad hoc reports for senior leadership and operational managers.
• Develop summary dashboards and structured reporting templates using Microsoft Excel to provide at-a-glance insights.
• Assist in preparing financial projections, forecasts, and internal budget analyses.
• Support process improvement initiatives to enhance reporting accuracy, efficiency, and internal controls.
• Perform related duties as assigned.

CITY RESEARCH SCIENTIST - 21744

Minimum 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:

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

Note

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

Preferred Skills

• Advanced proficiency in Microsoft Excel, including pivot tables, lookup functions, formulas, and data analysis tools. - Strong analytical and quantitative skills with the ability to synthesize complex financial data. - Experience working with Expense and Capital Budgets. - Ability to prepare clear, concise reports for executive audiences. - Experience in a public sector or government environment. - Familiarity with data visualization tools (e.g., Power BI or Tableau) is a plus. - Strong written and verbal communication skills.

Public Service Loan Forgiveness

As a prospective employee of the City of New York, you may be eligible for federal loan forgiveness programs and state repayment assistance programs. For more information, please visit the U.S. Department of Education’s website at https://studentaid.gov/pslf/.

Residency Requirement

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.

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.

, $87,743.00 – $110,120.00