California College Guidance Initiative, Data Analyst

Job Type

Full Time

Job Location

Sacramento, CA

Website URL

Apply Now

Job Description

The California College Guidance Initiative is looking for a seasoned data analyst to join the Data and Analytics Infrastructure Team. As part of the Data and Analytics Infrastructure Team, you will be a key collaborator, aiding in the expansion, refinement, and continued development of CCGI’s data analytics and engineering tools. This role will be instrumental in helping us scale our work statewide and open the door for expanded use of California's official college and career planning platform for K-12th grade students, parents, and educators,

The ideal candidate for this team has extensive experience building out data reports, analyses, and data dashboards that concisely and thoughtfully answer the most critical organizational questions as well as provoke new inquiries that propel new analyses (we use Tableau). They must be comfortable using analytical tools like SQL, Python, R, etc, as these tools are the foundation of our organizational dashboards.They also have familiarity working with and in complex data architectures, data structures, and data pipelines. Additionally, this person has extensive experience developing dashboards governed by strong UX/UI best practices, as well as a deep knowledge and/or curiosity about the needs and behaviors of students, educators, and parents, and a passion for educational equity.

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.

We work 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?

  • Design user-centered dashboards:
    • That answer the questions being posed by end users
    • With intuitive navigation for entry level dashboard users
    • That simply, clearly, and compellingly present data in ways that are accessible to target audiences
  • Meticulously review and analyze data sets that inform dashboards to:
    • Ensure accuracy
    • Identify patterns and the stories that can be told
  • Support and adhere to routines that aid in the development, refinement and maintenance of the internal analytics and data engineering tools which include the following:
    • Tableau dashboards, external data reports, ad-hoc queries and analyses
    • AWS microservices, Snowflake, Airflow, ELT/ETL tools, Python, SQL, and shell scripts and/or
  • Assist in the development, refinement and maintenance of the internal analytics tools (Tableau dashboards, Snowflake)
  • Make complex and large datasets understandable and accessible to a variety of internal and external stakeholders.
  • Assemble large, complex data sets that meet functional / non-functional business requirements

What Technical Skills Do You Need?

  • Advanced SQL knowledge (SQL Server, PostgreSQL, MySQL, etc.) and understanding of relational databases, query authoring and optimization, as well as working familiarity with a variety of databases.
  • Proficiency with scripting languages like Python, R, etc.
  • Familiarity with ELT/ETL tools like Matillion, FiveTran, Talend, etc.
  • Advanced proficiency designing and developing well thought-out data products (data dashboards in Tableau, Power BI, etc) and analyses. Work product preferred.
  • Familiarity with project management software and tools (JIRA, Asana, Monday, Trello, etc...)
  • A successful history of manipulating, processing and extracting value from large structured and unstructured datasets.
  • Professional experience implementing UX/UI principles and best practices to data visualization builds.
  • Ability to conceptualize clear ways of visualizing data that tells the stories and provide insights in clear and concise ways.
  • Exceptional analytical skills and attention to detail.
  • A critical thinker who can independently and collaboratively solve problems.

What Intangibles Do You Need?

  • Strong decision-making skills and collaborative spirit with the ability to take abstract brainstorming and generate concrete proposals for action.
  • 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 projects of various scopes with ease and grace.
  • Meticulous attention to detail.
  • Excellent verbal communication skills; ability to communicate with various levels of professionals.
  • Strong organizational, project, and time management skills.

More about the Data and Analytics Infrastructure Team

The team oversees all of CCGI’s internal cloud-based data analytics and engineering infrastructure and technical strategy. This includes data analytics, data warehousing, and data engineering projects, ensuring alignment with the organization's mission and goals.

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, 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 is a positive, diverse, and supportive culture.

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 non-discrimination 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).

Application Instructions

Please go to our Careers page to submit an application at: