1053 IS Business Analyst-Senior
|Date Opened||7/28/2017 9:00:00 AM|
|Filing Deadline||9/29/2017 5:00:00 PM|
|Salary||$8,110.00 - $10,203.00/month; $97,318.00 - $122,434.00/year|
|Job Type||Permanent PBT|
This is a Position Based Test conducted in accordance with Civil Service Commission Rule 111A.
The Port of San Francisco is an enterprise agency of the City and County of San Francisco and is governed by a Commission of five members appointed by the Mayor. The Port Commission is responsible for overseeing a broad range of waterfront commercial, maritime, and public access facilities that are held in public trust for the people of California. The Port’s jurisdiction covers approximately 7.5 miles of waterfront land from Pier 98, near Hunter’s Point in the southern part of San Francisco, to Fisherman’s Wharf in the northern part of the City.
The Port’s diverse business portfolio includes over 550 ground, commercial, retail, office, industrial and maritime industrial leases including cargo shipping, ship repair, excursion boats, ferry boats, fishing and fish processing/distribution, tourism, filming, harbor services, and cruise-shipping. With some of the most modern and flexible shipping-terminal facilities on the West Coast, as well as naturally deep water, the Port can handle just about any type of cargo, including containers, break-bulk, neo-bulk, automobiles, and project cargoes.
The Port of San Francisco has some of the most internationally recognized landmarks such as Fisherman’s Wharf, Pier 39, the Exploratorium, the Ferry Building and AT&T Park, home of the San Francisco Giants baseball team. With some of the most unique and historic properties, the Port is home to a variety of tenants and uses.
The Port Commission over the last five decades has led a remarkable transformation of the Port; maintaining its industrial maritime heritage while developing new uses, including commercial and public activities, that have helped San Francisco remain one of the most visited and popular cities on the globe.
Within the Finance and Administrative Services Division, the Port’s Information Services group consists of Business Applications and Infrastructure teams. We support the Port’s mission, strategic plan, and daily operations with a focus on positive relationships with and quality service to everyone associated with the Port.
This position reports to the Business Applications Manager. Under general direction, the incumbent provides primary application support for our property and revenue management and GIS systems. This position conducts business analysis, requirements gathering, and primary application development and support for our property/revenue management and GIS systems. Responsibilities are both technical and functional in nature, as indicated below.
Essential functions include but are not limited to:
Property & Revenue Management (PROPworks) Application Support
·Maintain, support, and troubleshoot PROPworks to PeopleSoft AR Open Item (invoice) interface.
·Develop and update reports, using tools such as Oracle Reports 10g and JasperReports/Jaspersoft Studio.
·Work with third-party developers & support staff on open support & enhancement request tickets.
·Perform database queries and analysis to ensure accuracy of data as requested.
·Participate in periodic application upgrade projects, serving role as functional/technical business analyst lead.
·Work with system users to create test plans and test scripts.
·Maintain issue and enhancement request logs.
·Troubleshoot issues and answer general user questions.
·Create training materials and user guides, and provide one-on-one, small group and classroom style training to system users.
·Collaborate with Port users, City GIS specialists, and third-party vendors on projects, following IT standard best practices.
·Model Oracle Spatial data to develop, secure, refine, and maintain parcel layers.
·Integrate PROPworks data with lease maps.
·Support GIS web applications.
·Identify and analyze opportunities for integrating GIS data across all business applications.
·Prepare user and application support documentation, and provide training as needed
General Applications Support
·Communicate regularly with peers on support tasks, documentation efforts, learning opportunities, and enhancements to systems.
·Act as an advocate for change when identifying opportunities for improvements in efficiency and data security.
·Provide excellent customer service to our system users and interact positively with peers.
·Provide backup support for other applications and automated processes.
A baccalaureate degree in computer science or a closely related field from an accredited college.
Three (3) years of directly related experience in the following areas:
• Systems analysis and programming experience developing business applications for computer systems.
• Developing/supporting system interfaces.
• Experience in all aspects of the Systems Development Life Cycle (SDLC).
• Demonstrated techno-functional communication and documentation skills
• Oracle databases, Oracle RDBMS utilities (Export / Import, Data Pump, SQL*Loader, etc.).
• SQL and PL/SQL
• Linux / UNIX (knowledge of commands, advanced shell scripting, and job scheduling).
Desirable Qualifications - Experience with the following is highly desirable:
• Amadeus PROPworks property management software.
• Supporting and/or interfacing with PeopleSoft AR.
• Modeling Oracle Spatial data.
• AutoCAD GIS software.
• Developing and supporting SOA web apps.
• Developing complex Access database applications: split frontend/backend, Visual Basic for Applications(VBA), logins/access control.
License and Certification:
Possession of a valid California driver’s license (to be presented at time of employment). Applicants selected for employment must be insurable and maintain insurability under the department’s automobile liability insurance policy.
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.
The above 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.
This position requires that the incumbent be qualified for unescorted access to the Port’s Maritime Transportation System (MTS). An application for a TWIC card may be submitted after employment has commenced. Employment in this position requires that the incumbent undergo a criminal history check, immigration check and terrorist threat assessment, including FBI fingerprints, in order to determine eligibility for security clearance. The incumbent must submit an application for, successfully acquire and maintain a TWIC card. Per Civil Service Rule 110.9.1, every applicant must possess and maintain the qualifications required by law and by the announcement for this examination. Failure to acquire or maintain a TWIC card, a requirement for this position, may be the basis for termination from employment with the Port Commission. Note:
How To Apply
Applications for City and County of San Francisco jobs are being 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 announcement PBT-1053-078728
• 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.
Please contact Suzette Love at (415) 274-0569, or by email at Suzette.Love@sfport.com if you have any questions regarding this recruitment or application process.
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 http://sfdhr.org/how-verify-education-requirements
Applicants who have obtained education from a foreign college or university must provide a Foreign Transcript Evaluation letter from a National Association of Credentials Evaluation Service (NACES) approved agency. A list of approved agencies can be found at: http://www.naces.org
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.
Supplemental Questionnaire (Weight 100%)
Applicants will be prompted to complete a Supplemental Questionnaire as part of the online application process. All applicants must complete the Supplemental Questionnaire and it must be submitted with the application by the final filing deadline. The information provided on the Supplemental Questionnaire must be consistent with the information on the application and is subject to verification.
The Supplemental Questionnaire is designed to measure the knowledge, skills and abilities required for the 1053 IS Business Analyst-Senior which include: Support of enterprise software applications; database administration and querying tools; and GIS analysis and spatial database modeling and administration.
All relevant experience, education and training must be included on the supplemental questionnaire in order to be reviewed in the rating process.
Candidates will be placed on the eligible list in rank order according to their final score. A passing score must be achieved on the Supplemental Questionnaire in order to be placed on the eligible list.
As a finalist 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 finalist. 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 applying 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 applying 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 selected as a finalist, the hiring department will contact you to schedule a fingerprinting appointment.
Disaster Service Workers
The eligible list resulting from this examination 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 of 12 months, and may be extended with the approval of the Human Resources Director.
Upon approval of the Human Resources 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.
The certification rule for the eligible list resulting from this examination will be Rule of Seven Scores. Additional selection processes may be conducted by the hiring department prior to making final hiring decisions.
Applicants with disabilities who meet the minimum eligibility requirements for this job announcement can find information on requesting a reasonable ADA Accommodation at:
Information regarding veterans' preference for can be found at: http://www.sfdhr.org/index.aspx?page=20#veteranspreference
Seniority Credit in Promotional Exams: Information regarding seniority credit can be found at: http://www.sfdhr.org/index.aspx?page=20#senioritycredit
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.
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 th e 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.
Exam Type: CPE
Issued: July 28, 2017
Human Resources Director
Department of Human Resources
Recruitment ID Number: 078728
PRT/SL/ 415 274-0569
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.