Description
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.
For consideration, please email your updated resume to Joseph Aubele at jaubele@ocde.us
Requirements
Any combination of education and experience that would likely provide the required knowledge and abilities is qualifying:
- Coursework or training in data science, statistics, computer science, or related fields.
- Hands-on experience with R for data cleaning and transformation (through coursework, research, or projects).
- Bachelor’s degree in data science, statistics, or related discipline preferred.
- Ideal for graduate students or early-career professionals seeking applied experience in data preparation and management.
Qualified Candidates Should have knowledge of: - Strong knowledge of PR programming and the tidyverse workflow.
- Experience cleaning, reshaping, and standardizing datasets.
- Understanding of reproducible data practices and version control.
- Familiarity with importing/exporting common data formats (CSV, Excel, text files).
