Social Impact Partnership Data and Systems Manager - External Affairs Division – San Francisco Public Utilities Commission (1824)– (155666)

Company Description

• Application Opening: 03/19/2025
• Application Filing Deadline: 04/01/2025
• Annual Salary:   $138,268 to $168,090
• Recruitment ID:  RTF0155665-01156904 (155666)

APPOINTMENT TYPE: Temporary Exempt: This position is excluded by the Charter from the competitive Civil Service examination process and shall serve at the discretion of the Appointing Officer.

The duration of the appointment shall not exceed 36 months.

WHO ARE WE?
San Francisco Public Utilities Commission (SFPUC)
Headquartered in San Francisco, we have 2,300 employees operating across eight counties serving more than 2.7 million customers in the San Francisco Bay Area – 24 hours per day, 365 days per year.

Our Mission: To provide our customers with high quality, efficient, and reliable water, power, and wastewater services in a manner that values environmental and community interests and sustains the resources entrusted to our care.

Our Vision: We are an innovative utility leader, recognized for excellent results in service, safety, stewardship, and inclusiveness.

We are an award-winning and industry-leading utilities organization committed to our customers, community interests, and the environment. To learn more about our organization, please visit our website at https://www.sfpuc.gov.

We are proud of our infrastructure and programs, but most importantly, we value our highly qualified and dedicated workforce which ensures that this vision becomes a reality.

To learn more about working at the SFPUC, visit our career site at https://www.sfpuc.gov/about-us/careers-sfpuc

Job Description

Under the direction of the Community Benefits Director and in partnership and coordination with the Social Impact Partnership Manager, the 1824 Principal Administrative Analyst – Social Impact Partnership Data and Systems Manager will support the SFPUC’s commitment to partnering with SFPUC’s private contractor firms, community-based organizations, and educational institutions to achieve measurable, quantifiable, and positive outcomes to the community or communities impacted by capital projects within the SFPUC' service area. The Social Impact Partnership (SIP) Program oversees Social Impact Commitments made by SFPUC contractors to ensure accurate alignment, execution, implementation, and reporting of SIP commitments. This position is responsible for supporting the Social Impact Partnership Program in database management, data analysis, quality assurance and quality control (QA/QC), preparation of contract solicitations, contract compliance with reporting requirements, system improvements, and other as-needed responsibilities.

Project name: Social Impact Partnership Program Data and Systems Interface Optimization

Essential Functions:

Systems & Data Management

• Manage internal systems, databases, and records for the Social Impact Partnership (SIP) program by utilizing various platforms, including SharePoint, Salesforce, Power Bi, SOLIS, and other platforms as necessary

• Support data collaborations and record retention with inter- and intra-agency departments and integrate SIP criteria into the agency's contracting process

• Collect and verify data from contractors, and validate program data for accuracy and completeness (quality control)

• Ensure efficient and accurate organization and entry of validated program data into databases in collaboration with the SIP manager, other SFPUC staff, and consultants

• Conduct complex data analysis, develop data visualizations, and manage complex multi-stakeholder data projects to provide the quantitative compliment to the program’s qualitative impact

• Structure large data sets into usable program information and prepare reports for internal and external stakeholders

• Ensure compliance with standard data governance practices

• Ensure the effective maintenance and optimization of data platform applications, ensuring system administration, training, support, and reporting for users

Contract Management

• Support the SIP program by monitoring active and upcoming contracts and SIP commitment delivery, and ensure contract compliance through implementing critical processes, tasks, and metrics

• Support with the inclusion of SIP into the contracting process, including RFP development, the evaluation process, and more

• Monitor and enforce contractor compliance with the SIP program's reporting requirements, while ensuring the appropriate prioritization, categorization and processing of contracts submitted through the City’s contract workflow.

• Support the SIP program by driving continuous data process improvement by collaborating with stakeholders on design of new solutions that enhance business performances and achieve established goals.

• Partner with SIP Manager to develop and implement system improvements to streamline monitoring and reporting of upcoming contracts and contracts in progress.

Programmatic Support

• Provide and maintain an exceptionally high-level of professionalism when engaging with program stakeholders, including department personnel and external stakeholders

• Ensure compliance of SIP program standards and support the program management life cycle

• Perform research as needed to support programmatic best practices.

• Assist SIP team members to establish a consistent level of quality, accuracy, and compliance with program standards and internal controls by reviewing and updating current processes, templates, and procedures to incorporate leading practices and adapt to changing business practices and requirements.

