1053 IS Business Analyst - Senior

Recruitment #PBT-1053-100395


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 many 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 its 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.


Job Description

Within the Finance and Administration Division, the Port’s Information Technology 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 responsible for providing business analysis, requirements gathering, application interface and report development and support, and ongoing production support for the Port’s various business applications.  The IT group in general, and the Business Applications team in specific, works in a collaborative and cohesive fashion that relies heavily on frequent interaction and commitment to knowledge transfer, cross-training, and excellent customer service.  Essential functions include but are not limited to:

Business Applications Maintenance, Support, and Development

·       Work closely with Port Business Applications team peers and business users to provide comprehensive production maintenance and support of the Port’s various systems and business applications to ensure optimal uninterrupted daily operations.

·       Grow into and assume a lead role in administering and supporting our PROPworks revenue and property management system.  This includes support for system updates and upgrades, maintenance and development of reports, and integrations with the City’s PeopleSoft systems as well as our ESRI GIS and Arches project tracking systems.

·      Be flexible in adapting to and providing support for all Port business applications.  Provide and receive frequent knowledge transfers and cross-training to ensure confidence.

·       Coordinate and lead frequent engagement with our business users to ensure our business applications are performing optimally and that requirements are updated and documented. 

·       Collaborate with Port Business Applications team peers and business users to maintain, support, and troubleshoot the Port’s various application interfaces to/from the City’s Peoplesoft HCM, Financials, and Supply Chain Management system.  

·       Collaborate with Port Business Applications team peers, business users, and third-party vendors to efficiently respond to, troubleshoot, and successfully resolve reported problems. Maintain issues and enhancement request logs.

·       Participate in periodic application upgrade and maintenance projects, serving in a Techno-Functional Business Analyst - Lead or Support role as requested.

·       Assist Port Business Applications team peers, business users, third-party vendors, and external consultants on projects as requested, following IT standard and best practices.

·       Work closely with Port Business Applications team peers and business users to create test plans and test scripts.

·       Prepare training materials and user guides, and provide one-on-one, small group, and classroom style training to Port business users.

·       Prepare user and application support, documentation, and provide training as needed.

·       Communicate frequently and regularly with Business Applications team peers regarding ongoing production maintenance and support tasks, documentation efforts, learning opportunities, and enhancements to systems.

·       Positively engage in continuous communication, relationship building, team building, and teamwork efforts to ensure team cohesiveness and organizational improvement and success.

·       Act as an advocate for organizational change while working with Port IT management to identify opportunities for improvements in efficiency and data security.

·       Provide excellent customer service to our business users and positive collaboration with Business Application team peers and everyone associated with the Port and City.

·       Be committed to working in a collaborative team environment with a 50/50 split technical/functional focus.


Business Applications Enterprise Reports & Dashboard Development, Maintenance, and Support

·       Engage with business stakeholders and users to ensure that reporting needs are met.  

·       Collaborate with Port Business Applications team peers and business users to provide analysis, design, development, and maintenance of enterprise reports and dashboards in support of the Port’s long-term strategy to become more data-driven (using enterprise reporting tools such as OBIEE, PeopleSoft Query Manager, Oracle BI Publisher, Microsoft Power BI, JasperReports/Jaspersoft Studio, and Oracle Reports 10g.

·       Perform analysis tasks and create database queries using SQL to ensure data accuracy, consistency, integrity, and performance.

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.  Applicants must meet the minimum qualification requirements by the final filing date unless otherwise noted.



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



Three (3) years in the information systems field, including system analysis, business process design, development and implementation of business application solutions or IT project management.


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. 



Special Conditions:

In addition to the Minimum Qualifications above, applicants must have the following experience to qualify for this Port 1053 IS Business Analyst - Senior position:


  1. Three (3) years Oracle Database and Application Development and Maintenance experience; AND 
  2. Three (3) years Web-enabled Application Development experience; AND
  3. One (1) year Financial Applications Support experience. 

The ideal candidate will have a combination of the following desired experience:

  • Systems analysis, problem solving, and scripting/programming experience maintaining business applications.
  • Production Support, change management, and incident tracking.
  • Designing, developing, and supporting automated system interfaces.
  • Experience with all six steps of the Software Development Life Cycle (SDLC).
  • Demonstrated techno-functional communication and documentation skills.
  • Database interaction experience, including SQL and PL/SQL, Oracle RDBMS utilities (Export/Import, Data Pump, SQL*Loader, etc.).
  • Collaboration, teamwork, and relationship-building skills.
  • Reporting tools (e.g. Crystal Reports, OBIEE, Microsoft Power BI, PeopleSoft Query Manager, Oracle BI Publisher, JasperReports/Jaspersoft Studio, and Oracle Reports 10g).
  • Microsoft PowerShell and/or Linux (knowledge of commands, shell scripting, job scheduling, etc.).
  • Amadeus PROPworks property management software.
  • JIRA (issue tracking / project management).
  • Microsoft Windows application & database server environments.
  • Supporting and/or interfacing with PeopleSoft HCM, Financials, and Supply Chain Management.
  • Supporting complex Microsoft Access database applications: split frontend/backend, Visual Basic for Applications(VBA), logins/access control.
  • Microsoft SharePoint administration and development.
  • Autodesk AutoCAD and ESRI ArcGIS software.

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-100395
• 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 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.




Selection Procedures


Minimum Qualifications Supplemental Questionnaire (MQSQ - Qualifying)

Applicants will be prompted to complete a Minimum Qualifications Supplemental Questionnaire (MQSQ) as part of the online application process. All applicants must complete the MQSQ 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. Applicant responses to the MQSQ will be used to assist in determining if applicants meet the minimum qualifications for the position.



Supplemental Questionnaire (SQ - Weight: 100%)

The purpose of the Supplemental Questionnaire (SQ) is to evaluate the experience, knowledge, skills and abilities that candidates possess in job-related areas, which have been identified as critical for this position and include, but are not limited to: knowledge and understanding of SDLC processes; support of enterprise software applications (standard and custom modules and code); knowledge and extensive use of various querying and reporting tools.



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 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/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



Certification Rule

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.


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.


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 

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. 

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 requests for Veterans Preference can be found at: 

Seniority Credit in Promotional Exams: 
Information regarding seniority credit can be found at: 

Micki Callahan, Director 
Department of Human Resources 
Announcement #100395

Exam Type:  Combined Promotive and Entrance (CPE)
Issued: December 27, 2019
Port/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.

For more information about benefits, please click here.


Powered by JobAps