About the Role
The Data Analyst supports the accuracy, completeness, timeliness, and reporting readiness of data entered by EDC programs and partner Legal Service Organizations (LSOs). This role reviews reports, identifies data issues, follows up on corrections, and assists with monthly funder reporting submissions, including data for the City's GMS portal. The position is designed to foster increasing independence and technical proficiency over time, maintaining high-quality data for funder reporting, audits, and organizational planning.
Responsibilities
- Review assigned program and LSO reports for completeness, accuracy, consistency, and reporting readiness.
- Monitor required MOHCD and funder data elements, including 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 regarding 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 preparation of data for upload to GMS and other funder portal sites.
- Check reports throughout the month so that missing data can be addressed before submission deadlines.
- Support audit preparation, contract monitoring, and funder reporting reviews by ensuring records are accurate and upload ready.
- 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.
Requirements
- Experience working with databases, spreadsheets, reports, case management systems, or other structured data sources.
- Intermediate to advanced Microsoft Excel skills (data management, formulas & functions, reporting and analysis and others).
- 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 the ability to follow up professionally 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.
- 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, case management or customer relationship management database.
- Experience with 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.
- 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.
- Prolonged sitting/standing.
- Extensive typing and data entry.
- Close visual acuity for reviewing documents, data, and reports.
- Prolonged computer use.
Skills
- Microsoft Excel
- Data management
- Formulas & functions
- Reporting
- Analysis
- Attention to detail
- Written communication
- Verbal communication
- Problem-solving
- Organization
- Follow-through
- Deadline management
- Salesforce
- Microsoft Office/Microsoft 365
Location
- San Francisco
Work Type
- Hybrid
Experience Level
- Intermediate
- Advanced
Salary/Compensations
- $32.42 - $37.47 per hour
About the Company
- Eviction Defense Collaborative (EDC) works to prevent homelessness before it starts by providing compassionate, high‑quality legal assistance, rental assistance, and supportive services to San Francisco tenants facing eviction or housing instability.
- We believe that housing is a human right, and we strive to ensure that every San Franciscan has meaningful access to justice and the resources needed to remain safely housed.
- EDC staff are represented by the National Organization of Legal Services Workers (NOLSW, UAW Local 2320, AFL‑CIO). This position is a union position and is subject to the terms of the collective bargaining agreement.
- EDC uses a step system for all union employees. New employees are placed on the salary scale based on relevant work experience from the past nine years. Please include all relevant experience in your application and resume so EDC can determine your appropriate salary step.
Equal Opportunity
- EDC is an equal opportunity employer committed to building an inclusive and respectful workplace. Employment decisions are based on organizational needs, job requirements, and individual qualifications without regard to protected characteristics. Discrimination or harassment of any kind is not tolerated.
