Data Analyst/Data Visualization Specialist – Grants Management – ACF/OGM/OHS West Region

Guardians of Honor Future Work; Denver (CO); On-site; USD 75,000 - 110,000; Full time

Job summary

GOH, a small management consulting firm, is seeking an energetic professional with grants management data analysis experience to support the Office of Head Start client in the Denver area. The successful candidate will develop databases, dashboards, and automated reports, acting as the primary data contact between functional and technical teams.

Responsibilities include data collection, visualization, and reporting, plus maintaining databases and IT infrastructure to enable reliable access to

Qualifications

• Bachelor's degree required; master's degree or certifications preferred.
• 3+ years of related professional experience.
• Proficiency in web-based and off-the-shelf data tools (Excel, PowerPoint, Smartsheet, Tableau, Python, R, SQL, Power BI, ArcGIS, Figma, Canva).
• Ability to work onsite at the OHS West Regional Office.
• Knowledge of Head Start program and grant systems is a plus.
• Ability to pass background investigations for Public Trust clearance.

Responsibilities

• Develop databases, reports, and tools to support efficiency and process improvement; maintain grants management databases.
• Support database administration and oversee data, databases, and systems maintenance.
• Design and maintain databases using Excel, Smartsheet, Python, R, SQL, GIS, Power BI, Tableau, Qualtrics.
• Prepare and maintain project folders with all artifacts and deliverables.
• Develop reports and presentations on analytical findings for varied audiences.
• Translate complex data into visual stories and engaging visualizations (Tableau, Power BI, ArcGIS, Canva, Google Data Studio).
• Create trainings on database functionality for colleagues and grant recipients.
• Stay current with technology and document best practices for quality and efficiency.
• Lead data storage, validation, and analysis to support project goals; coordinate cross-team efforts.
• Test systems, run test scenarios, and document/remediate issues.
• Support pre- and post-award grants management activities and related tasks as assigned.

Skills

Data analysis

Tableau

Power BI

Python

R

SQL

Excel

Education

Bachelor's degree

Master's degree or certifications

Tools

Smartsheet

ArcGIS

Power BI

Tableau

Python

R

SQL

Job description

OHS West Region

GOH is a small management consulting firm supporting the federal government since 1997 (www.gohnow.com). We are seeking an energetic new team member experienced in Federal grants management to support our Office of Head Start client.

GOH is recruiting in anticipation of potential future openings that are subject to final approval and funding. No guarantee of position availability can be made at this time; however, candidate identification and preliminary interviews are being conducted to support timely hiring should authorization be granted.

The successful candidate will have a proven track record of leading grants management data analysis and reporting tasks, as well as serving as the primary data / system point of contact between the functional and technical teams. The successful candidate will be able to conduct complex data collection and analysis while integrating data from multiple sources into a streamlined workflow. You must prepare reports, presentations, trend identification, develop dashboards, and provide high-quality data analyses to support decision-making and process improvements. You must assist with building, maintaining, and testing databases and IT infrastructure and consolidating data from multiple sources so analysts and team members may easily access and interpret data reliably. Additional consideration for the candidate with analytical visualization, interactive designs, and data story telling experience.

Duties and Responsibilities:

• Develop databases, reports, and other tools as needed to support efficiencies and process improvement; Maintain and update grants management databases
• Support database administration and oversee maintenance of data, databases, and systems
• Develop, design, and maintain databases utilizing variety of platforms (e.g., Excel, Smartsheet, Python, R, SQL, GIS, Power BI, Tableau, Qualtrics)
• Prepare and maintain project file folders with all completed work products, artifacts, and deliverables
• Develop reports and presentations on analytical findings customized to various audiences
• Translate complex data into visual stories
• Develop engaging data visualizations using Tableau, Power BI, ArcGIS, Figma, Canva, Google Data Studio
• Create and support trainings on database functionality for colleagues and grant recipients
• Stay up to date on necessary technology and processes and show initiative in capturing, documenting, and implementing best practices and lessons learned to improve quality and efficiency of services and solutions
• Lead coordination and develop methodologies to support functional team in execution of daily activities to include data storage, data validation, data analysis, etc. to support project goals
• Test systems, lead test scenarios, and identify/document/remediate all issues
• Support key pre- and post-award grants management activities, such as, but not limited to: annual report tracking, data management and analysis, data entry and QC for routine grantee metrics, correspondence, web content, surveys / forms and information collection tasks, SharePoint sites, preparing analysis and reports, help desk inquiry log, application screening, funding slates, decision letters, project abstracts, G5/GrantSolutions/HSES/etc. administration, closeout functions, and other activities as assigned

Requirements

Minimum Qualifications:

• Bachelor's degree required, master's degree and/or relevant certifications preferred
• At least 3 years of related professional experience
• High level of demonstrated proficiency in utilizing a variety of web-based and commercial off-the-shelf data management software packages such as Microsoft Excel, PowerPoint, Smartsheet, Tableau, Python, R, SQL, Power BI as well as ArcGIS, Figma, Canva, etc.
• High level of demonstrated proficiency in aggregating, analyzing, and presenting data gathered from multiple sources
• Ability to work onsite at the OHS West Regional Office
• Experience and education in education, early childhood education, child development, public administration, family and consumer science or related fields preferred
• Knowledge of Head Start Program and applicable grant systems a major distinguishing feature
• Ability to pass background investigations as required for access to federal facilities and systems; position requires Public Trust clearance