1063 Senior IS Programmer Analyst

Recruitment #PBT-1063-113508

Introduction

*ANNOUNCEMENT UPDATED 7/28/2021 TO REFLECT NEW CONDITION OF EMPLOYMENT*

UPDATED 08/04/2021 TO EXTEND THE DEADLINE AND CHANGE THE NAME OF THE ANALYST

 

CONDITION OF EMPLOYMENT:  All City and County of San Francisco employees are required to be vaccinated against COVID-19 as a condition of employment.  For details on how it is applicable to your employment, please click here.

This is a Position-Based Test conducted per Civil Service Rule 111A. (PBT-1063-113508)

In line with the Official Public Health Order to slow the spread of COVID-19, the City’s Department of Human Resources office (located at 1 South Van Ness Avenue, 4th Floor, San Francisco, CA 94103) is currently closed to the public. If you have any questions, please email the Senior Human Resources Analyst listed on this announcement.

Work Location: The position is located at the San Francisco Office of the Treasurer & Tax Collector (1155 Market Street, San Francisco, CA 94102)

ABOUT THE OFFICE OF THE TREASURER & TAX COLLECTOR:

The Office of the Treasurer & Tax Collector serves as the banker, tax collector, collection agent, and investment officer for San Francisco's government, the only combined City and County in the State of California. The Treasurer, an elective office created by the City Charter in 1850, supervises a department of ten sections that collect over 12 billion dollars annually.

 

INFORMATION TECHNOLOGY SERVICES:

You will be joining a talented technology team that works hard and is ever striving for innovation and growth. We will challenge you to create balanced and effective technology solutions.  We are vital in achieving our departmental mission, as we collaborate with multiple business sections, vendors, and external enterprise-wide stakeholders to provide our public service.

 

POSITION DESCRIPTION:

The OFFICE OF THE TREASURER & TAX COLLECTOR is seeking experienced Programmers that will lead the work in the development and maintenance of responsive, accessible, and secure websites, tools, and databases.

 

This position functions as the leader of the Adobe AEM Application and will need to communicate effectively orally and in writing.

Essential Job Duties & Responsibilities:

  • Analyze: Determine requirements for systems.
  • Communication: Effective and clear communication with system users, colleagues, supervisors, managers, and other city departments.
  • Development: Using Adobe Experience Manager focusing on template design and generation of batch pdf output solutions.
  • Technical:
    • Create, restore, maintain SQL databases, tables, views, stored procedures, etc., to extract data.
    • Working knowledge of using the Adobe Experience Manager in form design, designing workbench applications, and generating bulk/high-level output to several forms, i.e., pdf or web content.
    • Performs data conversion between applications, designs, develops, and generates routine and ad hoc reports utilizing MS Excel or MS SQL.
    • Provide technical production support for online and batch systems; assist with set processing schedule; updates of systems.
  • Test: Research and evaluate appropriate technologies and make recommendations.
  • Support & Help: Identify areas for improvements (Lean Method)
  • Performs other related duties as assigned.

Minimum 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 exam/job announcement.

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].

Experience:
Three (3) years of experience in application or software development or programming

License and Certification:

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.

Desirable Qualifications:

One (1) year of experience working with Adobe Experience Manager (AEM).

VERIFICATION OF EDUCATION & 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 here.

Verification of qualifying experience, when requested, must be documented on the employer's business letterhead and must include the name of the applicant, job title(s), dates of employment, description of job duties performed, and signature of the employer or the employer’s authorized representative. Experience claimed in self-employment will only be accepted if supported by documents verifying income, earnings, business license and experience comparable to minimum qualifications above. Copies of income tax papers or other documents listing occupation and total earnings must be submitted.

