Data & Performance Measurement Analyst in Columbus, Ohio at Dave Thomas Foundation For Adoption

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

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.