Data Analyst

Data AnalystThe Data Analyst is the primary builder of funder and external reporting outputs and the internal analysis layer that supports Woodcraft Rangers' decision-making across the Core (LA + SGV) and IE regions. Reporting to the Associate Director of Data Operations, the Analyst's primary priority is producing accurate, on-time funder and external reports (ASES, 21st CCLC/ASSETs, ELOP, foundation funders, and district reporting) in partnership with the Associate Director who owns the funder and district relationships. The Analyst's secondary priority is building and maintaining the dashboards, KPI reports, trend reports, and ad-hoc analyses that Program, Operations, Compliance, and leadership teams rely on for decision-making.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.Qualifications / Skills: Required3–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.PreferredBachelor'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).Physical Demands:Prolonged periods of sitting at a desk and working on a computer.Regular use of hands for various tasks, such as operating a computer and handling objects, is essential.The ability to travel across the Greater Los Angeles, San Gabriel Valley, and Inland Empire areas, using either a car or public transportation, is necessary several times a month.Must be able to occasionally lift/move up to 25 pounds.Reasonable accommodation is available for individuals with disabilities.Work Environment:Regular exposure to computer monitors during work.The typical noise level of a standard work environment.Stable internet access is required for effective work-from-home performance.Hybrid schedule with in-office days at the assigned office location and remote work days; specific cadence determined by supervisor.Woodcraft Rangers provides equal employment opportunities to all qualified applicants without discrimination with regard to race, religious belief, color, sex, sex stereotype, pregnancy, childbirth or related medical conditions (including breastfeeding), age, national origin, ancestry, sexual orientation, gender identification and expression, transgender status, transitioning status, physical or mental disability, medical condition, genetic characteristics, genetic information, family care, marital status, enrollment in any public assistance program, status as military, a veteran or qualified disabled veteran, status as an unpaid intern or volunteer, or any other classification protected by law. We also prohibit discrimination based on the perception that anyone has any of those characteristics or is associated with a person who has or is perceived as having any of those characteristics.