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 requi