Social Impact Partnership Data and Systems Manager, 1823 Senior Administrative Analyst: SFPUC, External Affairs, Community Benefits Division (Class #1823) TEX

Career Opportunity

Social Impact Partnership Data and Systems Manager, 1823 Senior Administrative Analyst: SFPUC, External Affairs, Community Benefits Division (Class #1823) TEX

Recruitment: RTF0124539-01151613

Published: September 20, 2022

Contact

Arlena Winn - arlena.winn@sfdpw.org

Apply using SmartRecruiters, the City and County of San Francisco's application portal.

Department: Public Utilities Commission
Job class: 1823-Senior Administrative Analyst
Salary range: $123,656.00 - $150,280.00
Role type: Temporary Exempt What does this mean?
Hours: Full-time

About:

Are you interested in gaining valuable experience in city government, working for a public utilities agency? Does working with the community, using your programmatic and analytical skills in your daily work appeal to you? If you answered yes to either question, keep reading to find out more about this great career opportunity.
--------------------------------------------------------------------------------
Snap Shot of the Job

Job Ad Opening: Tuesday, September 06, 2022
Job Ad Closing: No earlier than Friday, September 23, 2022

Fill Type: Temporary Exempt ("At Will")
Duration: Project Based- not to exceed 36 months (3 years)
Time Commitment: Full-Time
Work Schedule: Regular
Salary: 1823 Salary Grade $110,630 to $134,446 Annually
Recruiter: Arlena Winn, awinn@sfwater.org
Job Description: See Below

--------------------------------------------------------------------------------

WHO WE ARE

We are the 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.

More About SFPUC:
We are an award-winning and industry-leading utilities organization committed to our customers, community interests, and the environment. 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. As you explore career opportunities with us, download our career guide and learn about what you can expect during the hiring process.

We Are An Equal Employment Opportunity Employer:
The City and County of San Francisco, "the City" 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.

Diversity, Equity, and Inclusion:
The City's Department of Human Resources (DHR) is committed to providing a diverse, equitable, inclusive, and belonging environment for the City and County of San Francisco , where all employees and prospective employees experience fairness, dignity, and respect. DHR’s mission is to use fair and equitable practices to hire, develop, support, and retain a highly-qualified workforce. The resources support and expand on the Mayor’s Executive Directive 18-02, "Ensuring a Diverse, Fair, and Inclusive City Workplace."

--------------------------------------------------------------------------------

Role description

About the Community Benefits Division
The Community Benefits Division of External Affairs develops the strategic frameworks for Agency-wide community benefits and environmental justice programs and activities, partners with community-based stakeholders and other CCSF agencies, manages pilot programs, and evaluates community outcomes related to investments and partnerships.

POSITION SUMMARY
Under the direction of the Community Benefits Director and in partnership and coordination with the Social Impact Partnership Manager, the 1823 Sr. 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.

Social Impact Partnership Program Overview:
Guided by SFPUC’s Environment Justice, Community Benefits, and Racial Justice policies, the SFPUC is committed to being a good neighbor to all who live or are directly affected by its activities and investments. For the past decade, through the Social Impact Partnership Program (SIP), the SFPUC has invited firms with shared values and a commitment to social responsibility to invest and build stronger partnerships throughout the City and SFPUC service regions, resulting in healthier and more vibrant communities.

Since 2011, our SIP partners—professional services and construction management firms in fields such as engineering, architecture, resource management, and power providers – have been making commitments to local communities, through direct financial contributions and volunteer work to local nonprofits and educational organizations. By including SIP criteria in the contracting process, we provide firms with a voluntary opportunity during the solicitation process to demonstrate social responsibility commitment with positive impacts in local communities.

Major, Important and Essential Duties:

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.

Performs other duties as assigned per the 1823 Senior Administrative Analyst job specifications.

Desirable Skill & Achievements:

Advanced skills in word-processing, Excel, databases (e.g. Salesforce), Internet, e-mail, reporting tools (e.g. Power B.I.) and various complex spreadsheet software
Knowledgeable of City and County of San Francisco contracting process
Familiarity with SF communities and neighborhoods, particularly those adjacent to SFPUC operations
Well versed in administrative and management best practices and frameworks
Working knowledge of principles of racial equity, environmental justice, and community benefits
Values collaborative teamwork and able to work independently
Ability to take initiative, a self-starter and ability to take direction
Ability to adapt easily and quickly to new circumstances as they arise
Excellent organizational skills; task and detailed oriented
Ability to meet deadlines in a fast-paced environment
Recognize value in diversity of work styles
Excellent oral and written skills

--------------------------------------------------------------------------------

How to qualify

If you are interested in a job like this, we are looking for people that have the following minimum qualifications: Applicants must meet the minimum qualification requirements by the Job Ad final closing date unless otherwise noted.

Qualify By:

1. Possession of a graduate degree (Master's degree or higher) from an accredited college or university and 3 years of full-time equivalent experience performing professional level analytical work as described in Note A:

2. Possession of a graduate degree (Master's degree or higher) from an accredited college or university with major college coursework as described in Note B and 2 years full-time equivalent experience performing professional level analytical work as described in Note A;

3. Possession of a baccalaureate degree from an accredited college or university and 4 years full-time equivalent experience performing professional level analytical work as described in Note A;

4. Possession of a baccalaureate degree from an accredited college or university with major college coursework as described in Note B and 3 years full-time equivalent performing professional level analytical work as described in Note A

Notes on Qualifying Experience and Education:

Note A. Qualifying professional-level analytical experience must be in one or more of the following functional areas: complex budget analysis, development and administration; complex financial/fiscal analysis and reporting; development of complex contracting systems and administration of competitive bid processes and complex contractual agreements; development and evaluation of complex management/administrative policy; complex grant administration and monitoring; complex program evaluation and planning; complex legislative analysis; complex economic analysis; or other functional areas related to the duties of positions in Class 1823, where the primary focus of the job is complex professional-level analysis for evaluation, recommendation, development and implementation of major programs and functions of department/organization. Analytical experience equivalent to the duties of Class 1822 is considered qualifying.

Note B. Coursework applicable to a baccalaureate or higher degree 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 Class 1823.

SUBSTITUTION: Applicants may substitute up to 2 years of the required education with additional qualifying experience in budget analysis, financial analysis and reporting, legislative/policy analysis, or contract/grant administration. One year (2000 hours) of additional qualifying experience will be considered equivalent to 30 semester units/45 quarter units.

VERIFICATION: Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and selection process. More information on how to verify experience and education can be found here: verifyignhttp://sfdhr.org/how-verify-education-requirements.

City employees will receive credit for the duties of the class to which they are appointed. Credit for experience obtained outside of the employee’s class will be allowed only if recorded in accordance with the provisions of the Civil Service Commission Rules.

Experience claimed in self-employment must be supported by documents verifying income, earnings, business license and experience comparable to the minimum qualifications of the position. Copies of income tax papers or other documents listing occupations must be submitted.

Note: Falsifying one’s education, training, or work Note: 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

--------------------------------------------------------------------------------

What else should I know?

Questions????
Contact the assigned Recruiter, Arlena via email: awinn@sfwater.org.

Confidentiality Note:
All your information will be kept confidential according to EEO guidelines.

Selection Procedure:
Only those candidates who most closely meet the needs of the Department will be invited to continue in the selection process. Applicants who meet the minimum qualifications are not guaranteed to advance through all the steps in the selection process.

AW, 09.06.2022| TEX-1823-124745 | 01151613

--------------------------------------------------------------------------------

Want to Know More About working for the City?
Browse the following links

CONDITION OF EMPLOYMENT: All City and County of San Francisco employees are required to be fully vaccinated against COVID-19 as a condition of employment. Someone is fully vaccinated when 14 days have passed since they received the final dose of a two-shot vaccine or a dose of a one-shot vaccine. Any new hire must present proof of full vaccination status to be appointed. Any new hire who will be routinely assigned or occasionally enter High-Risk Settings, must provide proof of having received a COVID-19 booster vaccine by March 1, 2022, or once eligible.

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.