Data Analyst - Student Success Insights & Dashboards

Ayers Foundation Trust; Tennessee; On-site; USD 60,000 - 80,000; Full time

Job summary

Ayers Foundation Trust in Tennessee seeks a Data Analyst to support post-secondary enrollment initiatives. You will collect, manage, and analyze metrics like FAFSA completion, TN Promise compliance, and college enrollment to guide executive decisions.

You will build and maintain dashboards, ensure data accuracy, and collaborate across field teams and leadership. A data-focused background with privacy compliance is essential.

Qualifications

• Bachelor’s degree in Data Analytics, Statistics, Information Systems, Education Policy, or a related field; 2+ years of experience in data analysis preferred.
• Proficiency with Salesforce CRM database management preferred.
• Advanced skills in spreadsheet modeling (Google Sheets / Excel / and Canva) preferred.
• Deep commitment to data privacy, FERPA compliance, and ethical data handling.

Responsibilities

• Oversee data pipelines and processes for tracking student cohorts across FAFSA/financial aid verification, community service completion, and college matriculation, ensuring data accuracy and compliance.
• Maintain student rosters throughout the academic year, gather graduation rosters, resolve data discrepancies, and communicate relevant changes to THEC.
• Partner with all Ayers team members to ensure consistent, accurate field data entry and maintain standardized data management practices.
• Maintain Data Systems, Workflows, and Dashboards: Develop and maintain workflows, dashboards, and data systems, including support for Mongoose, to improve operational efficiency and data accessibility.
• Monitor key performance indicators, including Ayers Success Metrics (ASM), Tennessee Promise, and FAFSA completion targets, to assess progress toward program goals.
• Create biweekly and quarterly regional briefing dashboards that highlight site-level progress, identify operational bottlenecks, and support leadership decision-making.
• Analyze historical trends to identify and prioritize students needing targeted assistance with FAFSA completion, TCAT and community college applications, and fall graduation.
• Assist with THEC reporting for meetings and community service, CHT and economic impact analyses, alumni data management, and preparation of the annual board report.
• Build predictive frameworks to address summer melt and conduct risk assessments
• Collaborate on research initiatives and external evaluation projects to assess program effectiveness, identify improvement opportunities, and inform strategic decisions.

Skills

Data analysis

Data privacy

Cross-functional collaboration

Project management

Education

Bachelor's degree in Data Analytics, Statistics, Information Systems, Education Policy, or related field

Tools

Salesforce CRM

Google Sheets

Excel

Canva

Job description

Ayers Foundation Trust in Tennessee seeks a Data Analyst to support post-secondary enrollment initiatives. You will collect, manage, and analyze metrics like FAFSA completion, TN Promise compliance, and college enrollment to guide executive decisions.

You will build and maintain dashboards, ensure data accuracy, and collaborate across field teams and leadership. A data-focused background with privacy compliance is essential.