Analyst - Data and Systems

City of New York • New York, NY

1d • $77,327 - $98,075

About The Position

The Mayor's Office of Management and Budget (OMB) is the City government's chief financial agency, responsible for assembling and overseeing the Mayor's expense and capital budgets. Within OMB, the OMB Managed Grants (OMG) Task Force collaborates with City, State, and Federal agencies to secure and manage federal funding. The Data & Systems Unit within OMG governs the City’s grants Management System (GMS) and related systems. The Analyst will support the Unit Head in establishing new policies and procedures for the Task Force’s data infrastructure, recommending system improvements, and building additional functionality for system operation, reporting, and revenue collection. This role also involves carrying out ad hoc systems and data pipelines to enhance task force system efficiency. This is a grant-funded position with an expected term of at least three years, dependent on funding availability.

Requirements

• A cover letter is required to be considered for this position. Applications submitted without a cover letter will not be considered.
• 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.
• 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.

Nice To Haves

• 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.
• A baccalaureate degree from an accredited college.

Responsibilities

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

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level