Data Analyst

EVICTION DEFENSE COLLABORATIVE•San Francisco, CA

60d•$32 - $37•Hybrid

About The Position

The Data Analyst is a member of Eviction Defense Collaborative’s Data Division and supports the accuracy, completeness, timeliness, and reporting readiness of data entered by EDC programs and partner Legal Service Organizations (LSOs). The role reviews reports, identifies missing or inaccurate information, follows up with staff and partner organizations about corrections, and helps prepare monthly funder reporting submissions, including data prepared for upload to the City’s GMS portal. The Data Analyst collaborates with internal departments, including TRC, Litigation, RADCo, SCA, and future programs, and supports assigned partner LSOs. The position begins with established procedures and close supervision, with the expectation of developing greater independence, technical proficiency, and reporting knowledge over time. It helps maintain high-quality data for funder reporting, audits, organizational planning, and program operations. The analyst identifies recurring data-quality, reporting, timeliness, system, and process issues and escalates significant or ongoing concerns to the Data Supervisor. This is a union position represented by the National Organization of Legal Services Workers (NOLSW, UAW Local 2320, AFL-CIO), subject to the collective bargaining agreement. EDC places new union employees on its salary scale based on relevant work experience from the past nine years. The position is hybrid; employees may be able to work from home two regularly scheduled days per week after 30 days of employment, subject to supervisor consultation and approval. Staff must remain responsive during standard business hours. Some evening or weekend work may be required.

Requirements

Experience working with databases, spreadsheets, reports, case management systems, or other structured data sources.
Intermediate to advanced Microsoft Excel skills, including data management, formulas and functions, reporting, and analysis.
Strong attention to detail and ability to review large amounts of information for accuracy and completeness.
Ability to follow established procedures, use checklists, and meet recurring reporting deadlines.
Strong written and verbal communication skills, including professionally following up regarding missing or corrected information.
Ability to manage multiple priorities, track outstanding items, and escalate issues appropriately.
Ability to work independently and collaboratively in a team-oriented environment.
Ability to handle confidential information with discretion and care.
Strong data review, problem-solving, and investigative skills.
Strong organization, follow-through, and deadline-management skills.
Ability to learn Salesforce reports, filters, fields, and related data structures.
Ability to run existing reports and, over time, modify report filters, columns, and formats as needed.
Ability to identify recurring data-quality, timeliness, system, or process issues and communicate them clearly to the Data Supervisor.
Proficiency with Microsoft Office/Microsoft 365 and common computer programs.
Commitment to accuracy, confidentiality, collaboration, and continuous improvement.
Commitment to high-quality, client-centered services; empathy, professionalism, cultural competency, sound judgment, and a solutions-focused approach to problem-solving.
Remain responsive during standard business hours when working remotely.

Nice To Haves

Experience in a community-based nonprofit, legal services organization, government-funded program, social services environment, housing program, healthcare navigation program, education program, or other direct-service setting.
Experience supporting reporting, compliance, grants management, auditing, quality assurance, or data-quality initiatives.
Experience with Salesforce or a case management or customer relationship management database.
Experience importing data into CRM systems.
Experience preparing, modifying, and running reports for program operations, funder reporting, or compliance review.
Familiarity with documentation requirements, funder reporting, service delivery data, or collaborative partner reporting structures.

Responsibilities

Review assigned program and LSO reports for completeness, accuracy, consistency, and reporting readiness.
Monitor required MOHCD and funder data elements, including required data points, representation activities on open cases, and outcomes on closed cases.
Identify missing, incomplete, inaccurate, duplicate, or untimely records and document follow-up needs.
Communicate professionally with EDC staff and assigned LSOs about missing or corrected data.
Make approved data corrections directly when appropriate and within established guidelines.
Escalate unresolved, significant, or recurring data issues to the Data Supervisor.
Download, validate, and prepare monthly data extracts from partner LSOs and EDC programs for funder reporting.
Assist with preparing data for upload to GMS and other funder portal sites.
Check reports throughout the month so missing data can be addressed before submission deadlines.
Support audit preparation, contract monitoring, and funder reporting reviews by ensuring records are accurate and ready for upload.
Maintain tracking materials, checklists, and documentation related to reporting deadlines and correction follow-up.
Identify recurring data-quality issues, reporting deficiencies, and timeliness concerns across assigned programs and LSOs.
Flag Salesforce/JusticeServer fields, reports, workflows, or processes that appear to create confusion or repeated errors.
Identify staff or LSO training needs and communicate patterns to the Data Supervisor.
Recommend practical improvements to data collection, reporting workflows, and review procedures.
Assist with maintaining and improving written procedures, reporting checklists, and data-quality guidance materials.
Support TRC, Litigation, RADCo, SCA, and other EDC programs as assigned by the Data Supervisor.
Serve as a resource for basic reporting and data-quality questions from internal staff and assigned LSOs.
Participate in Data Division meetings, program check-ins, and cross-functional projects as needed.
Provide backup coverage for other Data Analysts and assigned programs/LSOs when needed.
Perform other duties as assigned that are consistent with the role and EDC’s mission.