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

Guardians of Honor LLC; Dallas (TX); On-site; USD 75,000 - 115,000; Full time

Job summary

Guardians of Honor LLC in Dallas, TX seeks an energetic data-driven professional to lead grants management analysis for the Office of Head Start client. The role involves developing databases, reports, and dashboards; integrating data from multiple sources; and providing high-quality analyses to improve decisions and processes.

The candidate will build visualizations using Tableau, Power BI, ArcGIS, and other tools, prepare presentations, and support pre/post-award activities while ensuring data

Qualifications

• Bachelor’s degree required; master’s preferred.
• 3+ years of related professional grants/data analytics experience.
• Proficient in Excel, Power BI, Tableau, SQL, Python or R.
• Ability to work onsite at the OHS Southwest Regional Office.
• Knowledge of Head Start grants systems and federal grant processes is a plus.
• Ability to pass background investigations for access to federal facilities.

Responsibilities

• Develop databases, reports, and tools to support efficiencies and process improvements.
• Support database administration and oversee maintenance of data, databases, and systems.
• Develop, design, and maintain databases using Excel, Smartsheet, Python, SQL, GIS, Power BI, Tableau, Qualtrics.
• Prepare and maintain project files with all artifacts and deliverables.
• Develop reports and presentations on analytical findings for diverse audiences.
• Translate complex data into visual stories and engaging data visualizations.
• Lead data storage, validation, and analysis to support project goals.
• Test systems, run scenarios, and remediate issues; assist with grant management activities.

Skills

Tableau

Power BI

Python

R

SQL

Excel

Smartsheet

GIS

Data visualization

Education

Bachelor’s degree

Master’s degree

Grant management certification

Tools

ArcGIS

Tableau

Power BI

Python

R

SQL

Smartsheet

Excel

Canva

Figma

Job description

Description

OHS Southwest 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.

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 Southwest 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

Work Environment

The work environment is a typical office setting.

Physical demands

The physical demands of the job include sitting for extended periods, and occasional walking and standing.

Position type and expected hours of work

This is a full-time exempt position. Typical work hours are Monday-Friday, 40-60 hours per week. Some job activities may be required outside of typical workdays/hours. Overtime may be expected during peak periods.

Travel

10% local and regional travel, with overnight stays necessary

Required education and experience

Bachelor’s degree required

Equal employment opportunity statement

Guardians of Honor is an Equal Opportunity Employer. We make employment decisions based on merit, qualifications, and business needs. We prohibit discrimination and harassment and provide equal employment opportunities to all employees and applicants without regard to any characteristic protected by applicable federal, state, or local law.