Analyst - Data and Systems

OFFICE OF MANAGEMENT & BUDGET; New York (NY); On-site; USD 70,000 - 85,000; Full time

Job summary

The Office of Management & Budget (OMB) Data and Systems Unit seeks an Analyst to stand up new data policies, improve GMS workflows, and implement cross-platform data integration for a grant-funded Task Force. You will develop pipelines, govern data, and enable reporting across city, state, and federal levels.

You’ll collaborate with IT and partner agencies to optimize revenue collection and system operations while maintaining deadlines in a high-pressure environment.

Qualifications

• Background in Data Analysis, Data Engineering, Information Systems, or related fields.
• Must possess strong expertise in data engineering, particularly ETL optimization.
• Proficiency in Python, SQL, and Apache Spark for large-scale data processing.
• Experience integrating data systems and automating workflows with APIs.

Responsibilities

• Develop and improve data pipelines and workflows for OMG Task Force Systems.
• Document data models, infrastructure, and workflows with standards.
• Serve as Quickbase SME for system administration and data governance.
• Build tools to make data accessible to technical and non-technical stakeholders.
• Analyze data related to city budget, spending, revenue, and grant processes.
• Collaborate with internal teams to identify needs and implement solutions.
• Provide technical consulting and strategic data solutions across teams.
• Design data quality protocols to ensure accuracy and governance.
• Develop relationships with IT, federal partners, and vendors to enhance data sharing.

Skills

Data engineering

Python

SQL

ETL

APIs & webhooks

Data governance

Analytical thinking

Detail-oriented

Education

Bachelor's degree in Business/Finance/Economics/Public Policy

Master's degree in Financial Management/Business/Public Administration

Tools

Quickbase

Azure Synapse

AWS

Salesforce

Job description

TASK FORCE: FEMA Disaster Recovery and Homeland Security Grants

UNIT: Data and Systems

JOB TITLE: One (1) Analyst

CONTROL CODE: BAW-27-07

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 assembles and oversees the Mayor's expense and capital budgets, which fund the services and activities of approximately 90 City agencies and entities.

Within OMB, the OMB Managed Grants (OMG) Task Force works with City, State, and Federal agencies to pursue and manage critical federal funding for City agencies. The Data & Systems Unit within OMG is responsible for governing the City’s grants Management System (GMS), as well as several ancillary City, State, and Federal systems that contribute data as part of the larger recovery effort.

The Analyst will critically support the Unit Head to stand up new policies and procedures for managing the Task Force’s vast data infrastructure, to solicit recommendations for improvements to existing systems, and to build out additional functionality to enhance system operation, reporting, and revenue collection. Additionally, this new team member will be responsible for carrying out ad hoc systems and data pipelines to improve the overall efficiency of the task force’s systems.

Please note that this is a grant-funded position. Your term of employment is dependent upon the availability of grant funding, but it is expected to be at least three years.

JOB DESCRIPTION

• Develop, maintain and improve the division’s data pipelines and workflows for OMG’s Task Force’s Systems.
• Develop a comprehensive understanding of the City’s financial data and database architecture, establish rigorous documentation standards for all data models, infrastructure, and workflows.
• Serve as a Quickbase subject matter expert to drive system administration, implement data governance protocols, and automate cross-platform integrations.
• Build & maintain tools to make data & information readily accessible to technical and non-technical stakeholders.
• Conduct analysis of data related to the City’s budget, spending, revenue, and grant processes.
• Collaborate with internal teams to identify needs, develop solutions, and implement them.
• Provide technical consulting and strategic data solutions to cross-functional internal teams.
• Design and implement rigorous data quality protocols to ensure accuracy, governance, and system adequacy.
• Develop relationships with IT, FISA, other City agencies, federal partners, and vendors to enhance data-sharing.

QUALIFICATIONS

• Background in Data Analysis, Data Engineering, Information Systems, or related fields.
• Must possess a strong expertise in data engineering, in particular building, automating, and optimizing ETL processes.
• Proficiency in Python, SQL, and Apache Spark to process large-scale datasets (i.e., CSV, Parquet, Delta Lake formats) and build data pipelines.
• Strong experiences with integrating data systems and automating workflows using APIs and webhooks.
• Experience in designing and implementing data models, particularly in establishing table-to-table relationships.
• Familiarity with cloud-based platforms like Quickbase, Azure Synapse, AWS, Salesforce is preferred.
• Strong analytical, organizational, and problem-solving skills with an emphasis on attention to detail.
• Strong interpersonal skills, and the ability to maintain working relationships with other teams.
• Ability to work independently as a self-motivator and to motivate others.
• Ability to work calmly and proficiently under pressure and to adhere to deadlines.

REQUIREMENTS

Analyst ($77,327): Bachelor's degree in Business, Finance, Economics, Public Policy Analysis/Administration, or a subject related to the specific assignment and a minimum of two years of budgetary planning/management, financial analysis, audit, compliance, accounting, 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.

THE OFFICE OF MANAGEMENT AND BUDGET AND THE CITY OF NEW YORK ARE INCLUSIVE EQUAL OPPORTUNITY EMPLOYERS 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.

You must be a City resident within 90 days of the date of appointment and you must be legally eligible to work in the United States.

BUDGET ANALYST (OMB) - 06088

MINIMUM QUALIFICATIONS

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