Grant Data Engineer: Pipelines, Analytics & Systems

City of New York

New York (NY)

On-site

USD 90,000 - 100,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

SmartRecruiters, Inc. in New York City is hiring an Analyst to support FEMA disaster recovery and homeland security grants. You will build and govern data pipelines, document data models, and automate cross-platform integrations within OMG's Task Force.

The role emphasizes Python, SQL, Spark, ETL, and data modeling skills, with cloud tools like Quickbase, Azure Synapse, AWS, and Salesforce. You’ll collaborate with multiple city teams and external partners under grant funding.

Qualifications

  • Background in Data Analysis, Data Engineering, Information Systems, or related fields.
  • Must possess a strong expertise in data engineering, building, automating, and optimizing ETL processes.
  • Proficiency in Python, SQL, and Apache Spark to process large-scale datasets and build data pipelines.
  • Strong experiences with integrating data systems and automating workflows using APIs and webhooks.
  • Experience in designing and implementing data models and table relationships.
  • Familiarity with cloud-based platforms like Quickbase, Azure Synapse, AWS, Salesforce is preferred.
  • Strong analytical, organizational, and problem-solving skills with attention to detail.

Responsibilities

  • Develop, maintain and improve the division’s data pipelines and workflows for OMG’s Task Force’s Systems.
  • Establish rigorous documentation standards for all data models, infrastructure, and workflows.
  • Serve as a Quickbase subject matter expert to drive system administration, governance, and cross-platform integrations.
  • Build & maintain tools to make data and information readily accessible to stakeholders.
  • Analyze 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 teams.
  • Design and implement data quality protocols to ensure accuracy and governance.
  • Develop relationships with IT, FISA, other City agencies, and vendors to enhance data-sharing.

Skills

Data analysis
Data engineering
Information systems
ETL processes
Python
SQL
Apache Spark
APIs & webhooks
Data modeling

Education

Bachelor's degree in Business, Finance, Economics, Public Policy Analysis/Administration, or related field

Tools

Quickbase
Azure Synapse
AWS
Salesforce

Job description

  • Job Category: Finance, Accounting, & Procurement
  • Salary Band: $90,000 to $100,000
  • Compensation: USD 77,327 - USD 98,075
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:

The duties of the position include the following:
- 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:

A cover letter is required to be considered for this position. Applications submitted without a cover letter will not be considered.

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.

SUBMISSION OF A RESUME IS NOT A GUARANTEE THAT YOU WILL RECEIVE AN INTERVIEW; ONLY THOSE CANDIDATES UNDER CONSIDERATION WILL BE CONTACTED.

BUDGET ANALYST (OMB) - 06088

Qualifications

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

By clicking the link above or any third-party link within this posting, you are leaving this site and going to a third-party website where the third-party website's terms and privacy policy apply

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Analyst - Data and Systems
Analyst - Data and Systems

City of New York • New York (NY)

On-site
USD 90,000 - 100,000
Deputy Assistant Director - FEMA Sandy Revenue and Financial Planning
Deputy Assistant Director - FEMA Sandy Revenue and Financial Planning

City of New York • New York (NY)

Hybrid
USD 125,000 - 150,000
Hybrid Assistant Director - FEMA Disaster Recovery & Budget
Hybrid Assistant Director - FEMA Disaster Recovery & Budget

City of New York • New York (NY)

Hybrid
USD 150,000 - 184,000
Analyst - FEMA Sandy Revenue and Financial Planning
Analyst - FEMA Sandy Revenue and Financial Planning

City of New York • New York (NY)

Hybrid
USD 61,000 - 87,000
Intergovernmental Budget Director — Hybrid Role
Intergovernmental Budget Director — Hybrid Role

City of New York • New York (NY)

Hybrid
USD 146,000 - 167,000
Assistant Director, City Budget & Operations (Hybrid)
Assistant Director, City Budget & Operations (Hybrid)

City of New York • New York (NY)

Hybrid
USD 150,000 - 167,000
Analyst - Law, Elected Officials, Administration, and Finance (LEAF)
Analyst - Law, Elected Officials, Administration, and Finance (LEAF)

City of New York • New York (NY)

Hybrid
USD 80,000 - 90,000
Analyst - Parks
Analyst - Parks

City of New York • New York (NY)

Hybrid
USD 61,000 - 87,000
Assistant Director - FEMA Disaster Recovery
Assistant Director - FEMA Disaster Recovery

City of New York • New York (NY)

Hybrid
USD 150,000 - 184,000
Budget Analyst — Social Services & DHS (Hybrid)
Budget Analyst — Social Services & DHS (Hybrid)

City of New York • New York (NY)

Hybrid
USD 61,000 - 77,000