IS Business Analyst-Senior

Recruitment #PBT-1053-084718

Introduction


1053 Senior Business Analyst
(IS Business Analyst - Senior)

 

This is a Position-Based Test conducted in accordance with Civil Service Rule 111A. This eligibility list is being established for the San Francisco Community College District.

 

This position is located at City College of San Francisco.
 

Under general direction, oversees the more difficult and complex aspects of the systems development cycle, including needs analysis, cost-benefit analysis, structured systems analysis and design, feasibility analysis, technology and software assessment, telecommunications needs analysis, 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; may be the primary MIS resource for an organization with a complex system.

 

* NOTE (Salary): Appointment entry contained only to Salary Range A. Salary Range B is based on seniority and years of service at City College of San Francisco. 

 

Example of Important and Essential Duties (to include, but not limited to):

  1. Identify opportunities to improve business processes through automation;
  2. Perform Ellucian Banner (Banner) - specific tasks for the department, such as:
    • Set-up and troubleshoot operational processes including calculations and deadline dates (e.g., census, drop dates, etc.)
    • Set-up and complete upload and rollover processes (e.g., end of term, end of year, leaves, salary history, aid-year rollover) 
    • Maintain and manage application integration; work with current and new institutions in establishing and maintaining protocols for electronic record transfer.
    • Assists in the scheduling and submission of institutional upload using FTP or SFTP to third party agencies and reconcile errors.
  1. Be the primary resource for state and/or federal agencies to facilitate loading, correcting, and downloading processes (e.g., Department of Education, State California Community College Technology Center, California Student Aid Commission).
  2. Provide Banner support for staff, faculty, and administrators (e.g., Student, Payroll, Human Resources, Finance, Financial Aid, Accounts Receivables).
  3. Write SQL queries. Learn, understand and modify as required existing SQL and SQR queries. May install and enhance software; program, test, debug and install new/modified programs.
  4. Create reports using eVisions' ARGOS report writing software.
  5. Monitor and schedule batch processing using Automics' job scheduling software.
  6. Analyze data processing needs; research and evaluate software on multiple platforms to assist users to meet their departmental goals; assist in developing the evaluation criteria for software.
  7. Determine operating characteristics and requirements; develop or modify and document general system design; write detailed design specifications; conduct "walkthroughs" for proposed solutions to system problems.
  8. Analyze the feasibility of and develop requirements for enhancements to existing systems; ensure the system design fits the needs of the users such as oversight, management and testing of Banner upgrades; functionality of integral processes to Banner operations.
  9. Consult on the analysis of an application; troubleshoot system problems; implement solutions.
  10. Conduct system analysis and may conduct programming activities for complex systems; document new and modified systems.
  11. Interface with users to determine system needs and requirements; instruct users on newly implemented systems; define system requirements; may design and code programs; review impact of system modifications on existing systems.
  12. May provide technical production support for on-line and batch systems; assist with set processing schedule; update and produce reports.
  13. Coordinate with outside vendors and contractors to complete projects and service requests; define, assign and evaluate their work.
  14. Assists with conversion of data; design, develop and generate routine and ad hoc reports in response to user needs.
  15. Prepare specifications and coordinate test plans .
  16. Tests database applications to assure functionality and effectiveness in performing to desired specifications.

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

 

Experience:
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.

 

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:

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

  1. Knowledge and experience working with Ellucian Banner System or other Higher Education Systems.
  2. Experience in higher education information technology support.
  3. Strong SQL language programming and query optimization skills.
  4. Strong problem solving skills.
  5. Exceptional interpersonal communication skills.
  6. Exceptional oral and documentation skills.
  7. Excellent customer service skills.
  8. Knowledge and experience working with Oracle Database Server.
  9. Knowledge and experience working with Evisions Argos reporting platform.
  10. Knowledge and experience working with a job scheduling software tool.

 

How To Apply

To be considered for this position, an online City and County of San Francisco application must be completed in full (note employment history section MUST be completed). 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

The following materials must be submitted along with your application by the filing deadline. Substitution of required documents is not permitted. Information submitted after the filing deadline will not be considered in determining whether you meet the minimum qualifications. You will be considered as "DISQUALIFIED".

  1. A letter expressing interest in the position specifically indicating how you meet the Minimum Qualifications and the Desirable Qualifications as listed in this announcement; AND
  2. A current resume summarizing educational background and related work experience; AND
  3. Educational Verification and Certifications as stated below.

 

VERIFICATION:

Applicants are required to submit verification of qualifying education and experience at the time of submitting their application. (Documentation will not be accepted after the application deadline expires.)


VERIFICATION OF EDUCATION:

Verification of qualifying education must include copy of official or unofficial transcripts or training certificates. Unofficial transcripts must include degree conferred date, otherwise it will be considered as invalid. A photocopy of a degree is not acceptable documentation. If verification cannot be obtained, the applicant must submit a signed statement with the application explaining why such verification cannot be obtained. Requests for waiver will be considered on a case-by-case basis. Failure to submit the required verification or request for a waiver at the time of verification is requested may result in the rejection of the application. Foreign degree(s)/coursework used as qualifying to meet minimum qualifications must be evaluated by a foreign degree evaluation services organization before an application can be processed. Please contact the City College of San Francisco Human Resources Department at 415-241-2246 for evaluation sources. Failure to submit the required verification or request for waiver with the application at the time of filing will result in rejection of the application.


