Associate Consultant: Data & Analytics Practice | Net Impact

Associate Consultant: Data & Analytics Practice

VIVA Social Impact Partners

Company and Role Overview

VIVA is a women-owned social impact consulting firm partnering with nonprofits, public agencies, philanthropic organizations, and impact-forward companies to provide transformative strategy, communications, and data & analytics services. We believe that effective partnership is essential to achieving impact and creating stronger communities. We work closely with our clients, leveraging a unique and highly effective integrated approach to strategy, communications, and data & analytics. Across these three service areas, our work focuses on collaboration, high quality, and meaningful outcomes.

This position will partner with VIVA’s Director of Data & Analytics to collect and analyze different types of data (e.g. survey, budget, descriptive) to provide insight for our clients’ social impact efforts. This position will also be responsible for developing effective deliverables to use for client discussion and decision-making (e.g. presentations, dashboards, data briefs). In addition to doing the data work, an ideal candidate will have an entrepreneurial interest in helping drive the continued growth of the Data & Analytics practice through new projects for current and developing clients.

This position will also work with VIVA project teams across our other focus areas - strategy and communications - to provide generalist consulting support on projects for a range of social impact clients and focus areas within the children, family, and community space.

Core Value: VIVA is looking for an Associate Consultant with demonstrated commitment to equity and social change.

Key Responsibilities

  • Data-Related Client Facing Work (estimated to be 75% time)
  • Supports qualitative data collection (e.g. developing interview and focus group guides, pulling impactful quotes, themes, and (as relevant) quantitative data)
  • Supports quantitative data collection (e.g. data request drafting, document collection monitoring, data review and organization)
  • Conducts data analysis in excel, including basic excel formulas (SUMIF, SUMIFS, INDEX MATCH, IF statements, etc.), financial modeling, and other backend analysis needed for data preparation and chart creation
  • Conducts data analysis and visualization in Tableau, including chart creation, data mapping, and dashboard creation
  • Conducts data visualization and storytelling in PowerPoint; focus on using data to support discussions and decision making through effective visuals, slide creation, organization, and pacing
  • Drafts and/or assists with the preparation of client reports and presentations
  • Prepares client meeting notes

General Consulting Support (estimated to be 25% time)

  • Serves as the project coordinator on client projects
  • Leads project team meetings, including developing the agenda with input from the team, and preparing all related meeting materials
  • Conducts research, including related analysis and synthesis to support projects
  • Drafts agendas and meeting materials for client meetings
  • Supports the development of project work plans with activities, assignments, timelines and deliverables including maintaining project management systems
  • Monitors the completion of all deliverables for assigned projects
  • Serves as the logistical point of contact for meetings and events, including scheduling and travel arrangements
  • Other duties as assigned to support client projects and firm operations

Job requirements
Education: Bachelor’s degree


  • 2+ years full-time post-degree experience in consulting, research, evaluation, advocacy, or directly-related position
  • Strongly prefer this experience in a professional services organization. A Master’s degree may be used to substitute one year of full-time work experience

  • 1+ years experience in a professional setting where advanced functions of Excel were used on a regular basis
  • Must be able to provide examples of commitment to social impact through previous work or personal volunteer experience


  • Strategic thinking/critical thinking
  • Ability to analyze information and identify possible solutions/approaches
  • Strong writing skills and ability to communicate complex ideas in writing (reports and slides) and verbally
  • Effective public speaking
  • Professional internal and client interaction
  • Comfortable leading groups in-person and remotely (ie. via phone and video conference)
  • Creativity
  • Nice to have: Spanish language proficiency

Technical Skills:

  • Strong proficiency in Excel
  • Strong proficiency in PowerPoint
  • Familiarity with Google Cloud products (Google docs, Google Sheets, etc.)
  • Ability to switch between Mac and PC systems
  • Nice to have: experience with Salesforce
  • Nice to have: experience with Tableau

Core Values, Skills & Capacities

  • Demonstrated commitment to equity and social change
  • Excellent organizational skills
  • Excellent time management and efficient work style
  • Excellent customer service – internal/external
  • Takes initiative to create a solution when facing an expected or unexpected obstacle
  • Keeps calm and makes good decisions when under pressure
  • Effective communication feedback loops within the VIVA team
  • Minimum supervision required to complete high quality work
  • Reliable
  • Conscious and supportive of team members including initiating assistance
  • Recognizes other team members’ strengths and seeks learning opportunities
  • Contributes to positive work environment

In order to fulfill the essential job functions and duties the Employee must:

  • Be legally authorized to work in the United States
  • Have a valid CA drivers license, and be in good standing with the DMV, with the ability to drive to and from business meetings
  • Have current automobile insurance coverage
  • Ability to lift at least twenty pounds of equipment into and out of a car to set up for meetings
  • Work from VIVA office, unless arrangements have been made to work from home or to attend in-person business meeting*
  • Ability to travel throughout California to conduct business

Salary Range: $55,000 - $70,000

* This position will be working remotely until restrictions related to COVID-19 are lifted. At that point, work will take place from the VIVA office in San Mateo, CA.