Employees of the City and County of San Francisco may submit performance evaluations showing duties performed to verify qualifying City experience. City employees will receive credit for the duties of the class to which appointed. Credit for experience obtained outside of the employee's class will be allowed only if recorded in accordance with the provisions of Civil Service Commission Rules. Verification may be waived if impossible to obtain. The applicant must submit a signed statement explaining why verification cannot be obtained. Waiver requests will be considered on a case-by-case basis. Failure to provide the required verification, or request for waiver when requested may result in rejection of application.

 

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. Make sure your application and any attachments to the application submitted at the time of filing are complete and accurate and include details on all experience, education, training and other information that qualifies you for this recruitment. Failure to submit a complete and accurate application at the time of filing may result in your ineligibility for this recruitment or inability to receive full credit for scoring purposes. Any new information concerning work experience, education, training and other information that is submitted after the filing deadline may not be used for scoring or considered to determine whether you meet the minimum qualifications.

How To Apply

Applications for City and County of San Francisco jobs are only accepted through an online process. Visit www.jobaps.com/sf to register an account (if you have not already done so) and begin the application process.

 

  1. Select the desired job announcement
  2. Select “Apply” and read and acknowledge the information
  3. Select either “I am a New User” if you have not previously registered, or “I have Registered Previously”
  4. Follow instructions on the screen

 

In line with the Official Public Health Order to slow the spread of COVID-19, “shelter-in-place” has been issued for all San Francisco residents that is expected to be in effect until further notice. As a result, Department of Human Resources (DHR)’s office (located at 1 South Van Ness Avenue, 4th Floor, San Francisco, CA 94103) is currently closed to the general public. If you have any questions, please feel free to email the Human Resources Analyst listed on this announcement.

Applicants may be contacted by email about this announcement 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).

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.

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.

If you have any questions regarding this recruitment or application process, please contact the exam analyst, Guillermo Tapia, by telephone at (415) 554-4473, or by email at Guillermo.Tapia@sfgov.org

Selection Plan

MQSQ (Weight Qualifying)

Supplemental Questionnaire (100%)

Selection Procedures

Minimum Qualification Supplemental Questionnaire (Weight: Qualifying):

Candidates will be prompted to complete a Supplemental Questionnaire as part of the online employment application. This Minimum Qualification Supplemental Questionnaire is designed to obtain specific information regarding an applicant's experience in relation to the Minimum Qualifications for this position. Applicants must also complete the official application. It is essential that applicants provide complete information in identifying their education, experience, and training. The Minimum Qualification Supplemental Questionnaire will be used to evaluate if the applicant possesses the required minimum qualifications.

 

Supplemental Questionnaire Evaluation (Weight: 100%):

Candidates who meet the Minimum Qualifications will be invited to participate in a Supplemental Questionnaire.  The responses to the Supplemental Questionnaire will be scored as part of the overall score which, will determine relative knowledge, ability and, skill level in one or more of the following job- related areas as appropriate. (Technical, General Professional, and Analytical)

Technical: In-depth knowledge of MS SQL and Adobe Experience Manager.

Professional: Ability to communicate effectively, interact and establish good working relationships, and working effectively in a team environment.

Analytical:  Ability to search and obtain necessary information through a variety of methods and develop options for solutions and make logical recommendations.  

 

Certification Rule: The certification rule for the eligible list resulting from this examination will be Rule of Ten (10) Scores. Additional position selection processes may be conducted by the hiring department prior to making final hiring decisions.

 

Eligible List/Score Report:
A confidential eligible list of applicant names that have passed the civil service examination process will be created, and used for certification purposes only. An examination score report will be established, so applicants can view the ranks, final scores and number of eligible candidates. Applicant information, including names of applicants on the eligible list, shall not be made public unless required by law. However, an eligible list shall be made available for public inspection, upon request, once the eligible list is exhausted or expired and referrals resolved. The eligible list/score report resulting from this civil service examination process is subject to change after adoption (e.g., as a result of appeals), as directed by the Human Resources Director or the Civil Service Commission. 

The duration of the eligible list resulting from this examination process will be twelve (12) months, and may be extended with the approval of the Human Resources Director.


Upon approval of the Human Resource Director (see Civil Service Rule 111A.26.5), the eligible list resulting from this announcement may be used by other departments that also use this classification or a similar classification. To find other Departments which use this classification, please see http://www.sfdhr.org/Modules/ShowDocument.aspx?documentID=21246. Search that document by title or job code to see which departments use the classification.

Conviction History

