Data Analyst

Woodcraft Rangers•Los Angeles, CA

4d•$75,000 - $88,000•Hybrid

About The Position

Woodcraft Rangers is seeking a passionate Data Analyst to join their team. This role is crucial for translating operational data into actionable insights that support decision-making across the organization. The ideal candidate is a strong analytical thinker with a keen eye for detail, capable of producing accurate and timely reports for funders and internal stakeholders. This position offers the opportunity to make a significant impact on the lives of young people by improving program effectiveness through data-driven strategies.

Requirements

3–5 years of experience in a data analyst, reporting analyst, or comparable role.
Demonstrated experience producing recurring external reports — preferably for government, grant, or foundation funders.
Strong proficiency in Excel, including pivot tables, advanced formulas, and data cleaning.
Experience building dashboards in Power BI, or comparable BI tooling.
Working knowledge of FERPA and student data privacy requirements.
Strong attention to detail, especially for external submissions where accuracy is non-negotiable.
Clear written and verbal communication skills, with the ability to explain data to non-technical audiences.

Nice To Haves

Bachelor’s degree in a related field (Data Analytics, Statistics, Public Policy, Education, or related), or equivalent professional experience.
Experience with funder reporting for ASES, 21st CCLC/ASSETs, ELOP, or comparable expanded learning funders.
Experience with expanded learning data systems (EZReports, Afterschool HQ) and/or district SIS platforms (Aeries, Synergy, Infinite Campus).
SQL proficiency.
Experience in a youth-serving nonprofit or education sector.
Bilingual (English/Spanish).

Responsibilities

Build, validate, and submit funder reports for ASES, 21st CCLC/ASSETs, ELOP, and foundation funders in partnership with the Associate Director who owns funder relationships and definitions.
Build and maintain district-facing reports in alignment with data sharing agreements and partner expectations.
Manage the production calendar for external reporting cycles in coordination with the Associate Director.
Pre-validate external submissions against quality standards before sign-off, and surface anomalies for resolution.
Document reporting definitions, methodology, and data lineage for external reports so the work is reproducible and audit-ready.
Build and maintain dashboards, KPI reports, trend reports, and performance reporting across Core and IE for Program, Operations, Compliance, and leadership audiences.
Analyze attendance, enrollment, participation, and site-level data to identify patterns, risks, and opportunities.
Conduct ad-hoc analyses to support program decisions and leadership questions.
Translate raw data into clear, usable decision-making information for non-technical audiences.
Partner closely with Program leadership as a primary internal customer; ensure dashboards and analyses serve program decision-making.
Collaborate with the Core and IE Data Managers to ensure source data is fit for reporting and analysis purposes.
Partner with Compliance and Operations on cross-functional reporting needs.
Surface data quality issues to the Associate Director and Managers for resolution, rather than working around them.
Maintain reporting tools, dashboards, and supporting documentation.
Recommend improvements to data structure, reporting tools, and analytical workflows.
Ensure all data handling complies with FERPA, district data sharing agreements, and applicable student data privacy laws.