Data Analyst, Technical Assistance

Career Opportunity

Data Analyst, Technical Assistance

All candidates must live in California.

Posted: 10/29/21

The California College Guidance Initiative (CCGI) is looking for an analyst to join the team that supports Local Education Agencies (LEAs) as they implement transcript-informed functionality on The Data Analyst, Technical Assistance, will oversee the receipt, processing, and troubleshooting of transcript-related cases, including:

  • Recurring receipt of transcript files from various LEAs in California.
  • Troubleshoot discrepancies found by educators.
  • Support LEA staff to resolve file issues.

The ideal candidate for this position has experience working in college/K-12 admissions and student records management. The candidate should have an interest in large educational systems and the equity challenges that students face when navigating such systems.

The Data Analyst, Technical Assistance is responsible for working closely with LEA experts to ensure transcript data is provided in a timely manner and is accurate. For new LEAs coming on board, this typically involves supporting LEAs to create the transcript files or to advise on issues when creating the transcript files. This position does not write production code. However, a level of comfort with the software tools and languages in use at CCGI (Jira, Excel, Salesforce) is recommended.

There are no direct supervisory responsibilities for this position, but you must be able to proactively and successfully partner and collaborate with other subject matter experts on a project management basis.

You will be part of a team that works to solve large scale, system-level problems. You must be comfortable project managing work with unknowns and ambiguous solutions, as well as passionate about promoting public education and advancing educational equity.

What Will You Be Doing?

  • Regularly process and review logs for transcript files in AWS and environments
  • Develop documentation that considers the technical and end user needs to create the transcript files.
  • Ensure progress on cases in accordance with case management specifications.
  • Support quality assurance testing on transcript files, such as designing test case scenarios.
  • Support investigation and resolution of transcript file issues.
  • Develop and maintain documentation that supports the processing of transcript files.
  • Other duties as assigned by your supervisor.

What Technical Skills Do You Need?

  • Bachelor’s Degree in a Computer Science/Database Management related major or equivalent professional experience.
  • At least two years of cumulative professional experience.
  • At least one year experience with K-12 and higher education data sets.
  • High level of comfort working with large data sets using text editors and SQL to query Transcript files.
  • Demonstrated ability to develop technical documentation.

What Leadership Skills Do You Need?

  • Desire to collaborate with others by providing and receiving direct feedback, being vulnerable, and leading with professionalism and kindness.
  • Strong professional judgement.
  • Ability to maintain a collaborative spirit.
  • 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.

What Intangibles Do You Need?

  • Advance projects without detailed supervision, balancing multiple responsibilities, and providing colleagues with actionable proposals for advancing collective efforts.
  • Thrive in a fast-paced environment with changing priorities and deadlines.
  • Juggle multiple ongoing projects with K-12 LEA’s with ease and grace.
  • Meticulous attention to detail.
  • Excellent verbal communication skills; ability to communicate technical details to non-technical audiences.
  • Strong organizational, project, and time management skills.

More about the Technical Assistance Team
The team is composed of individuals, working remotely across California, that support LEA’s in the state of California to ensure timely and accurate transcript data is processed in

The team does NOT include data scientists, developers or programmers. We work closely with the Director of Integrations and the Director of Infrastructure and Analytics to resolve bugs or anomalies when processing transcript files. In addition we work within a team that focuses on providing technical assistance to all LEA’s using transcript-informed functionality on with respect to resolving Course Management Portal (CMP) discrepancies and improving transcript transcription processes.

We are keen for you to bring experience that you can impart to the rest of us, but you also have to be interested to improve in many other skills and low ego enough to always take initiative to learn more. This role reports to the Director of Data Services.

More about CCGI

CCGI works to ensure that all 6th-12th grade students in California have access to a systematic baseline of guidance and support as they plan, prepare, and pay for postsecondary education and training.

This baseline is provided by, which provides California students and educators with a wide range of college and career planning information and tools. The site also houses, audits, and transmits student data to help ensure more accurate and efficient decisions regarding admissions, financial aid, and course placement. CCGI provides technical assistance, support, and training to K-12 school districts in order to support students, counselors, and parents with the systematic use of, including its transcript-informed tools.

CCGI forms the core of the college planning and application tools in California’s newly-launched Cradle-to-Career System. Over the next few years, the Cradle-to-Career System will scale CCGI so that all California 6th-12th grade students can have free access to our transcript-informed tools.

CCGI is a positive, diverse, and supportive culture. At our core, we prioritize the needs of students above all else.

Everyone at CCGI works remotely. We are all located in various parts of California. We rarely meet in person. Instead, we make use of tools, such as ZOOM, Slack, and Salesforce, to communicate and document our work.

CCGI is housed at the Foundation for California Community Colleges but is an autonomous initiative with its own mission, goals, and leadership team.

The Foundation for California Community Colleges (Foundation) is committed to providing an environment of mutual respect where equal employment opportunities (EEO) are available to all employees and applicants without regard to race, color, ancestry, national origin, genetic characteristics, sex, gender identity, gender expression, sexual orientation, marital/parental status, political affiliation, religion, age, disability, pregnancy, childbirth, breastfeeding or veteran status. In addition to federal law requirements, the Foundation for California Community Colleges complies with applicable state and local laws governing nondiscrimination in employment.

The Foundation for California Community Colleges is committed to workplace policies and hiring practices that comply with federal, state, and local law. During the hiring process, the Foundation is interested in hiring qualified candidates who are eligible and authorized to work in the United States. However, at this time, the Foundation is not able to sponsor visas. As a result, the Foundation cannot hire applicants that currently, or in the future, require immigration sponsorship for work authorization (i.e., H1B or F1 Student Visa).


If you have questions about CCGI career or RFP opportunities please contact us.