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)

Are you passionate about giving back to your community and making a lasting difference in the lives of young people?

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 a funder submission and a Program leadership dashboard, 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 the tools, and genuinely curious about what the data is telling 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.
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 the 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:
In compliance with the Americans with Disabilities Act (ADA), the following physical demands may be essential for the effective performance of this position. Reasonable accommodation will be considered to enable individuals with disabilities to perform these essential functions:

• 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:
We are committed to fostering an inclusive work environment and will actively consider reasonable accommodations to enable individuals to effectively perform their roles. This position operates in environments typical of the following key aspects:

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