District Data Support Analyst
About The Position
The California College Guidance Initiative (CCGI) is seeking a District Data Support Analyst to join the Data Services team. This role focuses on supporting Local Education Agencies (LEAs) in implementing transcript-informed functionality on CaliforniaColleges.edu. The analyst will be responsible for managing the receipt, processing, troubleshooting, and data validity reviews of district transcript files. This includes the recurring management of transcript files, addressing discrepancies reported by educators, and assisting LEA staff in resolving file-related issues. The position also involves close collaboration with Technical Assistance staff to resolve cases related to transcript files and working with LEA experts to ensure timely and accurate transcript data. For new LEAs, this involves supporting the creation of transcript files or advising on related issues. While this role does not involve writing production code, a comfort level with tools like SQL, Jira, Excel, and Salesforce is preferred. The ideal candidate will have experience in K-12/higher education data systems or student records management, an understanding of student transcript data nuances, and an interest in large educational systems and the equity challenges students face. The role requires comfort with ambiguity and a passion for promoting public education and advancing educational equity.
Requirements
- Bachelor’s Degree in a Business, Math, Information Technology related major or equivalent professional experience.
- At least two years of cumulative professional experience.
- At least three years experience with K-12 or higher education transcript data sets.
- Minimum of 2+ years’ experience working with and analyzing complex data files and file formats.
- High level of comfort working with large data sets using text editors and SQL or similar language to query Transcript files.
- Familiarity with one or more K-12 student information systems (SIS), such as PowerSchool, Aeries, Infinite Campus, Synergy, etc., is required.
- Demonstrated ability to develop technical documentation.
- Strong decision-making skills and collaborative spirit, with the ability to take abstract brainstorming and generate concrete proposals for action.
- Ability to advance projects without detailed supervision, balancing multiple responsibilities and providing colleagues with actionable proposals for advancing collective efforts.
- Desire to collaborate with others by providing and receiving direct feedback, being vulnerable, and leading with professionalism and kindness.
- Ability to thrive in a fast-paced environment with changing priorities and deadlines.
- Ability to juggle multiple projects of various scopes with ease and grace.
- Meticulous attention to detail.
- Excellent verbal communication skills and the ability to communicate with various levels of professionals.
- A commitment to the ongoing process of recalling and identifying what you’ve learned from each project, then explaining what you’ve learned to others, and finally making connections that allow you to implement change for your next project.
- Must currently live full-time in California.
Nice To Haves
- Familiarity with CALPADS data sets is a plus.
- A level of comfort with the software tools and languages in use at CCGI (SQL, Jira, Excel, Salesforce) is preferred.
- Experience working in K-12/higher Ed data systems and/or student records management and understands the nuances of student transcript data.
- Interest in large educational systems and the equity challenges that students face when navigating such systems.
Responsibilities
- Regularly process and review logs for transcript files in AWS and CaliforniaColleges.edu environments.
- Develop documentation that considers the technical and end user needs to create the transcript files and convey data validity concerns in an articulate, actionable manner.
- Ensure progress on cases in accordance with case management specifications.
- Support ongoing quality assurance testing on transcript files for existing and onboarding districts.
- Perform research and design test case scenarios to identify system bugs.
- Support investigation and resolution of transcript file issues both structural and data validity.
- Develop and maintain documentation that supports the processing of transcript files.
- Communicate and/or virtually meet with Data Leads in CCGI partner LEAs to resolve data file related items.
- Other duties as assigned by your supervisor.
Benefits
- Paid holidays
- Sick and vacation leave
- Medical insurance
- Dental insurance
- Vision insurance
- Employee Assistance Program
- Defined benefit retirement plan (CalPERS)
- 403(b) and 457(b) retirement plans
- $50,000 Basic Life and Accidental Death and Dismemberment insurance coverage for eligible employees
- Flexible Spending Accounts
- Tuition Reimbursement
- Voluntary Life Insurance
- Pet insurance
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
