Data Support Analyst at Foundation for California Community Colleges (FCCC)

1 year ago Data & Databases Middle Full-Time

The California College Guidance Initiative is looking for an analyst to join the team that supports Local Education Agencies (LEAs) as they implement transcript-informed functionality on

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 judgment.
  • — 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 LEAs 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.


District Data Support Analyst

California College Guidance Initiative

Remote/Virtual within California — Full-Time

The California College Guidance Initiative is looking for an analyst to join the team that supports Local Education Agencies (LEAs) as they implement transcript-informed functionality on

The Technical Assistance District Data Support Analyst, will oversee the receipt, processing and troubleshooting of transcript-related cases, including:

  • Recurring management of transcript files from various LEAs in California
  • Troubleshoot discrepancies found by educators
  • Support LEA staff to resolve the 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 as well as a strong desire to manage others.

The Technical Assistance District Data Support 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.

We work to solve large scale, system-level problems. You must be comfortable working 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.

More about the Technical Assistance Team

The team is composed of individuals, working remotely across California, that support LEAs 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 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 Deputy Director, Technical Assistance, Data Services.

More about CCGI

The California College Guidance Initiative (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 CCGI partners with K-12 school districts to support students, counselors, and parents with the systematic use of, including transcript-informed tools. also houses, audits, and transmits student data to help ensure more accurate and efficient decisions regarding admissions, financial aid, and course placement.

Currently serving 20% of all 6th-12th students in California, CCGI is poised for significant growth over the next few years, ultimately enabling us to reach all 3.2 million public middle and high school students across the state.

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 application process will be open until the position is filled.

The Foundation for California Community Colleges 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 non-discrimination in employment.

As the official nonprofit auxiliary to the Chancellor's Office, we aim to ensure our team reflects the diversity of the California Community Colleges and the 2.1 million students, campuses, and communities it serves. Individuals are hired for their deep understanding of each population’s unique needs and will join a collaborative environment where each team member plays an important role in helping Californians across all communities improve their social and economic mobility and build a better future for themselves and their families.

Job Type: Full-time


  • Dental insurance
  • Employee assistance program
  • Employee discount
  • Flexible spending account
  • Health insurance
  • Health savings account
  • Life insurance
  • Paid time off
  • Referral program
  • Retirement plan
  • Tuition reimbursement
  • Vision insurance

🌍 World Wide sql data database analyst
🎉 Let Employers Find You!

Employers will see your profile when they are sending a job in your skill.

Create Your Profile   (simple)