Public Sector Budget & 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 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.