Data & Performance Measurement Analyst

Dave Thomas Foundation for Adoption; Columbus (OH); On-site; USD 75,000 - 105,000; Full time

Job summary

Dave Thomas Foundation for Adoption in Columbus, OH is seeking a full-time Data Analyst to identify and deploy advanced analytics using the Wendy’s Wonderful Kids database. You will measure program impact and tell data-driven stories to internal teams, partners, and stakeholders.

The role requires 4+ years of data analysis experience, strong SQL/statistical programming skills (R/SAS/Python), and a passion for child welfare.

Qualifications

• Undergraduate degree required; statistics, data analytics or related degree preferred.
• 4+ years of professional experience in data analysis, statistical reporting or program evaluation.
• Experience extracting, cleaning, transforming and analyzing data from multiple sources using SQL or comparable tools.
• Experience using statistical programming software such as R, SAS or Python; R preferred.
• Experience in child welfare or programs using evidence-based, data-driven practices is a plus.

Responsibilities

• Prepare, maintain and deliver routine reporting on reach, impact and program progress.
• Maintain and update dashboards and data visualizations for monthly, quarterly and annual reports.
• Analyze program demographics, census, utilization and outcomes; ensure data hygiene and de-identified handling.
• Apply statistical tools to conduct analyses and translate findings into insights and visualizations.
• Collaborate with teams to understand reporting needs and generate routine KPI reports.
• Develop understanding of programs to support data preparation, analysis and automation.
• Support production of publications, presentations and research resources.
• Stay current on industry trends and best practices in data analytics and management.

Skills

Analytical mindset

Data storytelling

Stakeholder communication

Education

Bachelor's degree in statistics, data analytics or related field

Tools

SQL

R

Python

SAS

Job description

Description

The Dave Thomas Foundation for Adoption (DTFA) is a national nonprofit public charity dedicated exclusively to finding permanent homes for the more than 130,000 children waiting in North America’s foster care systems. Created by Wendy’s® founder Dave Thomas who was adopted, the Foundation implements evidence-based, results-driven national service programs, foster care adoption awareness campaigns and innovative grantmaking. The Foundation has an opening for a full-time data analyst.

STATEMENT OF PURPOSE

The data analyst is responsible for identifying and deploying advanced analytics utilizing the Wendy’s Wonderful Kids Child Trends database to measure and document the work of the Foundation. This position supports the Foundation’s mission by leveraging both quantitative and qualitative data to demonstrate the impact of the Wendy’s Wonderful Kids program to internal and external stakeholders, including state and local partners engaged in child welfare initiatives. Through thoughtful analysis and reporting, the data analyst helps inform strategic decision making and supports the Foundation’s efforts to strengthen positive outcomes for the children we serve.

ACCOUNTABILITIES

1. Prepare, maintain and deliver routine and recurring reporting responsibilities that communicate the Foundation’s reach, impact and program progress to internal teams, state and public agencies, ensuring accuracy, consistency and timely completion
2. Maintain and update performance dashboards and data visualizations for the Foundation, including supporting the preparation of recurring monthly, quarterly and annual Wendy’s Wonderful Kids reports
3. Analyze program demographics, census, utilization, outcomes and other key data; extract, clean, transform and validate data from multiple sources to support routine reporting and ensure strong data hygiene, integrity and appropriate handling of de-identified data
4. Apply established statistical tools and reporting methods, using R or SAS, to conduct quantitative analyses, identify trends in program outcomes and fidelity metrics and translate complex findings into meaningful insights through data storytelling, visualizations and presentations tailored to diverse audiences
5. Collaborate with Foundation teams to understand reporting needs, data structures and program processes; extract data from multiple systems to generate routine reports measuring a range of key performance indicators; maintain progress updates through the project management system (Asana)
6. Develop and maintain a thorough understanding of the Foundation’s programs, data structures and unique reporting requirements to support the adoption of R to improve data preparation, analysis and reporting processes, identifying opportunities for greater efficiency and automation
7. Assist in the preparation, production and dissemination of publications, presentations and research resources ensuring completion within established timelines
8. Assume responsibility for professional growth, stay current on industry trends, best practices and emerging technologies in data analytics and data management, as well as developments and research within the child welfare community
9. Perform other duties as assigned

Requirements

EDUCATION AND EXPERIENCE

• Undergraduate degree required; statistics, data analytics or related degree preferred
• 4+ years of professional experience in data analysis, statistical reporting, program evaluation or related analytical work required
• Experience extracting, cleaning, transforming and analyzing data from multiple sources using SQL or comparable data analysis tools required
• Experience using statistical programming or analytical software, such as R, SAS or Python required; R experience strongly preferred
• Experience in child welfare or programs utilizing evidence-based and data-driven practices preferred

WORK ENVIRONMENT

• Limited to no travel required

The Dave Thomas Foundation for Adoption is an equal employment opportunity employer and does not discriminate against any employee or applicant based on race, color, religion, religious beliefs, political affiliation, creed, HIV/AIDS status, ethnicity, sex, age, national origin, ancestry, disability, sexual orientation, gender, gender identity, gender expression, pregnancy, marital status, familial status, veteran/military status, predisposing genetic characteristics, domestic violence victim status, prior arrest or any other category protected by applicable law. Any employee who engages in such conduct is subject to disciplinary action, up to and including discharge.