Data Analyst, Strategic Impact

Career Opportunity

Data Analyst, Strategic Impact

California, Remote

Posted: 4/10/23

The California College Guidance Initiative (CCGI) is looking for an experienced data analyst to join the Strategic Impact team. The Data Analyst, Strategic Impact contributes to the development of CCGI’s data visualization and analysis tools and promotes a data-driven approach to CCGI’s work. As a part of the Strategic Impact team, you will be a key collaborator, aiding in the expansion, refinement, and development of CCGI’s data analytics and visualization tools to help advance our organizational mission.

The ideal candidate has extensive experience creating intuitive data products and visualizations that concisely and thoughtfully answer the most critical organizational questions. They must be comfortable using tools like SQL and Python to power analytical dashboards and query our data warehouse to produce reports and analyses. They have 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. Additionally, the Data Analyst, Strategic Impact is expected to develop comprehensive documentation and resources to support staff and external stakeholders in accessing, using, and interpreting data products.

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. This role reports to the Director, Strategic Impact.

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
  • Manage the design process with internal stakeholders submitting new analytics requests, including meeting with users to understand use cases, setting expectations for project timelines, and managing project communications.
  • 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 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
  • 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.

What Technical Skills Do You Need?

  • Advanced proficiency designing and developing well thought-out data products (data dashboards in Tableau, etc.) and analyses.
  • Ability to conceptualize clear ways of visualizing data that tell stories and provide insights in clear and concise ways.
  • Professional experience implementing UX/UI principles and best practices to data visualization projects
  • Proficiency with SQL (SQL Server, PostgreSQL, MySQL, etc.) as well as an understanding of relational databases and query authoring and optimization
  • Proficiency with scripting languages like Python, R, etc.
  • Familiarity with ELT/ETL tools like Matillion, FiveTran, Talend, etc.
  • A successful history of manipulating, processing and extracting value from large structured and unstructured datasets.
  • Exceptional analytical skills and attention to detail.
  • A critical thinker who can independently and collaboratively solve problems
  • Experience with Salesforce preferred, or similar Customer Relationship Management tool.

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.
  • Meticulous attention to detail.
  • Excellent verbal communication skills and the ability to communicate with various levels of professionals.

More about the Strategic Impact team

CCGI’s Strategic Impact team works to support colleagues across the organization to create intelligence from data in order to inform decision making and advance CCGI’s equity agenda. The team also drives organizational reporting for external stakeholders including school districts, colleges and system offices such as CCCO, CSUCO, UCOP etc., and funders. The team is composed of individuals, working remotely across California. You would thrive on the Strategic Impact team if you view data as a tool to advance educational equity, believe in continuous learning, and are interested in working in a start-up like environment alongside a growing team.

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 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 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.


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