Impact Associate (24 hours/week)

Compass Sf; San Francisco (CA); Hybrid; USD 48,216 - 50,971; Part time

Benefits offered by this job

Health insurance

Paid time off

Retirement contributions

Union membership

Job summary

Compass Sf is seeking an Impact Associate in San Francisco. This part-time position involves managing Salesforce reporting requests, training new staff on Salesforce, and supporting program staff with diverse reporting needs.

The ideal candidate will have Salesforce experience, proficiency in Excel, and strong analytical skills. Flexible hours are offered, with a hybrid work model requiring some on-site presence.

Qualifications

• At least one year of experience building complex reports in Salesforce or two years in another database.
• Salesforce Administrator certificate is preferred but not required.
• Ability to manipulate data and create visuals in Excel.
• Ability to communicate well across various levels in an organization.

Responsibilities

• Manage Salesforce reporting requests and ensure accuracy.
• Train new staff on Salesforce usage.
• Respond to Salesforce help desk tickets.
• Create and analyze reports as required.

Skills

Building complex reports in Salesforce

Proficiency in Excel

Analytical skills

Strong communication skills

Attention to detail

Ability to manage multiple projects

Tools

Salesforce

Excel

Job description

Compensation: $35 - $37 per hour plus full benefits

Schedule: Part time, 24 hours per week. Flexible hours between Mon-Fri, 9 am-5 pm

Location: 37 Grove St., San Francisco

Position Overview

The Impact Associate is responsible for fulfilling Salesforce reporting requests for all Compass programs, training new program staff on Salesforce, responding to Salesforce tickets, and working on special projects. Working closely with the Assistant Director of Impact and Learning, Senior Salesforce Administrator and program staff, this is a highly collaborative position requiring discipline and keen attention to detail to manage multiple projects simultaneously.

Responsibilities

Compass Reporting Needs

• Manage reporting requests, including building new reports, editing and ensuring accuracy of existing reports and formulas, and working with program and development staff to meet their reporting needs
• Pull data for the quarterly data meeting
• Stay up to date on how programs are using the database in order to create and analyze reports correctly
• Pull weekly, monthly, and quarterly reports for funders, clean and transform data, and upload into funder databases
• Familiarize with external funder databases to support programs in meeting their reporting requirements

Salesforce Support

• Train all new program hires on using the Salesforce database
• Respond to Salesforce Compass help desk tickets
• Build custom fields and objects for program use
• Support Salesforce app usage (i.e., Adobe Sign, Apsona)
• Document processes to support training purposes
• Support the team through needs which may include one-off special projects

Qualifications

• At least one year of experience building complex reports in Salesforce OR two years’ experience building reports in another database.
• Salesforce Administrator certificate preferred but not required
• Ability to manipulate data, produce summary statistics, and create visuals in excel (e.g., averages, percentages, trend lines, distributions)
• Proficiency in Excel with pivot tables, VLOOKUP/ XLOOKUP, basic formulas)
• Ability to identify, investigate, and resolve data discrepancies or anomalies in reports
• Ability to communicate well across various levels in an organization and work collaboratively with people with a varying range of technical competencies
• Strong analytical skills, customer-service orientation, and ability to juggle multiple projects simultaneously
• Impeccable attention to detail
• Ability to thrive in a fast-changing, multi-program environment
• An excitement about technology and its ability to positively impact the organization
• Demonstrated commitment to diversity, equity, inclusion and belonging work
• Passion for the mission of Compass Family Services

Compensation and Benefits

• Salary: $35 - $37 per hour, 24 hours per week
• Paid time off: 4 weeks of vacation your first year, 5 in your second. Also paid holidays, sick time, family leave.
• Insurance: health, dental and vision insurance are fully covered by Compass for employees and dependent children. We also provide long term disability and life insurance.
• Retirement: after one year of work, Compass contributes an amount equal to 5% of your salary into a retirement account; this vests during years 2-6.
• Membership in OPEIU/Local 29 union.

Additional Details

• Office location: 37 Grove St., San Francisco, less than a block from Civic Center BART/MUNI station.
• This is a hybrid role, with 1-2 on-site days required each week (more during training period). Fully remote is not possible.

Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records. We are an equal opportunity employer and actively seek to recruit a diverse workforce. Employees must embrace the idea that Diversity, Equity, Inclusion, and Belonging contribute to the success of our underserved communities, and therefore to shared prosperity in our city and region. Compass Family Services is committed to the continuous work of implementing specific actions that will disrupt systemic prejudice and improve equity across programs and departments, to become an example to partners who also believe in a culture of inclusion that leverages diversity.

Consistent with the Americans with Disabilities Act and California civil rights law, Compass Family Services will provide reasonable accommodation when requested by a qualified applicant or candidate with a disability, unless such accommodation would cause an undue hardship for the agency. Requests for reasonable accommodation apply to all aspects of the hiring process. If reasonable accommodation is needed, please use the answer box for the final question of the job application to let us know.