Analyst - Data & Systems

Lensa; New York (NY); On-site; USD 74,000 - 96,000; Full time

Job summary

A leading entity within the City of New York, the Mayor’s Office of Management and Budget, is seeking several Analysts, Senior Analysts, and Supervising Analysts. This position involves supporting financial management systems and conducting detailed data analyses related to citywide grants. Ideal candidates will possess strong analytical skills and relevant degrees, with the opportunity to contribute to significant budgetary activities impacting various city agencies.

Qualifications

• Background in data analysis and data modeling.
• Proficient in SQL and Microsoft Excel with VBA knowledge.
• Prior experience with Financial Management Systems.

Responsibilities

• Support the operation of the OMB Capital Grant Management System.
• Extract and consolidate grant-related data for analysis.
• Develop and manage reports and dashboards.

Skills

Data analysis

Problem-solving

Communication

Data visualization

SQL

Microsoft Excel

Python

R

Power BI

Education

Bachelor’s degree in Business

Master’s degree in Financial Management

Job description

2 days ago Be among the first 25 applicants

Get AI-powered advice on this job and more exclusive features.

Lensa is the leading career site for job seekers at every stage of their career. Our client, City of New York, is seeking professionals in New York, NY. Apply via Lensa today!

Job Description

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

Qualifications

• A baccalaureate degree from an accredited college.
  
  

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.

Salary Min: $ 74,893.00

Salary Max: $ 95,208.00

Seniority level

• Seniority level

  Entry level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  IT Services and IT Consulting

Referrals increase your chances of interviewing at Lensa by 2x

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

New York City Metropolitan Area $55.00-$65.00 6 days ago

Parsippany, NJ $65,700.00-$89,672.00 1 week ago

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

Parsippany, NJ $65,700.00-$89,672.00 1 week ago

New York City Metropolitan Area $150,000.00-$155,000.00 2 weeks ago

DEPUTY DIRECTOR,RECRUITMENT DATA CONTROL UNIT

New York City Metropolitan Area 3 weeks ago

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

Team Lead, Informatics and Evaluation, Bureau of Tuberculosis Control

Senior Health Economics Researcher, Bureau of Equitable Health Systems

Senior Health Economics Researcher, Bureau of Equitable Health Systems

Newark, NJ $62,200.00-$159,900.00 4 days ago

New York, NY $95,000.00-$95,000.00 2 months ago

Financial Reference Data Engineer/Analyst

Jersey City, NJ $142,320.00-$213,480.00 6 hours ago

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