1054 Principal Asset Management and Billing Application Analyst

Principal IS Business Analyst

Recruitment #PBT-1054-065850


This is a Position Based Test conducted in accordance with Civil Service Rule 111A.

This announcement has been amended to modify the minimum qualifications.

The Department of Technology is the centralized technology services provider within San Francisco City & County government, delivering technology infrastructure and services to approximately 28,000 employees and 800,000 citizens.  The department has an annual operating budget of over $97M and contains over 220 employees.  Core service areas include: Technology Architecture & Security, Technology Service Delivery & Management, Client Services & Project Management Office, Public Safety Systems & Wiring, Technology Administration, Policy & Governance, and Public Communications.

Position Description:
The Principal Asset Management and Billing Application Business Analyst will work as part of a team implementing and maintaining applications supporting billing, asset and telephony management, and service management for the Department of Technology. This position will be responsible for complex analytical activities involving the evaluation, design, maintenance, and documentation of department applications and specialize in the asset management area. Job responsibilities include operational support and data analysis for monthly business processes, investigating and resolving trouble incidents, and analyzing and implementing requests and enhancements.

The ideal candidate will have a background in telephony or IT asset management, but we are willing to train someone with strong business application implementation and support experience.

Examples of Important and Essential Duties
- Provide support for the asset manager application related to telephone billing; maintain ongoing processes for monthly billing events, validate and process asset data, develop and maintain integrations between related applications using ETL tools, and function as the primary business analyst in this area.

- Maintain and develop application wizards and workflows within the asset management application to satisfy business requirements.

- Create complex data queries using SQL against a database backend.

- Determine requirements and create online views for management and end users within the asset management application.

- Work with business clients to determine requirements and transform requirements into application design.

- Evaluate enhancements and solutions for application systems as business requirements change. Implement solutions and integrate into operational processes.

- Leverage application configuration tools to implement enhancements and changes

- Perform business process analysis and document work flows and system integrations

- Troubleshoot and resolve operational issues. Interface with vendor technical support to resolve application issues

- Provide assistance, training, and user documentation to clients.

- Identify issues and devise methods to improve the quality and integrity of data.

- Communicate with all levels of technical and non-technical staff and clients

- Generate detailed process and system documentation

- Identify opportunities for functional and operational improvement in existing application systems

Nature of Work
Candidate must be willing to work a 40-hour week as determined by the department.  Occasional weekend work is required.  The majority of work will be at the Department of Technology site located at One South Van Ness; however, there may be situations where the incumbent will be required to work at other sites throughout the City of San Francisco.  May involve extensive VDT exposure.

Minimum Qualifications

1. A Bachelor's degree from an accredited college or university, in Computer Science, Management Information Systems, Data Processing, Electrical Engineering, or a closely related field; AND

2. Five years of verifiable experience in each of the following areas: 
        a. Evaluation, design, support, maintenance, and documentation of business applications; AND 
        b. Business process analysis and design; AND 
        c. Database design on an industry standard platform such as SQL Server or Oracle.

(Please note, the required experience within the given areas listed above, can be obtained concurrently)

Substitution:  Applicants may substitute additional qualifying experience for the required education.  One year (2000 hours) of qualifying experience will be considered equivalent to 30 semester units/ 45 quarter units.

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 class code.

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

- Experience with Asset Management, IT billing, or Service Desk applications
- Experience with vendor applications HP Asset Manager or ServiceNow
- Experience with SQL (Structured Query Language) and data analysis
- Strong technical and problem solving skills
- Excellent written and verbal communication skills
- Strong customer service orientation skills

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
  • 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, Patrick Cheng, by telephone at 415-558-3911 or by email at Patrick.cheng@sfdpw.org (preferred). 

Verification: Resumes will not be accepted in lieu of verification of qualifying experience and education. 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/index.aspx?page=456

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

Supplemental Questionnaire (Weight: 100%):
Candidates will be evaluated and scored based on the information provided in their job application, required verification, and supplemental questionnaire to determine their possession of the knowledge, skills, and abilities required for position 1053 Senior Business Analyst.  All relevant experience, education and/or training must be on the application, resume and 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.

Certification Rule:
The certification rule for the ranked eligible list resulting from this examination will be Rule of Three Scores.

The department may administer additional position-specific selection procedures to make final hiring decisions.

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

Security Clearances and Background Investigation:
Candidates for Department of Technology Data Center are required to have a thorough background investigation to determine the candidates’ suitability for employment in this classification. Factors considered in the investigation may include employment history, use of illegal/controlled substances. Reasons for rejection based on this investigation may include: but not limited to: applicable convictions, repeated or serious violations of the law, inability to accept supervision, inability to follow rules and regulations, falsification of application materials and/or other relevant factors.

Failure to obtain and maintain security clearance may be basis for termination from employment with the Department of Technology.

Conviction History

As part of the selection process an image of your fingerprints will be captured and 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) history will disqualify you as a candidate based on the specific requirements of the position to which you are applying. If selected for fingerprinting, the hiring department will contact you to schedule an appointment.

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.

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.


General Information concerning CCSF Employment Policies and Procedures

A hard copy of Important Employment Information for the CCSF can be obtained at 1 South Van Ness Avenue, 4th Floor, San Francisco. 

Employment, Character and Background Investigation

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. [Note: The correction of clerical errors in an announcement may be posted on the Department of Human Resources website at www.jobaps.com/sf.] The terms of this announcement may be appealed under Civil Service Rule 110.4. Such appeals must be submitted in writing to the Department of Human Resources, 1 S Van Ness Avenue, 4th Floor, San Francisco, CA 94103-5413 by close of business on the 5th business day following the issuance date of this examination announcement. Information concerning other Civil Service Commission Rules involving announcements, applications and examination policies, including applicant appeal rights, can be found on the Civil Service Commission website at http://sfgov.org/civilservice/rules.

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.


Reasonable Accommodations:

Applicants with disabilities who meet the minimum eligibility requirements for this job announcement can find information on requesting a reasonable Americans with Disability Act Accommodation using the link above.

Seniority Credit in Promotional Exams:

Information regarding requests for Seniority Credit can be found using the link above.


Veteran's Preference:

Information regarding requests for Veterans Preference can be found using the link above.

Combined Promotive and Entrance
Issued: September 25, 2015

Recruitment ID Number: 065850
Micki Callahan

Human Resources Director
Department of Human Resources




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