VERIFICATION OF EXPERIENCE: Verification of qualifying experience may be requested at any time during this recruitment and selection process. If requested, verification of experience needed to qualify must be submitted on the employer's letterhead and indicate the name of the applicant, job title, dates of employment, hours/week, and duties performed and must be signed by the supervisor and/or appropriate company representative.

Certification of experience may be waived if impossible to obtain. The applicant must submit a signed statement with the application explaining why verification cannot be obtained. Waiver requests will be considered on an case-by-case basis. Failure to submit the required verification or request for waiver with the application at the time of filing or request will result in rejection of the 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 City College of San Francisco and the City and County of San Francisco.



For this position, 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 or San Francisco Community College District in the lobby of Human Resources at 33 Gough Street, San Francisco.

Applicants will 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 applica  tion 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. It is the sole responsibility of the applicant to ensure all attachments have been received by the analyst after submission and prior to the expiration of the deadline date and time. Applicants will not be contacted about missing documentation or attachments.

If you have any questions regarding this recruitment or application process, please contact the exam analyst, Karen White, by telephone at 415.241.2356, by email at kdwhite@ccsf.edu or in person at 33 Gough Street, San Francisco, 94103.

Selection Procedures

NOTE: Candidates who meet the minimum qualifications are not guaranteed to advance through all of the steps in the selection process. Candidates must achieve a passing score per each selection component noted below to move forward in this selection process. After successfully receiving a passing score, candidate will be notified of the exact date, time and place to report for the next examination via email. Examination cannot be rescheduled for another date or time by or for candidate(s) so candidate(s) is automatically disqualified if they cannot attend.

 

SUPPLEMENTAL QUESTIONNAIRE (pass/fail)  

Candidates will be prompted to complete a Supplemental Questionnaire as part of the online employment application. The Supplemental Questionnaire is designed to determine education and experience as well as measure knowledge, skills and/or abilities in job-related areas which may include, are not limited to: 

  • Experience in systems analysis and design
  • Experience in functional and operational procedures and requirements
  • Experience in applicant/student systems, reporting tools, and databases (e.g., Argos and Banner) 
  • Knowledge of personal computer applications development tools

All relevant experience, education and/or training must be included on the application and Supplemental Questionnaire at the time of filing in order to be reviewed during the rating process and cannot be changed once submitted.  All answers to the Supplemental Questionnaire must be completed, and all information is subject to verification. The Supplemental Questionnaire will assist in the determination of whether applicants meet the eligibility requirements to participate in the examination. An incomplete Supplemental Questionnaire will result in disqualification of your application and responses with "See Resume" or "in my current experience" will result in applicant receiving lower score(s) or rejected.



CITY COLLEGE CORE EXAMINATION (Weight: 40%)

 

This is a standardized written multiple-choice examination. In accordance with Civil Service Rule 111.11.4, inspection privileges do not apply to the questions and answers in this examination. This multiple-choice exam will be administered in a paper format.

Candidates who meet the minimum qualifications will be invited to participate in a written, multiple-choice examination, designed to measure their relative knowledge, skills and abilities in job-related areas. The “core” multiple-choice examination component may include, but not be limited to:

  • Experience in systems analysis and design
  • Experience in analyzing data and information using established criteria or data 
  • Experience with business processes through automation tools
  • Knowledge of coding, testing, and implementing complex programs 
  • Knowledge in higher education information technology support 
  • Ability to deal with third party vendors
  • Ability to analyze data needs, research, and evaluate software on multiple platforms
  • Ability to use script/procedure language(s)

A passing score must be achieved on City College's Core Examination to advance to the Oral Examination.

 

Oral Examination (Weight: 60%)

Only qualified candidates from the scored City College Core examination will be invited to participate in a panel oral examination to determine their relative knowledge, skills, and abilities in job-related areas of a Senior IS Business Analyst. (This component of the examination and test questions, and test answers are not available for public inspection or review.)

  • Experience in systems analysis and design
  • Experience in functional and operational procedures and requirements
  • Knowledge of coding, testing, and implementing complex programs
  • Knowledge of business procedures and processes
  • Knowledge of personal computer applications development tools
  • Knowledge of job scheduling software tool
  • Knowledge in higher education information technology support 

 

Conviction History

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 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 selected as a finalist, 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

CERTIFICATION:

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


ELIGIBLE LIST:

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 24 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 the document by title or job code to see which departments use the classification.



NOTE: 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.


 

REQUESTS:

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


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




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





Exam Type: PBT (Promo/Entrance)

Issued: May 18, 2018

Micki Callahan

Human Resources Director

Department of Human Resources

Recruitment ID Number: PBT-1053-084718

CCD/KDW/415.241.2356

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