Data Analyst

Data Analyst Reports To: Associate Director of Data Operations Status: Full-time; Exempt Location: Hybrid – Los Angeles (Little Tokyo Office), with occasional travel to the Inland Empire office and to program sites across Core (LA + SGV) and IE regions Hours of Operation: Monday–Friday, 8:00 AM – 5:00 PM, with flexibility required during reporting cycles Salary Range: $75,000 – $88,000 annually (based on experience and qualifications) Ideal Candidate: The ideal candidate is a strong analytical thinker who loves translating messy operational data into clean, decision-ready outputs. They are equally rigorous about funder submissions and program leadership dashboards, and they know that the value of analysis is measured by the decisions it enables — not the volume of charts produced. They take ownership of their work, ask sharp clarifying questions, and partner well with the data team, program leaders, and external reporting cycles. They are detail-oriented without being slow, fluent with tools, and genuinely curious about what data tells them about young people and the programs that serve them. They are not interested in supervising or owning routine data cleanup — they want to build the analysis layer on top of clean data. Why Work for Woodcraft Rangers: Competitive salary – see range above Paid vacation & sick time – generous time off to recharge Lifecraft program – free college & career advancement for all staff Upward mobility – promote-from-within culture Health, dental & vision – comprehensive benefits coverage 403(b) retirement plan – invest in your future Pet insurance – because your whole family matters Mission-driven work – impact 30,000+ young people annually Role Overview: The 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 dashboards, KPI reports, trend reports, and ad-hoc analyses that Program, Operations, Compliance, and leadership teams rely on for decision-making. The Analyst does not supervise Coordinators and is not responsible for routine data cleanup or workflow execution. Responsibilities: Funder & External Reporting (Primary Priority) 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. Internal Dashboards & Analysis (Secondary Priority) 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. Partnership & Collaboration 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. Tools & Documentation 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: Required 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. Preferred 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). 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. #J-18808-Ljbffr