Analyst - Data & Systems

NYC Department of Housing Preservation & Development; New York (NY); On-site; USD 74,000 - 96,000; Full time

Job summary

The NYC Department of Housing Preservation & Development is seeking Analysts to support the operation of the OMB Capital Grant Management System. The role involves data analysis, system maintenance, and reporting to enhance grant management processes. Candidates should have a strong background in data analysis, problem-solving skills, and proficiency in SQL and Excel. This position offers a competitive salary based on experience and qualifications.

Qualifications

• Minimum 2 years experience in budgetary planning or financial analysis.
• Experience with the City’s Financial Management System is desirable.

Responsibilities

• Support operation and maintenance of the OMB Capital Grant Management System.
• Extract grant-related data for analyses.
• Develop reports and dashboards highlighting data trends.

Skills

Data Analysis

Problem Solving

Communication

Self-motivation

SQL

Microsoft Excel

Python

R

Power BI

Microsoft Access

Education

Bachelor’s degree in Business

Bachelor’s degree in Finance

Bachelor’s degree in Economics

Bachelor’s degree in Public Policy

Master’s degree in Financial Management

Master’s degree in Business

Job description

1 day ago Be among the first 25 applicants

NYC Department of Housing Preservation & Development provided pay range

This range is provided by NYC Department of Housing Preservation & Development. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

$74,893.00/yr - $95,208.00/yr

TASK FORCE: Citywide Grants

UNIT: Data & Systems

JOB TITLE: Two (2) Analyst / Senior Analyst / Supervising Analyst

CONTROL CODE: CWG-25-02

Summary

The Mayor’s Office of Management and Budget (OMB) is the City government's chief financial agency. OMB's staff of analysts and experts assemble and oversee the Mayor’s operating and capital budgets, which fund the services and activities of approximately 90 City agencies and entities..

Within OMB, the Citywide Grants Task Force is responsible for monitoring the financial reporting and collection of all Federal, State, and non-government funds granted to the City, which totaled over $30 billion in FY24. With a mission of improving the timeliness of recognizing, claiming, and collecting revenue, the Task Force provides in-depth analyses, best practices, training, and support to the 50+ agencies that utilize grant funds, as well as to the OMB Task Forces with oversight of those agencies.

The Data & Systems Unit is responsible for consolidating data from multiple sources to support OMB task forces in their oversight of grant-related spending and revenue. This includes operating and improving systems used to monitor grant-related budgetary requests, identifying variances from forecast reimbursement dollars or timing, and providing reports/dashboards summarizing results.

Job Description

The duties of this position encompass the following activities:

• Support the operation and maintenance of the OMB Capital Grant Management System (CGMS), including defining, developing, and testing upgrades / enhancements to that system.
• Extract grant-related data from the Financial Management System (FMS), consolidating with other data sources, to support analyses by the OMB Grants Monitoring Unit and Task Forces.
• Manage dataset exchanges used to gather updated grant status and other related information from each agency for update of OMB and FMS data repositories.
• Support activities associated with defining and testing grant-related enhancements to FMS.
• Develop reports and dashboards to highlight data trends requiring follow-up with agencies.
• Contribute to data cleansing, reporting and other analytical projects on an ad-hoc basis.
  
  

Qualifications

• Background in data analysis with an understanding of data modeling, data visualization and other best practices.
• Outstanding problem-solving skills, with demonstrated ability to learn, innovate and recommend improvement options.
• Strong written and verbal communication skills, including developing reports and presenting findings to stakeholders.
• Self-motivated to complete assignments and adhere to deadlines with minimal supervision.
• Proficiency/working knowledge in extracting data from relational databases using SQL.
• Proficient in use of Microsoft Excel, preferably with knowledge of VBA.
• Competency with Python, SQL, R, Power BI, and/or Microsoft Access.
• Knowledge / experience with fiscal accounting concepts, particularly for grants, is desirable.
• Prior experience using the City’s Financial Management System for Budgeting (FMS/2) and Accounting (FMS/3), including its SAP Crystal Reports and Business Object tools, is desirable.
  
  

Requirements

Analyst ($74,893+): Bachelor’s degree in Business, Finance, Economics, Public Policy Analysis/Administration, Information Systems, or a subject related to the specific assignment and a minimum of two years of full-time experience in budgetary planning/management, financial analysis, public policy analysis/administration, or a related field; or an awarded Master’s degree in Financial Management, Business, Public Administration or a field related to the specific assignment.

Senior Analyst ($84,257+): Bachelor’s degree in Business, Finance, Economics, Public Policy Analysis/Administration, Information Systems, or a subject related to the specific assignment and a minimum of three years of full-time experience in budgetary planning/management, financial analysis, public policy analysis/administration, or a related field; or an awarded Master’s degree in a relevant field, and one year of relevant experience.

Supervising Analyst ($95,208): Bachelor’s degree in Business, Finance, Economics, Public Policy Analysis/Administration, Information Systems, or a subject related to the specific assignment and a minimum of four years of full-time experience in budgetary planning/management, financial analysis, public policy analysis/administration, or a related field; or an awarded Master’s degree in a relevant field, and two years of relevant experience including supervising others.

BUDGET ANALYST (OMB) - 06088

Minimum Qualifications

• A baccalaureate degree from an accredited college.
  
  

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.

Seniority level

• Seniority level

  Entry level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  Government Administration

Referrals increase your chances of interviewing at NYC Department of Housing Preservation & Development by 2x

Get notified about new Data System Analyst jobs in New York, NY.

New York, NY $105,000.00-$110,000.00 3 months ago

DEPUTY DIRECTOR,RECRUITMENT DATA CONTROL UNIT

Business Analyst( Reference Data) in New York City, NY(Hybrid Local W2 USC or GC Only)

New York City Metropolitan Area $90,000.00-$100,000.00 2 weeks ago

Senior Health Economics Researcher, Bureau of Equitable Health Systems

UKG Pro Workforce Management (No Sponshership or Transfer Preferred)

New York City Metropolitan Area 6 days ago

New York City Metropolitan Area 1 week ago

Senior Health Economics Researcher, Bureau of Equitable Health Systems

Queens, NY $106,117.00-$122,034.00 2 weeks ago

UKG Pro Business Analyst (Workforce Management)

SAP Senior Business Systems Analyst, Publishing Operations (Open to Remote)

Team Lead, Informatics and Evaluation, Bureau of Tuberculosis Control

Coding Auditor-Revenue Management (Hybrid Position, 1-2 days per month)

New York, NY $81,325.15-$82,000.00 5 days ago

Policy and Planning Analyst, Bureau of Community Awareness, Action, Response & Engagement

Senior Health Economics Researcher, Bureau of Equitable Health Systems

Senior Health Economics Researcher, Bureau of Equitable Health Systems

Senior Health Economics Researcher, Bureau of Equitable Health Systems

New York, NY $106,117.00-$122,034.00 1 day ago

New York, NY $110,000.00-$120,000.00 1 month ago

Manager, Global Product Safety and Quality Assurance - Corporate Headquarters, NJ

Agile Product Owner II - Individual Markets

New York, NY $100,000.00-$120,000.00 1 week ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.