Data Analyst

Socket.dev; Los Angeles (CA); Hybrid; USD 75,000 - 88,000; Full time

Benefits offered by this job

Competitive salary

Paid vacation & sick time

Lifecraft program

Upward mobility

Health, dental & vision

403(b) retirement plan

Pet insurance

Mission-driven work

Job summary

Woodcraft Rangers is seeking a Data Analyst to translate messy operational data into clean, decision-ready outputs. You will support funder submissions and internal decision-making with dashboards and analyses.

The role reports to the Associate Director of Data Operations and requires collaboration with program leaders across the Core (LA + SGV) and Inland Empire regions. The ideal candidate has a strong data mindset, Excel and Power BI proficiency, and experience with FERPA and district

Qualifications

• 3–5 years of experience in a data analyst, reporting analyst, or comparable role.
• Experience producing recurring external reports for funders or comparable entities.
• Strong proficiency in Excel (pivot tables, advanced formulas, data cleaning).
• Experience building dashboards in Power BI or similar BI tools.
• Working knowledge of FERPA and student data privacy requirements.

Responsibilities

• Build, validate, and submit external funder reports in partnership with program leadership.
• Build and maintain dashboards, KPI, and trend reports across Core and IE.
• Collaborate with Program leadership and data managers to ensure data quality and reporting readiness.
• Translate data into clear insights for non-technical audiences and leadership.

Skills

Analytical thinking

Communication skills

Attention to detail

Bilingual (English/Spanish)

Education

Bachelor’s degree in related field

Tools

Power BI

Excel

SQL

Job description

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?

Who We Are:

In 1922, Woodcraft Rangers opened its doors in Los Angeles and began its mission of guiding young people as they explore pathways to purposeful lives. As a progressive organization, Woodcraft has always been responsive to the evolving needs of the communities served, and is notably inclusive, youth-led, and rooted in the Woodcraft Way, a holistic framework that develops body, mind, spirit, and service. Continuously at the forefront of expanded learning opportunities, Woodcraft Rangers has a rich history of making a significant impact in the greater Los Angeles area, believing that all youth are innately good, deserve the opportunity to realize their full potential, and should be an active participant in defining their own path.

What We Do:

Woodcraft Rangers provides TK-12 expanded learning programs, including before and after school, specialty enrichment, and summer learning. In the past few years, Woodcraft has expanded its menu of services beyond traditional afterschool programs and summer camps to include early learning, environmental and social justice, college access, and inclusion services for youth with intellectual and developmental disabilities. Additionally, we offer LifeCraft, a college and career advancement program to support the development of approximately 2,250 staff. Today, Woodcraft Rangers serves more than 30,000 youth ages 4 to 18 each year across 150 plus Title I schools in Los Angeles, San Bernardino, and Riverside counties, and continues to expand its reach.

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.

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 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:

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