• Conduct project status reviews by tracking performance deliverables, preparing regular status reports for various audiences and presenting the information to stakeholders.

• May supervise a small staff performing moderately complex analytical work.

Class 1824 Principal Administrative Analyst performs other related duties as required.

Qualifications

These minimum qualifications establish the education, training, experience, special skills and/or license(s) which are required for employment in the classification. Please note, additional qualifications (i.e. special conditions) may apply to a particular position and will be stated on the job ad.

1. Possession of a baccalaureate degree from an accredited college or university, AND
2. Five (5) years full-time equivalent experience performing professional-level analytical work. Qualifying professional-level analytical work includes analysis, development, administration, and reporting in major programs and functions of an organization in the areas of budgets, contracts, grants, policy, or other functional areas related to the duties of positions in the 182X Class series.

Substitution:

Possession of a graduate degree (Master's degree or higher) from an accredited college or university with major coursework in specialized subject matter areas such as public or business administration, management, business law, contract law, public policy, urban studies, economics, statistical analysis, finance, accounting or other fields of study closely related to the essential functions of positions in the Class series may be substituted for one (1) year of required experience.

Additional experience as described above may be substituted for the required degree on a year-for-year basis (up to a maximum of 2 years). Thirty (30) semester units or forty-five (45) quarter units equal one year.

One year of full-time employment is equivalent to 2000 hours. (2000 hours of qualifying work experience is based on a 40-hour work week.) Any overtime hours that you work above forty (40) hours per week are not included in the calculation to determine full-time employment.  

Verification of Education and Experience:

Every application is reviewed to ensure that you meet the minimum qualifications as listed in the job ad. Please review our articles on Employment Application and Minimum Qualifications and Verification of Experience and/or Education for considerations taken when reviewing applications. 

Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and selection process.

Note: Falsifying one’s education, training, or work experience or attempted deception on the application may result in disqualification for this and future job opportunities with the City and County of San Francisco.

All work experience, education, training and other information substantiating how you meet the minimum qualifications must be included on your application by the filing deadline. Information submitted after the filing deadline will not be considered in determining whether you meet the minimum qualifications. Applications completed improperly may be cause for ineligibility, disqualification or may lead to lower scores.

Additional Information

Additional Information Regarding Employment with the City and County of San Francisco:

• Information About the Hiring Process
• Conviction History
• Employee Benefits Overview  
• Equal Employment Opportunity 
• Disaster Service Worker
• ADA Accommodation
• Veterans Preference
• Right to Work
• Copies of Application Documents
• Diversity Statement

Applicants will receive a confirmation email from notification@careers.sf.gov that their online application has been received in response to every announcement for which they file. Applicants should retain this confirmation email for their records. Failure to receive this email means that the online application was not submitted or received.

HOW TO APPLY

Applications for City and County of San Francisco jobs are only accepted through an online process. Visit https://careers.smartrecruiters.com/CityAndCountyOfSanFrancisco1/ and begin the application process.

• Select the “I’m Interested” button and follow instructions on the screen

Applicants may be contacted by email about this recruitment and, therefore, it is their responsibility to ensure that their registered email address is accurate and updated. Also, applicants must ensure that email from CCSF is not blocked on their computer by a spam filter. To prevent blocking, applicants should set up their email to accept CCSF mail from the following addresses (@sfgov.org, @sfdpw.org, @sfport.com, @flysfo.com, @sfwater.org, @sfdph.org, @asianart.org, @sfmta.com, @sfpl.org, @dcyf.org, @first5sf.org, @famsf.org, @ccsf.edu, @smartalerts.info, and @smartrecruiters.com).

Applicants will receive a confirmation email from notification@careers.sf.gov that their online application has been received in response to every announcement for which they file. Applicants should retain this confirmation email for their records. Failure to receive this email means that the online application was not submitted or received.

Job Analyst Information: If you have any questions regarding this recruitment or application process, please contact the job analyst, Alexeh Alfajora at AAlfajora@sfwater.org.

The City and County of San Francisco encourages women, minorities and persons with disabilities to apply. Applicants will be considered regardless of their sex, race, age, religion, color, national origin, ancestry, physical disability, mental disability, medical condition (associated with cancer, a history of cancer, or genetic characteristics), HIV/AIDS status, genetic information, marital status, sexual orientation, gender, gender identity, gender expression, military and veteran status, or other protected category under the law.