DATA ANALYST

Ayers Foundation Trust; Tennessee; Presencial; USD 60.000 - 80.000; Tempo integral

Resumo da vaga

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.

Qualificações

• 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.

Responsabilidades

• 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.

Conhecimentos

Data analysis

Data privacy

Cross-functional collaboration

Project management

Formação

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

Ferramentas

Salesforce CRM

Google Sheets

Excel

Canva

Descrição da vaga

Full-Time Exempt Professional

Job Description

The Data Analyst plays a vital role in supporting the Ayers Foundation Trust’s mission to increase post-secondary enrollment and completion rates. This role is responsible for collecting, managing, and analyzing student success metrics including FAFSA completion rates, TN Promise compliance, college application status, and post-secondary enrollment. Operating at the intersection of regional field teams (College Access Counselors and Student Success Coordinators) and executive leadership, the Data Analyst transforms raw data into actionable insights that drive strategic decisions which ultimately leads to better postsecondary outcomes for Ayers Scholars.

Essential 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.

Competencies:

• Exemplary team mindset while maintaining a high level of pride, openness, and honesty in all aspects of work.

• Utilizes sound judgement that supports high accountability for actions and decisions.
• Superior relationship‑building skills and ability to establish rapport with a wide range of personalities and backgrounds. .
• Manages workload in an organized manner that anticipates and diffuses problems.
• Maintains professionalism, composure, and a positive attitude while effectively navigating high‑stress and fast‑paced situations.
• Demonstrates a high level of productivity that includes appropriate prioritization of urgent and time sensitive tasks.
• Maintains confidentiality when handling sensitive, private, or restricted information.

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.