1054 IS Business Analyst-Principal

Recruitment #pbt-1054-903482

Introduction

This is a Position Based Test (PBT) conducted in accordance with Civil Service Rulle 111A

 

Position Description

Under general direction, the 1054 Principal IS Business Analyst will serve as the technical authority in SQL Server Database applications and Microsoft Access Design and Development for the Office of the City Attorney. The position provides technical leadership and direction and assumes technical responsibility for the completion of major projects; performs or oversees all or most of the systems development life cycle and ongoing administration functions, including needs analysis, cost-benefit analysis, structured systems analysis and design, feasibility analysis, technology and software assessment, project planning and management, system installation, implementation and testing, conversion to production status, technical and procedural documentation, user training, and post-implementation assessment and administration; directs and participates in complex studies.

 

 Essential Duties and Responsibilities:

1. Manages complex systems; design, plan, and analyze new or existing systems for meeting users’ business needs by gathering requirements and other information, and recommend modifications or develop enhancements to systems
2. Responsible for system administration of CityLaw Claims, Case Inventory, Work Assignments, Collections, Risk Management, Child and Family, Conservatorship, Workers’ Compensation, Time Billing, Court calendars, Payment Tracking, Document Management, Template Design and File Management.
3. Performs daily, weekly, and monthly backups
4. Determines requirements, scope, deliverables, and milestones for new systems
5. Conducts user training and administers user security protocols;
6. Installs and enhances software; program, test, debug and install new/modified programs. Provides technical support for computer and applications; consults on the analysis of an application; troubleshoots system problems; implement solutions
7. Performs feasibility/analysis, develop and implement enhancements;
8. Writes/automates complex SQL based queries/reports; write detailed design specifications; conduct "walkthroughs" for proposed solutions to operations applications problems and business data needs.
9. Designs, develops, supports, and creates Microsoft Access databases and reports
10. Manages Database Disaster Recovery Plan
11. Conducts project meetings
12. Maintains ethical walls as the system administrator
13. Performs related duties as required.

Minimum Qualifications

Education: 

 

An associate degree in computer science or a 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

Experience:

Five (5) years of experience in the information system field, including programming and system analysis, business process design, development and implementation of business application solutions or IT project management 

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.

  

Special Conditions:

In addition to the Minimum Qualifications above, applicants must have the following experience in order to qualify.  The below minimum qualifications reflect special conditions associated with the position(s) to be filled. They may differ from the standard minimum qualifications associated with this classification. 

  

1. Two (2) years verifiable experience acquired within the last five (5) years with Microsoft Access design and development; AND
2 . Two (2) years of verifiable experience acquired within the last five (5) with SQL Server database applications; AND
3. The ability to lift 30 pounds

Experience under minimum qualification and under special conditions #1 and #2 above can be gained concurrently.

 Desirable Qualifications:

• Experience working in a legal environment
• Professional IS Business Analyst work experience in the Public Sector (Government or Nonprofit) 

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

 

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

 

VERIFICATION OF EXPERIENCE AND/OR EDUCATION:

Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and selection process. Refer to the following links for verification:

Verification Guidelines: http://www.sfdhr.org/index.aspx?page=20#verification

 
Education Verification, including verifying foreign credits or degree equivalency:

https://sfdhr.org/sites/default/files/documents/Job-Seekers/How-to-Verify-Education-Requirements.pdf

 
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.

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

• Select the desired job announcement (PBT-1054-903482)
• Select “Apply” and read and acknowledge the information
• Select either “I am a New User” if you have not previously registered, or “I have Registered Previously”
• Follow instructions on the screen

Computers are available for the public (from 8:00 a.m. to 5:00 p.m. Monday through Friday) to file online applications in the lobby of the Dept. of Human Resources at 1 South Van Ness Avenue, 4th Floor, San Francisco.
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, Lillian Chow, by telephone at 415.554-4226, or by email at lillian.h.chow@sfcitatty.org.

Selection Plan

Supplemental Questionnaire Evaluation (Weight 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: (Weight: 100%)

Candidates will be prompted to complete a supplemental questionnaire as part of the online employment application. The Supplemental Questionnaire is designed to measure an applicant’s relative knowledge, skills and abilities in job-related areas identified as critical for successful performance. These may include but are not limited to: managing complex systems; design, plan, and analyze new or existing systems for meeting users' business needs; conducting user training;  designing, developing, supporting and creating Microsoft Access databases and reports; and maintaining ethical walls. Ability to: establish and maintain good working relationships; implement and manage complex projects; analyze data and information; understand business procedures and processes; advise and train others; exercise decisiveness and creativity required in situations involving the evaluation of information against judgmental criteria. All responses to the Supplemental Questionnaire are subject to verification and should be consistent with the information provided in your application.

Passing score must be achieved on the supplemental questionnaire in order to continue in the selection process.

Candidates’ scores on this examination process may also be applied to other announcements involving other job titles, when directed by the Human Resources Director.

CERTIFICATION:

The certification rule for the score report resulting from this examination process will be Rule of Three (3) scores. The hiring department may conduct additional selection processes to make 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 six (6) 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/score report 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 https://sfdhr.org/sites/default/files/documents/ASO-Level-Chart.pdf?documentID=21246.

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

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:

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.

 

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.

REASONABLE ACCOMMODATION REQUEST:

Information on requesting reasonable accommodation for persons with disabilities can be found at: http://www.sfdhr.org/index.aspx?page=20#reasonableaccommodation

SENIORITY CREDIT IN PROMOTIONAL EXAMS:

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

DRIVER’S LICENSE REQUIREMENT:

Most positions require a valid California’s driver’s license: http://www.sfdhr.org/index.aspx?page=20#license

 
VETERAN’S PREFERENCE:

http://www.sfdhr.org/index.aspx?page=20#veteranspreference

CLERICAL ERRORS:

May be corrected by the posting of the correction on the Department of Human Resources website at: http://www.sfdhr.org/index.aspx?page=20#announcementsdefinitions

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. http://www.sfdhr.org/index.aspx?page=20#identification

Exam Type: CPE (Combined Entrance and Promotive)
Issued: June 17, 2019
Micki Callahan, Human Resources Director
Department of Human Resources
Recruitment ID Number: PBT-1054-903482
CAT/ LC / 415-554-4226

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