Data & Reporting Analyst

What you’ll do Under the guidance of the Director of Data and Reporting, the Data Analyst is responsible for the generation, quality assurance, and distribution of internal and external reports in support of grants management, program evaluation, and organizational learning. This role works closely with the Director of Data and Research and the Public Funding and Institutional Giving teams to ensure accurate, timely, and funder‑compliant data reporting. The Analyst plays a key role in maintaining data quality within the organization’s client data management system and contributes to dashboard development and data collection processes that reflect the needs of youth‑serving programs. This is a full‑time position, eligible for full benefits. Grant & Funder Reporting Generate monthly, quarterly, bi‑annual, and annual reports for Public Funding and Institutional Giving departments in support of grants management and invoicing. Coordinate the timely and accurate submission of data into external funder database systems, ensuring compliance with all reporting requirements. Attend regular funder‑hosted meetings and maintain consistent communication cadence with the Public Funding team (bi‑weekly) and Institutional Giving (monthly). Respond to additional data requests from across the agency in a timely manner. Produce and distribute recurring internal reports for program and performance management, outcomes measurement, and quality assurance purposes. Support the build‑out and ongoing maintenance of program‑facing dashboards in Power BI, Tableau, or similar visualization platforms. Manage access to and organization of reports within the client data management systems. Conduct ongoing quality assurance and quality control activities across and between internal and external databases, flagging and resolving discrepancies. Support revisions to the client data management system as required by evolving programmatic or reporting needs. Data Analysis Write and maintain code in R or other statistical software to support data extraction, transformation, and reporting processes. Perform quantitative review of data collection forms, assessments, and other instruments for completeness and accuracy. Support data cleaning and preparation for use in program evaluation and research activities. Maintain up‑to‑date knowledge of new features and functionalities in relevant software platforms. Other Duties & Responsibilities Support the Director of Data and Research in implementing system revisions as required by evolving programmatic or reporting needs. Support the team’s mixed‑methods research efforts, assisting with deliverables such as white papers and policy briefs and with analyses spanning a range of methods (spatial panel regression, social network analysis, cost‑benefit analysis). As needed, help advance the organization’s Learning Agenda and Equity Agenda, analyzing underserved populations and incorporating those learnings into actionable programmatic steps. Other duties as assigned. Qualifications Proficiency in R is required, including data wrangling, transformation, and reporting packages (tidyverse, ggplot2, RMarkdown or Quarto); Python proficiency is also acceptable. Experience with Power BI, Tableau, or similar data visualization platforms. Experience working with large‑scale cloud‑based data repositories and enterprise data management systems. Strong cleaning, validation, and preparation skills for reporting and analysis, with high attention to accuracy across multiple systems. Analytical, collaborative problem‑solver who is detail oriented, self‑starter, and an excellent communicator. Will work 3 days per week in the San Francisco office. Perks $70,500 to $75,000 annual salary. Clipper Bay Pass – Commute for FREE! Choice of Kaiser and Sutter medical plans, plus dental and vision. Generous 3 weeks of vacation annually, plus 11 paid holidays and 3 floating holidays. 403(b) retirement plan with employer matching. Flexible spending accounts for healthcare and dependent care expenses. Life insurance. Employee Assistance Program for counseling services. Health Advocate Service. Paid sabbatical following 5 and 10 years of employment. Larkin Street Youth Services is an equal opportunity employer. Larkin Street Youth Services seeks qualified candidates with an interest in the non‑profit sector. We are committed to embracing diversity and consider all applicants for all positions without regard to color, ethnic background, religion, sex, gender, gender identity, sexual orientation, national origin, age, disability, HIV/AIDS status, veteran status, or any other legally protected class. We encourage applicants of diverse backgrounds to apply for any open position in which they feel qualified. Pursuant to the San Francisco Fair Chance Ordinance, we will consider employment for qualified applicants with arrest and conviction records. All City and County of San Francisco employees are required to be vaccinated against COVID‑19 as a condition of employment. #J-18808-Ljbffr