Social Impact Partnership Data and Systems Manager - External Affairs Division San Francisco Public Utilities Commission

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 SFPUCs commitment to partnering with SFPUCs private contractor firms communitybased 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 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 asneeded 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 intraagency departments and integrate SIP criteria into the agencys 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 multistakeholder data projects to provide the quantitative compliment to the programs 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 programs reporting requirements while ensuring the appropriate prioritization categorization and processing of contracts submitted through the Citys 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 highlevel 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 fulltime equivalent experience performing professionallevel analytical work. Qualifying professionallevel 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 (Masters 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 yearforyear basis (up to a maximum of 2 years). Thirty 30 semester units or fortyfive 45 quarter units equal one year.

One year of fulltime employment is equivalent to 2000 hours. 2000 hours of qualifying work experience is based on a 40hour work week. Any overtime hours that you work above forty 40 hours per week are not included in the calculation to determine fulltime 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 ones 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.

• 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 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 and begin the application process.

• Select the Im 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 @sfdpw @sfport @flysfo @sfwater @sfdph @asianart @sfmta @sfpl @dcyf @first5sf @famsf @ccsf @smartalerts and @smartrecruiters).

Applicants will receive a confirmation email from 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

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.