Analyst – Data and Systems

UNIT: Data and Systems

JOB TITLE: One (1) Analyst / Senior Analyst

CONTROL CODE: BAW-25-10

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 FEMA Disaster Recovery Task Force works with City, State, and Federal agencies to help New York City recover from the devastation of Superstorm Sandy and respond to the Coronavirus pandemic. The Data & Systems Unit within the FEMA Disaster Recovery Task Force 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 play a critical role, in support of the Unit Head, to stand up new policies and procedures for managing the Task Force’s vast data infrastructure, solicit recommendations for improvements to existing systems, and build out additional functionality to enhance reporting and revenue collection. Additionally, carrying out ad hoc systems and data analyses.

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 four years.

Job Description

The duties of the position include the following:

• Maintain and improve the division’s data pipelines and workflows between FMS and Quickbase.
• Develop a comprehensive understanding of the City’s financial data and database architecture.
• Become a Quickbase subject matter expert to provide administrative supports and resolve any data requests.
• Maintain our system and provide technical and data consulting services to internal teams.
• Conduct analysis of data related to the City’s budget, spending, revenue, and grant processes.
• Build & maintain tools to make data & information readily accessible to technical and non-technical stakeholders.
• Develop and maintain rigorous documentation of data, infrastructure, and tools.
• Assists in identifying needs, developing solutions, and implementing them.
• Support in developing techniques and protocols for quality data collection to ensure the adequacy and accuracy of data.
• Develop relationships with FISA, other City agencies, federal partners, and vendors to enhance data-sharing.

Qualifications

• Background in Data Analysis, Data Engineering, Applied Analytics, Database Management, or related fields.
• Must possess a strong expertise in data engineering, with building, automating, and optimizing ETL processes.
• Proficiency in Python, SQL, and R, with a strong ability to integrate and automate data workflows using APIs.
• 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.
• 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 ($74,893+): 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.

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

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.