City and County of San Francisco Looking for Senior HR Data Analyst – SFPUC Full Time

Company Description

• Application Opening: 04/24/2022
• Application Filing Deadline: 5/10/2022
• Annual Salary:
• Recruitment ID: RTF0121322-01118426 (121323)

The filing deadline for this position can close at anytime, but no sooner than May 3, 2022.

APPOINTMENT TYPE: Permanent Exempt (PEX): 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?

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 .

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

Job Description

Project: Hiring Tracker Dashboard – Data Integration & Development

Under the direction of the HR Tech Solutions Manager, the Sr. HR Data Analyst will be a member of the HR Tech Solutions Team, integral to data integration and development of the Hiring Tracker Dashboard for SFPUC Human Resource Services. This position will play a role in elevating SFPUC Human Resource Services (HRS) as a leader in innovative HR practices to prepare for changes now and in the future while bringing the best outcome for our customers

Essential Functions: * Serve as lead Project Manager for the entire implementation cycle of the Hiring Tracker Dashboard; act as key liaison between ITS and the department stakeholders.

• Conduct complex research/analyses and participate in meetings with subject matter experts to capture data needs and reporting requirements while noting gaps and inefficiencies;
• Design advanced data queries/data models/dashboards based on customers’ needs, which may require developing the right algorithm to extract/connect information from several different HR information systems;
• Conduct complex workforce data audits between external and internal HR information systems including Oracle PeopleSoft, SFPUC’s internal position control system, SmartRecruiters using Business intelligence tools such as PowerBI, Visier People, Cognos, and MS Office Suite to ensure accuracy of dashboard data;
• Collaborate with ITS and department subject matter experts to troubleshoot data anomalies;
• Ensure that all milestones and deliverables are met in the agreed upon timeline within the project plan;
• Ensure proper documentation of the Hiring Tracker Dashboard requirements is developed to enable ongoing maintenance/support

The 1823 Senior Administrative Analyst may perform other related duties as assigned.

Qualifications

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

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 two (2) years full-time equivalent experience performing professional level analytical work as described in Note A; OR

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

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

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.

Notes on Qualifying Experience and Education:

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.

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.

Applicants must meet the minimum qualification requirement by the final filing date unless otherwise noted.

Desirable Qualifications

• Experience in Project Management
• Experience using PowerBi to create compelling and informative data visualizations
• Experience integrating multiple data sources

The stated desirable qualifications may be used to identify job finalists at the end of the selection process when candidates are referred for hiring.

Verification of Education and Experience:

Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and selection process. If education verification is required, information on how to verify education requirements, including verifying foreign education credits or degree equivalency, can be found at https://sfdhr.org/how-verify-education-requirements

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.

Resumes will not be accepted in lieu of a completed City and County of San Francisco application.

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:

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 kept up-to-date. 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 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, Linda Muir, by email at [email protected].

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

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.

City and County of San Francisco