Senior Peoplesoft HRMS Programmer Analyst – SFPD (1063) - City and County of San Francisco

Who We Are: The San Francisco Police Department was established in 1849 and continually strives to become a more effective. inclusive and modern police department. while earning the trust and pride of those we serve and those who serve. Our goal is to reflect on current SFPD initiatives. assess best practices across the country and evaluate the changing environment in policing and within the City to arrive at a strategy statement that the Department and our community can embody every day. The San Francisco Police Department stands for Safety and Respect for All. We will engage in transparent unbiased and responsive policing. We will do so in the spirit of dignity and in collaboration with the community. And we will maintain and build trust and respect as the guardians of Constitutional and human rights. The San Francisco Police Department is committed to excellence in law enforcement and is dedicated to the people. traditions and diversity of our City. The department provides a service with understanding, response with compassion, performance with integrity and law enforcement with vision. The department has grown into a nationally known police department providing law enforcement services to one of the most recognized cities in the United States.

• Application Opening: April 12, 2024
• Application Deadline: Apply immediately, announcement may close anytime after 2 weeks from posting date.
• Class & Compensation: $117,156 - $147,472
• Appointment Type: Permanent 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.
• Work Location: SFPD Headquarters, 1245 3rd Street, San Francisco, CA 94158
• Work Schedule: Monday - Friday, Full-time, Hybrid Telecommuting work schedule available in line with CCSF policy.

The San Francisco Police Department (SFPD) is seeking a proficient Senior Peoplesoft HRMS Programmer Analyst to analyze, design, develop, test, and implement solutions related to PeopleSoft HRMS that has been highly customized to meet the needs of SFPD.

Essential Duties: 

• Plan, develop, test, analyze, code, debug, implement and document to provide support on PeopleSoft HRMS and associated interfaces.
• Programming with SQL that includes complex SQL extracts. Create scripts to create tables, views, sequences, and triggers.
• Analyze, design, develop, and test BI Publisher reports specific to PeopleSoft HRMS. Create processes to add, delete, update data as well as create reports using PL/SQL. Utilize SQR (Structured Query Report).
• Conduct feasibility analyses and implement findings in a customized environment.
• Administer HRMS Scheduling Module, Payroll Interface, Workforce Administration, Self Service, Time and Labor, Enterprise Learning, Query Manager, Security Tree Manager, row level security, Portal Structure and Content, and Application Engine. Duties include recurrence setup of recurring nightly jobs, development of process run control parameter screens, and utilization of periodic compare and cleanup tools.
• Maintains, troubleshoots, and supports HRMS as well as associated interfaces.
• Research and programs Time and Labor Calendar Table, holiday schedules, salary grades, and pay steps for every job classification into HRMS.
• Ensures all requirements of pay period closing are met.
• Develops, implements, and maintains the following: 
  • data structures for reports and statistical analysis.
  • operational and system level documentation.
  • reports using various standard reporting tools.
• Stays current with technology changes and stays abreast of law enforcement operations that influence technology solutions.
• Analyzes, researches, implements, and tests new technologies and attains sufficient expertise to apply it successfully in the workplace.
• Collaborates with colleagues and users to determine program and system requirements, documenting those requirements, analyzing data processing needs, determine security profiles, implementation and testing, conversion to production status, technical documentation, post Go-Live stabilization, and troubleshoot application issues.
• Resolve in a timely and professional manner all assigned Help Desk Service Tickets.
• Coordinates with colleagues inside and outside the department, vendors, and contractors to complete projects and service requests.
• Performs related duties and responsibilities, as assigned.

In order to be considered, you must possess the following education and experience:

1. Education: An associate degree in computer science or closely related field from an accredited college or university OR its equivalent in terms of total course credits/units [i.e., at least sixty (60) semester or ninety (90) quarter credits/units with a minimum of twenty (20) semester or thirty (30) quarter credits/units in computer science or a closely related field].

AND

2. Experience: Three (3) years of full-time professional experience in application or software development or programming

• Substitution: Additional experience as described above may be substituted for the required degree on a year-for-year basis (up to a maximum of two (2) years). One (1) year is equivalent to thirty (30) semester units / forty-five (45) quarter units with a minimum of 10 semester / 15 quarter units in computer science or a closely related field.

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.

Desirable Qualifications: The stated desirable qualifications may be considered at the end of the selection process when candidates are referred for hiring.

• Demonstrated oral, written communication, and customer service skills.
• Professional experience with the following:
  • PeopleSoft HRMS versions up to and including 9.2 and PeopleCode up through and including version 8.6.
  • HRMS in the cloud (Oracle Cloud Infrastructure – OCI).
  • MS SQL, MS products, mobile apps, HTML, JavaScript with knowledge of one or more programming languages.
  • Oracle, PL/SQL and Web applications development. 
  • Public Safety systems.

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 or disqualification.

Background Investigation: Prior to employment with the San Francisco Police Department, a thorough background investigation will be conducted to determine the candidate’s suitability for employment. The investigation may include, but not be limited to: criminal history records, driving records, drug/alcohol screening, and other related employment and personal history records. Reasons for rejection may include use of  controlled substances and alcohol, felony conviction, repeated or serious violations of the law, inability to work with co-workers, inability to accept supervision, inability to follow rules and regulations or other relevant factors. Candidates may be required to undergo  drug/alcohol screening, and must clear Department of Justice and Federal Bureau of Investigation fingerprinting. Criminal records will be carefully reviewed; candidates who do not report their complete criminal records on their applications will be disqualified. Applicants will be fingerprinted.

Recruiter Information: If you have any questions regarding this recruitment or application process, please contact the Staff Services analyst, Danny Wan at danny.wan@sfgov.org.

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
• Right to Work
• Copies of Application Documents
• Diversity Statement

SFPD Recruitment: https://www.sanfranciscopolice.org/your-sfpd/career

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.