Grants Program Data Analyst

Position Description
ERT is seeking a Grants Program Data Analyst to provide analytical and technical support for the National Oceanic and Atmospheric Administration (NOAA) Office of Education (OEd). OEd manages a $3M/year Environmental Literacy Program (ELP) that supports projects in informal and formal K-12 education that build community resilience to climate change impacts.

The successful candidate will provide the ELP staff with analytical support and end-to-end data management (i.e., developing processes of collection, storage, management and data harvesting) for all grant-related investments and partnerships as well as support for grant competitions. These data include project characteristics such as grantee organizations, personnel, geographic data, participants, partners, climate hazards, and education impacts. The successful candidate will be the sole data analyst for the ELP team. The Grants Program Analyst will play an essential role in identifying major impacts of the program’s investments and helping determine appropriate future directions for the program. The tasks of this position include but are not limited to: 

• Maintaining and/or augmenting existing grants portfolio database structure as needed;
• Supporting grantees in submitting required information on project progress, i.e., development of data collection templates, interacting with grantees to ensure they understand data collection needs;  
• Reviewing and analyzing grantee-submitted progress reports, including the data entry into the grants portfolio database, to identify common challenges and successful practices;
• Analyzing grantee outputs and outcomes and aggregating outputs and outcomes across multiple projects to reveal trends and impacts of funded projects; 
• Creating responses for agency performance measures and other requests for program impacts;
• Identifying and incorporating publicly available data into the analyses of impacts of ELP-funded projects; 
• Providing technical and data-management support for the application review process;
• Advising on opportunities to appropriately employ generative AI to aid in the efforts described above;  
• Protecting applicant and grantee data from improper access/use by generative AI applications, and;
• Generating data products to support the communication and evaluation needs of the program, including maintaining the ELP’s Impacts web page (see https://www.noaa.gov/office-education/elp/impacts).

Required Skills
2 + years of experience with:

• Harvesting data and conducting data analyses on program impact;
• Managing relational databases, including Microsoft Access;
• Managing data through shared and interconnected spreadsheets;
• Working with geospatial information and tools, including shape files; 
• Identifying and incorporating data from publicly available datasets (e.g., US Census, National Center for Education Statistics); and,
• Working knowledge of generative AI applications.

Must be able to pass a background investigation to obtain a security badge to access government systems.

Desired

• Data analysis of education projects/programs; 
• Excellent written communication skills;
• Exceptional organizational skills and attention to detail;
• Background in the field of formal and/or informal education; 
• Background in supporting grant competitions or other review processes; 
• Familiarity with the Google Workspace.  

Education
BA/BS in scientific, engineering, environmental, education, related field, or equivalent.

ERT is a VEVRAA Federal Contractor and Equal Opportunity/Affirmative Action employer - All qualified applicants will be considered for employment without regard to race, color, religion, sex, national origin, disability, or protected Veteran status.