Data Analyst

What You'll Do

• Generate monthly, quarterly, bi-annual, and annual reports for Public Funding and Institutional Giving departments in support of grants management and invoicing.
• Carefully 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.
• 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 (e.g., spatial panel regression, social network analysis, cost-benefit analysis).
• As needed, help advance the organization's Learning Agenda (internal evaluation, monitoring, and goal-setting) and Equity Agenda (analyzing underserved populations and incorporating those learnings into actionable programmatic steps).

Who You Are

• Your proficiency in R is required, including data wrangling, transformation, and reporting packages (tidyverse, ggplot2, R Markdown or Quarto)/Python proficiency also acceptable.
• You have experience with Power BI, Tableau, or similar data visualization platforms.
• You have worked with large-scale cloud-based data repositories and enterprise data management systems.
• You have a knack for cleaning, validating, and preparing datasets for reporting and analysis with high attention to accuracy, including resolving data quality issues across multiple systems.
• You are an analytical and collaborative problem solver. Your colleagues describe you as detail oriented, self-starter, and an excellent communicator.
• You work best in a hybrid working environment. This role will work 2-3 days per week in the San Francisco Office.

The 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 (EAP) for counseling services.
• Paid Sabbatical following 5 and 10 years of employment.