Data Analyst
JVS - Bay Area · San Francisco, CA · 5 days ago
HybridAnalyst$88k/yrFull-time
Qualifications
- Bachelor’s degree in public policy, sociology, data science, economics, social work, or a related field; or equivalent combination of education and directly relevant experience.
- Minimum 4–5 years of professional experience in data analysis, reporting, or performance measurement, with demonstrated ability to work with complex datasets and produce high-quality outputs independently.
- Experience pulling, cleaning, and analyzing data from a CRM or database system, preferably Salesforce; advanced Excel skills for data cleaning, analysis, and reporting required.
- Experience with data documentation practices, including data dictionaries, reporting definitions, and data quality audit processes.
- Experience designing and iterating on dashboards and reports in Power BI or equivalent BI tool, with a focus on making data accessible and actionable for non-technical users.
- Experience using AI-assisted tools (such as Microsoft Copilot or similar technologies) to improve productivity, documentation, analysis, or reporting workflows.
- Strong analytical and critical-thinking skills, with genuine curiosity about what program data reveals and what it may obscure.
- Ability to understand how program workflows, operational processes, reporting requirements, and participant experiences connect across systems.
- Excellent attention to detail and strong data documentation habits; ability to manage multiple reporting cycles, ad hoc requests, and project deadlines simultaneously.
- Demonstrated ability to independently investigate problems and move work forward.
- Clear written and verbal communication skills; collaborative working style.
- Commitment to equity and interest in analyzing data through an equity lens, including disaggregating outcomes by participant demographics.
- Alignment with JVS's mission of equitable economic mobility and commitment to the communities JVS serves.
Scope
- Reporting & Data Analysis (primary function — approximately 60–65% of role)
- 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 identify 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
- 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.
- Affiliate with retention data and dashboard validation, and support the retention survey revamp process.
- Contribute to data source inventory and governance review, helping ensure the team has a clear picture of what data exists, where it lives, and how it is used analytically.
- Contribute to the PDSA process by preparing data summaries that support iterative program improvement cycles.