Short Term Data Analyst - Educational Services Division

About the Employer

The Orange County Department of Education (OCDE) serves some of Orange County's most vulnerable student populations and provides support and mandated fiscal oversight to 28 school districts serving more than 600 schools and approximately 475,000 students.

In addition to providing direct instruction to students through its own alternative and special education programs, OCDE administers an array of programs and services that are critical to the operations of local school districts and community colleges, facilitating professional development, legal guidance, payroll, career and technical education support, high-speed internet access, Local Control and Accountability Plan assistance and approval, resources for families, and student enrichment.

OCDE's vision is that "Orange County students will lead the nation in college and career readiness and success." Department staff are working to achieve this goal in collaboration with educators at all levels of student development, from early childhood through higher education, and in partnership with families, businesses and community organizations.

Job Summary

The Orange County Department of Education's Continuous Improvement and Leadership Development (CILD) team is seeking short-term support from skilled data enthusiasts to help transform statewide education data into meaningful insights that drive positive change for students, schools, and communities.

In this role, you'll contribute to a high-impact project focused on extracting, transforming, and loading (ETL) publicly available datasets from the California Department of Education (CDE). These datasets will be used to power interactive data visualizations, white papers, and research briefs that support data-informed decision-making across Orange County and beyond. Working with experienced data and research professionals, you'll help ensure that complex educational data is transformed into clear, accurate, and actionable information that tells the story behind student success.

Key Responsibilities :

• Clean and transform publicly available education datasets for integration into a centralized data system.
• Use established R templates and the tidyverse suite (dplyr, tidyr, readr, etc.) to reshape, standardize, and prepare data.
• Perform essential data manipulation tasks, pivoting, renaming variables, ensuring consistency across multiple years.
• Follow structured workflows to ensure accuracy and reproducibility.
• Collaborate with our team to create clean, well documented code that supports meaningful data insights.

Requirements / Qualifications

Comments and Other Information

Before receiving authorization to work in this position, the individual selected will be required to provide a current negative TB authorization, within the last 60 days, and submit fingerprints for the purpose of conducting a confidential background investigation and record check. The tests are arranged and paid for by OCDE.

The Immigration Reform and Control Act of 1986 requires employers to verify the employability of all new employees. Before the Department will finalize an offer of employment, the candidate selected will be required to show original documents which establish both the individual's identity and employment authorization. The candidate must also sign a statement under penalty of perjury regarding his / her employability.

This position does not offer medical or dental benefits

We reserve the right to reopen, readvertise, or delay filling this position.

AA / EOE / ADA