Data & Performance Measurement Analyst Job Columbus area,Ohio USA,IT/Tech

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

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

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

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

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

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)

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

Assist in the preparation, production and dissemination of publications, presentations and research resources ensuring completion within established timelines

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

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…