As a selected candidate for a job, you will be fingerprinted, and your fingerprints will be sent to the California Department of Justice (DOJ) and the Federal Bureau of Investigation (FBI). The resulting report of your conviction history (if any) will be used to determine whether the nature of your conviction (or arrest, in limited circumstances) conflicts with the specific duties and responsibilities of the job for which you are a selected candidate. If a conflict exists, you will be asked to present any evidence of rehabilitation that may mitigate the conflict, except when federal or state regulations bar employment in specific circumstances, such as:

  • Candidates for positions with the Unified School District and the Community College District may be disqualified from consideration should their conviction history not meet the standards established under the California Education Code.
  • Candidates for positions with the Recreation and Park Department may be disqualified from consideration should their conviction history not meet the standards established under California Public Resources Code 5164.

Having a conviction history does not automatically preclude you from a job with the City.

If you are a selected candidate, the hiring department will contact you to schedule a fingerprinting appointment.

Disaster Service Workers

All City and County of San Francisco employees are designated Disaster Service Workers through state and local law (California Government Code Section 3100-3109). Employment with the City requires the affirmation of a loyalty oath to this effect. Employees are required to complete all Disaster Service Worker-related training as assigned, and to return to work as ordered in the event of an emergency.

Conclusion

Women, Minorities, and Persons with Disabilities are encouraged to apply.

The City and County of San Francisco is an equal opportunity employer.

Applicants with disabilities requiring reasonable accommodation should contact Guillermo Tapia, Senior Human Resources Analyst, at (415) 554-4473 (voice); via email at: Guillermo.Tapia@sfgov.org or in writing (specify job code 0923) to: Office of the Treasurer /Tax Collector, Human Resources, PO BOX 7426, San Francisco, CA 94120-7426, as soon as possible.

Terms of Announcement: Applicants must be guided solely by the provisions of this announcement, including requirements, time periods and other particulars, except when superseded by federal, state or local laws, rules or regulations.  Clerical errors may be corrected by the posting the correction on the Department of Human Resources website at www.jobaps.com/sf.

The terms of this announcement may be appealed under Civil Service Rule 111A.35.1. The standard for the review of such appeals is ‘abuse of discretion’ or ‘no rational basis’ for establishing the position description, the minimum qualifications and/or the certification rule. Appeals must include a written statement of the item(s) being contested and the specific reason(s) why the cited item(s) constitute(s) abuse of discretion by the Human Resources Director. Appeals must be submitted directly to the Executive Officer of the Civil Service Commission within five business days of the announcement issuance date. 

General Information concerning City and County of San Francisco Employment Policies and Procedures: Important Employment Information for the City and County of San Francisco can be obtained at http://sfdhr.org/information-about-hiring-process or hard copy at 1 South Van Ness Avenue, 4th Floor.

Copies of Application Documents: Applicants should keep copies of all documents submitted, as these will not be returned.

Right to Work: All persons entering the City and County of San Francisco workforce are required to provide verification of authorization to work in the United States.

ADA Accommodation: Applicants with disabilities who meet the minimum eligibility requirements for this job announcement can find information on requesting a reasonable at: http://sfdhr.org/information-about-hiringprocess#applicantswithdisabilities

Veterans Preference: Information can be found at: 
http://sfdhr.org/information-about-hiring-process#veteranspreference

Seniority Credit in Promotional Exams:  Information regarding seniority credit can be found at:
http://www.sfdhr.org/index.aspx?page=20#senioritycredit

Exam Type: CPE
Issued:  July 22, 2021

Extended: 08/04/2021
Carol Isen
Human Resources Director
Department of Human Resources
Recruitment ID Number: 113508
TTX/GT/ (415) 554-4473

 

 

Benefits

All employees hired on or after January 10, 2009 will be required (pursuant to San Francisco Charter Section A8.432) to contribute 2% of pre-tax compensation to fund retiree healthcare. In addition, most employees are required to make a member contribution towards retirement, ranging from 7.5%-13.25% of compensation. For more information on these provisions, please contact the personnel office of the hiring agency.

For more information about benefits, please click here.

 



Powered by JobAps