Data Analyst

JVS - Bay Area; United States; On-site; USD 90,000 - 140,000; Full time

Job summary

JVS - Bay Area is seeking a data-focused professional to lead reporting and data analysis, primarily pulling and preparing data from Salesforce and other systems for ongoing program performance reports. You will design Power BI dashboards, validate real-time reporting, and translate findings into accessible briefs for internal teams and external stakeholders.

The role emphasizes equity-driven analyses, ad hoc data requests, and collaboration with the Evaluation and Impact team to ensure data

Qualifications

• Experience pulling, cleaning, and preparing data from Salesforce and other systems for regular reports.
• Ability to design and iterate Power BI dashboards and Salesforce reports to answer program questions.
• Experience with data quality audits, data governance, and documenting datasets for reproducibility.
• Ability to translate analytical findings into accessible briefs for non-technical audiences.

Responsibilities

• Reporting & Data Analysis (60–65%): pull, clean, and prepare data to produce regular program performance reports for internal teams and external stakeholders.
• Conduct analyses on outcomes like participant results, program completion, retention, and equity, disaggregated by race, gender, etc.
• Design and iterate Power BI dashboards and Salesforce reports; validate that outputs reflect program reality.
• Validate accuracy of real-time reporting infrastructure and ensure dashboards use the right indicators.
• Produce data briefs and narrative summaries for decision-making by non-technical audiences.
• Respond to ad hoc data requests with accuracy and timeliness.
• Conduct wage equity and marketing referral source analyses and other recurring analyses.

Skills

Data analysis

Ad hoc data requests

Equity analysis

Narrative reporting

Stakeholder communication

Tools

Power BI

Salesforce

Job description

Scope

• Reporting & Data Analysis (primary function — approximately 60–65% of role) Pull, clean, and prepare data from Salesforce and other systems to produce regular program performance reports for internal teams and external stakeholders.


• Conduct analyses to answer questions on the organizational learning agenda, including participant outcomes, program completion, retention, and equity, disaggregating by race, gender, and other participant characteristics.


• Design and iterate on Power BI dashboards and Salesforce reports, determining what program questions each dashboard should answer, which indicators matter, and whether outputs accurately reflect program reality — working with the rest of the Evaluation and Impact team and Salesforce and Integration Administrator to implement technical changes as needed.


• Validate the accuracy and program relevance of real-time reporting infrastructure as it is built out, ensuring dashboards reflect the right indicators and are usable by program staff.


• Produce data briefs, one-pagers, and narrative summaries that translate analytical findings into accessible, decision-relevant language for non-technical audiences.


• Respond to ad hoc data requests from program, development, finance, and leadership teams with accuracy and timeliness.


• Conduct living wage analysis, marketing referral source analysis, and other recurring analytical projects as assigned.

Data Quality & Governance

• Run regular data quality audits by pulling and analyzing Salesforce data to identify errors, gaps, inconsistencies, and missing values — documenting findings and bringing issues to the Salesforce and Integration Administrator for system-level resolution.


• Contribute to data quality and quality assurance protocols by stress-testing reporting outputs, surfacing patterns of data entry error, recommending changes to data collection practices from an analytical standpoint, and iIdentify opportunities for improvement to current systems and operations.


• Own the analytical definition layer of data governance: develop and maintain data dictionaries, reporting definitions, and dataset documentation so that analytical outputs are reproducible, clearly sourced, and accessible to the broader team.


• Support encounters QA and monthly database review processes, focusing on whether data patterns make sense programmatically — flagging anomalies that may indicate data entry issues or process gaps.

Evidence-Building & Evaluation Support

• Support the refinement of outcome metrics and quality indicators by assessing whether proposed measures are analytically sound, measurable with available data, and aligned with JVS's Theory of Change — in coordination with the Evaluation and Impact team and the Salesforce and Integration Administrator.


• Contribute to the development and testing of lines of sight — measurable connections between program activities and participant outcomes — by analyzing existing data to test whether hypothesized relationships hold.


• Clean, structure, and document datasets for use by the Evaluation and Impact team in internal evaluations, external research partnerships, and funder reporting — working from raw exports prepared by the Salesforce and Integration Administrator.


• Support internal program outcome evaluation activities, including data preparation, analysis, and contributing to dissemination of findings (EBR Year 4, supporting role).


• Contribute to the organizational learning agenda by presenting data findings in program review meetings, staff learning sessions, and team check-ins.

Project Support (approximately 15–20% of role)

• Support dashboard review and revamp initiatives by assessing whether existing dashboards answer the right program questions, validating data source accuracy, and recommending content and design improvements — in coordination with the Salesforce and Integration Administrator who leads the technical build.


• Assist with retention data and dashboard validation, and support the retention survey revamp process.


• Contribute