Associate Director of Program Data and Analytics

About Our Team

The mission of the DREAM Data Team is to provide staff with the information necessary to improve our work and the lives of youth by creating effective systems for data collection, reporting, and analysis, and building staff capacity to make the best data-driven decisions possible.

About This Role

Reporting to the Senior Director of Data and Assessment, the Associate Director of Program Data & Analytics helps build the strategy and owns the execution for program-facing data systems and reporting across several core areas. This leader will oversee the design and continuous improvement of data collection, reporting, analysis, and business intelligence tools that support key programmatic decisions and outcomes.

This role requires cross-functional leadership, stakeholder management, and technical fluency. The Associate Director must be able to translate program needs into scalable systems, prioritize across multiple internal clients, and drive adoption of data tools and practices across teams.

Core programmatic areas include, but are not limited to:

• Extended Learning and Enrichment (including after-school and summer): Oversee systems, drive fidelity, create tools, and prepare reports related to enrollment, demographics, attendance, and program quality observations in student information systems

• Social Emotional Learning (SEL): Lead the data strategy for student SEL survey administration, vendor management (Valor, DESSA, HelloInsight), analysis, and reporting to support data fidelity and program decision-making. 

• Legends (DREAM graduate support): Partner with program leadership to evolve and maintain the data ecosystem aligned to program goals and performance indicators. Support counselors in data integrity and usage.

• Athletics, Health, and Wellness (AHW): Lead K-12 AHW data systems design and reporting to support enrollment, participation, roster management, and engagement.

• Family and Community Engagement (FACE): Build out the data infrastructure and execute on the FACE data strategy. Advise on the key metrics, and integrate them into school goals and business intelligence products

• Social Work and Mental Health: Ensure strong systems and reporting for mandated counseling services, compliance monitoring, support for students receiving Response to Intervention services and/or mental health services, and connecting families to social services.

The Associate Director will maintain the current suite of business intelligence products and utilize user research to enhance existing products as well as build new ones. Areas of responsibilities include, but are not limited to:

Strategic and Cross-Functional Partnership 

• Serve as the primary data partner to senior program leaders across DREAM’s programmatic portfolio;

• Build strong relationships with stakeholders across programs to identify needs, clarify priorities, and translate business questions into data solutions;

• Influence decision-making by helping leaders use data to drive program improvement, resource allocation, and strategic planning;

• Create clarity and alignment around key program metrics, definitions, reporting cycles, and ownership;

• Provide continuous oversight and improvement on program data systems.

Data Infrastructure

• Maintain relevant Python and FiveTran pipelines;

• Develop expertise on DREAM’s BigQuery data warehouse;

• Create Data Studio business intelligence products;

• Ensure that program data systems are reliable, scalable, and aligned to both operational and strategic needs;

• Lead efforts to improve data quality, survey administration, documentation, governance, and cross-system consistency;

• Partner with technical teammates and external vendors as needed to enhance integrations, workflows, and reporting infrastructure;

• Act as the point person for K-12 summer program data planning and execution.

Reporting, Analysis, and Decision Support

• Oversee recurring program reporting and analysis, including grants, school and alumni surveys, compliance, KPI tracking, and stakeholder-facing dashboards;

• Lead the development of quarterly data day visualizations and other high-impact presentations for program and organizational leadership;

• Partner with program leaders to identify trends, surface insights, and connect program participation and services to youth outcomes;

• Support evaluation and analysis of key initiatives, including work related to counseling, attendance, engagement, and other priority program outcomes;

• Ensure reporting is timely, accurate, decision-useful, and tailored to different audiences.

Product and Continuous Improvement Leadership

• Lead the evolution of DREAM’s suite of business intelligence products for programs, ensuring tools are useful, intuitive, and aligned to stakeholder needs;

• Conduct and apply user research to improve adoption, usability, and effectiveness of dashboards and reporting tools;

• Identify opportunities to automate recurring workflows, simplify reporting, and reduce manual work for both the Data Team and program teams;

• Contribute to network-wide data strategy and help shape the future of program data infrastructure at DREAM;

• Lead analytic work that helps program leaders understand trends, assess performance, and identify opportunities for improvement across program areas;

• Translate complex programmatic questions into analytic plans, actionable insights, and recommendations that support continuous improvement and strategic decision-making.

Team and Project Leadership

• Manage large, cross-functional projects from scoping through execution, including planning, communication, change management, and follow-through;

• Establish clear project plans and priorities across competing demands and ensure strong execution against deadlines;

• Support the development of team systems, processes, and norms that improve responsiveness and sustainability;

• Serve as the primary supervisor and coach for seasonal Data Interns.

Required Qualifications

• Bachelor’s degree required; advanced degree in a related field preferred;

• 4+ years of relevant experience in education, youth development, data analysis, analytics, or data systems leadership;

• Technical Qualifications:

  • Experience with SQL, required, and experience with Bigquery standard SQL preferred;

  • Familiarity with Python, Git, and modern data workflows, preferred;

  • Experience with cloud data warehouse solutions such as BigQuery, Snowflake, or Redshift;

  • Experience with business intelligence and data visualization tools such as Looker, Tableau, or Power BI;

• Experience conducting user-centered design, stakeholder discovery, or UX research to improve internal tools and processes;

• Experience in a charter school management organization, youth development organization, or similarly complex mission-driven environment, a plus;

• Demonstrated success owning complex, cross-functional work that requires both strategic thinking and strong execution;

• Experience partnering with senior stakeholders and navigating multiple priorities in a collaborative, solutions-oriented way;

• Excellent communication skills, with the ability to distill complex concepts into clear insights and recommendations;

• Strong project and change management skills, including the ability to lead long-term initiatives and drive adoption across teams.