"Alerted.org

Company Description

IS Programmer Analyst-Principal (1064)

City College of San Francisco

50 Frida Kahlo Way, San Francisco, CA 94112, USA

Full-time

Work Hours: Regular; 40 hrs per week

Fill Type: Permanent Civil Service

Appointment Type: One (1) Permanent, full-time, full year position. This is a Position-Based Test conducted in accordance with CSC Rule 111A. This position will be subject to the Permanent Civil Service examination process. Successful participation in the Permanent Civil Service examination and selection through an open competitive process is needed in order to be considered for this permanent appointment.

Job Close Date: 4:59 PM on 7/24/2025. *Any applications and documents received after the deadline will not be taken in consideration.

Salary Range (steps 1 – 5): $57.5661 - $69.9719 hourly; $119,737.00 - $145,542.00 Annually

About:

City College of San Francisco is an urban community college with locations throughout the city. Our vision is to provide a sustainable and accessible environment where we support and encourage student possibilities by building on the vibrancy of San Francisco and where we are guided by the principles of inclusiveness, integrity, innovation, creativity, and quality. We offer an affordable opportunity for students to earn associate degrees, prepare for transfer, and pursue career and technical education. This is an exciting time at City College of San Francisco and the right person can make a major impact. Be part of positive change as we transform this dynamic institution for a successful future.

Job Description

The 1064 IS Programmer Analyst – Principal is responsible for active development and support of the Enterprise Applications suite for use by the San Francisco Community College District, including but not limited to Ellucian Banner ERP, Salesforce, modern web applications from database to user interface, cloud-based platforms that enable application design, development, testing, and distribution.

Incumbent will play an active role in defining the direction of the product. They will share responsibility in designing, enhancing and developing the next-gen framework, and will be responsible for understanding and contributing towards the transition of our ever growing eco-system of partners and their customers from the old to the new.

Under direction of the IS Manager, provide design, development, troubleshooting and debugging services for databases software programs, enterprise applications, tools, networks etc. Incumbent will analyze computer data to deliver basis for decision-making information; determine data integrity; develop computer software applications to provide data analysis function and reports for institutional use. Incumbent will design, develop, test and implement system programs and database level programming scripts, analyze ERP system for a variety of institutional needs and provide solution alternatives; will research, write and maintain end user documentation to support programs and operational/business procedures; will provide solution expertise and consultation services to college administration, classified staff, and faculty.

Essential Job Duties and Responsibilities:

1. Architect, design, program, maintain, and troubleshoot new and existing programs and data structures to meet end user needs; provide for proper maintenance of implemented programs.

2. Lead design of complex enterprise applications deployments to align with user business processes; able to work with customers and vendors to implement system functionality based on business needs, propose and discuss alternative approaches to resolving non-trivial issues; ensure improvement of all architectural processes within time frame, maintain projects deliverables with focus on costs reduction.

3. Serve as level 3 escalation for operational support, help streamline operations; assure file conversion and cross-operating platform file manipulation as appropriately setup and monitored

4. Participate in planning and support of Ellucian Banner modules regular patches and upgrades, primarily Student, General, Self-Service, Financial, Payroll, and other modules as required.

5. Work with Ellucian Banner and other systems: Evisions Argos, FormFusion & IntelleCheck, SF Health Service systems (SFERS), Broadcom Automic, CurriQNet, ExLibris, DegreeWorks, Heartland payment gateway, Nelnet tuition payment system, Follett Bookstore, CCCApply, Comevo, NextGen Dynamic Forms, ConexEd, SignalVine, Socure, Microsoft Tools and other applications, to ensure error free interface between 3rd party software/systems and Ellucian Banner.

6. Coordinate system-related development activities within ITS and with other CCSF departments in multi-departmental system projects. Design and implement various strategies for a Service Oriented Architecture. Proficient in implementing reliable, complex, secure, high performance and scalable solutions from Manufacturing to production.

7. Prepare functional/technical specifications and represent department in RFI’s and RFP’s. Review existing systems, perform gap analysis and define requirements to address the gaps. Review efficiency of latest software and analyze potential solutions to ensure future needs are met.

8. Write code and modify programs running on Linux, Cloud and Windows environments, develop web-based programs/scripts using applicable programming languages; code user interface applications for data collection and queries; code analytical and statistical applications; assure data integrity for interdepartmental reporting procedures.

9. Responsible for configuration management and documentation of application and system topologies. Create and enable business process flows; Identify and Implement workflows. Prepare technical implementation plans and provide integrated solutions including actions, milestones timelines, and critical paths required for complete solutions. Write and maintain Ellucian Banner system operations documentation for end users and operator, and provide training as needed; assure documentation contains steps to initiate programs and routines to remedy interruptions in program runs.

10. Test, debug and evaluate Ellucian Banner system performance; identify and rectify potential program failures. Monitor appropriate allocation of all resources.

11. Design and maintain database and file structures used by the Ellucian Banner system; establish, link, join, and relate data within tables via scripts; maintain flow charts or narrative description of program flow, purpose, and operation; examine output data from program operations to verify and assure accuracy and completeness of data.

12. Maintain contact with end users from various departments to discuss and analyze Ellucian Banner system performance and efficiency; consult with end users to discuss desired system data output and user expectation; respond to diversified questions and issues from faculty and staff concerning Ellucian Banner system processes and business practices.

13. Conduct and attend meetings with consultants, ITS staff, administrators, and other staff as needed; Consult with Information Technology Services staff regarding system design, problems and developments, and other related matters.

14. Maintain current knowledge of developments, issues, and advancements in data processing equipment, software, and programming.

15. Detect, analyze, and define custom programming needs for various organizations in the College; collect, process, and employ end user inputs, information, or other data to determine Ellucian Banner system needs and requirements.

16. Participate in 24×7×365 rotation with the other IT Analysts.

17. Performs other related duties as assigned.

MINIMUM QUALIFICATIONS

These minimum qualifications establish the education, training, experience, special skills and/or license(s) which are required for employment in the classification.

Education: An associate degree in computer science or 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: Five (5) years of experience in applications or software programming or development.

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 or forty-five (45) quarter units with a minimum of 10 semester / 15 quarter units in computer science or a closely related field.

SUPPLEMENTAL INFORMATION

Essential duties require the following physical skills and work requirements: Some positions may require sufficient strength and coordination for lifting, pushing, pulling and/or carrying the weight of computer equipment. May require hand/eye coordination and manual dexterity for data entry. May involve extensive VDT exposure.

Notes on Qualifying Experience and Education: One year of full-time employment is equivalent to 2000 hours. (2000 hours of qualifying work experience is based on a 40-hour work week.) Any overtime hours that you work above forty (40) hours per week are not included in the calculation to determine full-time employment.

Desirable Qualifications:

+ Experience with Banner ERP system.

+ Experience building cloud-based platforms that enable application design, development, testing, and distribution in one or more of the following: Ellucian Experience, Ethos, OCI, AWS, Azure.

+ Experience with developing Application Programming Interfaces (APIs).

+ Experience with developing and supporting web-based application tools.

+ Mastery of SQL, PL/SQL, Oracle Database, SQL Developer and/or other IDE Tools.

+ Experience with CRM applications (Salesforce).

+ Experience working in a higher education environment.

+ Strong understanding of RDBMS concepts.

+ Advanced knowledge of the principles and practices of systems and applications programming, and best practices for quality software development.

+ Experience in identifying complex problems and review related information to develop and evaluate options and implement solutions.

+ Knowledge of Argos, IntelleCheck, FormFusion, Unix/Linux shell scripts, VI, Pro C, HTML, Python, Java, JavaScript, JSON, Eclipse, Groovy & Grails, Pagebuilder, Banner Workflow, Banner Communications Management, COBOL and/or APEX.

+ Familiarity with SFTP, TCP/IP, HTTPS and other Web-based protocols and programs; TLS and SSH for Windows and Unix/Linux platforms.

+ Knowledge of methods and techniques of database analysis and design.

+ Knowledge of one or more development methodologies – Agile, Scrum, Kanban.

+ Any professional certifications are a plus.

+ Strong analytical, interpersonal, communication, and documentation skills.

+ Highly motivated, reliable, responsible, dependable, good team player.

HOW TO APPLY

Applications for City and County of San Francisco jobs are only accepted through an online process.

Visit (enter job link in SR) and begin the application process.

•       Select the “Apply Now” button and follow instructions on the screen.

Your application MUST include all the following documents.  To upload these items, please use the "Additional attachments" function within the application process.

+ Cover letter expressing your interest in the position, specifically indicating how you meet the Minimum and Desirable Qualifications as listed in this announcement.

+ Current Resume

+ Verification of Education (A complete copy of Academic Transcripts or Diploma)

Verification of Education: Verification of qualifying education must include copies of transcripts, diplomas, or certificates posting your degree(s) and major(s). if verification can’t be obtained, the applicant must submit a signed statement with the application explaining why such verification can’t be obtained.

Request for waiver will be considered on a case-by-case basis. Foreign degrees/coursework use as qualifying to meet the minimum qualifications must be evaluated by the foreign degree evaluation services organization, before an application can be processed. please contact the CCSF Human Resources Department at (415)452-7660 for evaluation sources. Failure to submit the required verification of request a waiver with the application will result in rejection of the application.

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

Verification of experience may be waived if impossible to obtain. the applicant must submit a signed statement with the application explaining why verification can’t be obtained. waiver requests 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 rejection of application.

Additional Information

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.

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.

Resumes will not be accepted in lieu of a completed City and County of San Francisco application through Smart Recruiters.

Applications completed improperly may be cause for ineligibility, disqualification or may lead to lower scores.

Applicants may be contacted by email about this recruitment 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, @ccsf.edu, @sfdpw.org, @sfport.com, @flysfo.com, @sfwater.org, @sfdph.org, @asianart.org, @sfmta.com, @sfpl.org, @dcyf.org, @first5sf.org, @famsf.org, @ccsf.edu, @smartalerts.info, and @smartrecruiters.com).

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.

SELECTION PROCEDURES

After application submission, candidates deemed qualified must complete all subsequent steps to advance in this selection process, which includes the following:

BEHAVIORAL CONSISTENCY QUESTIONNAIRE OR BCQ (WEIGHT: 40%): Applicants that meet the minimum qualification for this recruitment will be sent additional instructions to complete and submit a Behavioral Consistency Questionnaire by a specific deadline established by CCD. The purpose of the BCQ Examination 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:

+ Advanced knowledge of applicable software programs to provide programing support for departments

+ Advanced ability to interpret and convey complex technical requirements to non-technical users to aid understanding for end users

+ Strong ability to listen and understand end-user provided requirements in the development of programs to support operational needs for departments

+ Strong skills to identify complex problems to develop and evaluate solutions

+ Advanced knowledge of writing source codes to test, debug and implement System programs

+ Strong skills to troubleshoot the cause of system errors and program failures to remedy interruptions to the environment

The information provided in the BCQ must be consistent with the applicant’s information on the application, resume and/or academic records. Once submitted, applicant responses on the Behavioral Consistency Questionnaire cannot be changed. Every element is subject to verification.

ORAL EXAMINATION (Weight: 60%): Only applicants meeting the minimum qualifications that achieve a passing score on the Behavioral Consistency Questionnaire will be invited to participate in the oral examination designed to assess their relative knowledge, skills and abilities in job-related areas, which may include, but not be limited to:

+ Intermediate knowledge of ERP systems to facilitate operational business procedures

+ Advanced knowledge of applicable software programs to provide programing support for departments

+ Advanced ability to interpret and convey complex technical requirements to non-technical users to aid understanding for end users

+ Strong ability to listen and understand end-user provided requirements in the development of programs to support operational needs for departments

+ Ability to remain current on technology advancements while maintaining legacy technologies to sustain a proper system functionality

+ Strong skills to identify complex problems to develop and evaluate solutions

+ Advanced knowledge of writing source codes to test, debug and implement System programs

+ Strong skills to troubleshoot the cause of system errors and program failures to remedy interruptions to the environment

Applicants meeting the minimum qualifications are not guaranteed an invitation to interview. Qualified applicants who are selected for an interview will be notified of the exact date and time.

Note: Candidates must achieve a passing score on every examination component (Behavioral Consistency Questionnaire and Oral Examination) listed in this recruitment in order to be ranked on the Eligible List/Score Report.

The department may administer additional position-specific selection procedures 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. If you wish to learn more please visit: Information about the Hiring Process (https://sfdhr.org/information-about-hiring-process) .

The duration of the eligible list resulting from this examination process will be of twelve (12) months, and may be extended with the approval of the Human Resources Director.

To find Departments which use this classification, please see:

https://sfdhr.org/sites/default/files/documents/Forms-Documents/Position-Counts-by-Job-Codes-and-Department-FY-2023-24.pdf

Certification: The certification rule for the confidential eligible list resulting from this examination will be the Rule of 10.

Terms of Announcement and Appeal Rights: This is a Position Based Test (PBT) administered in accordance with Civil Service Rule 111A. 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 https://careers.smartrecruiters.com/CityAndCountyOfSanFrancisco1/.

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.

Additional information regarding Employment with the City and County of San Francisco:

+ Information about the Hiring Process (https://sfdhr.org/information-about-hiring-process)

+ Conviction History (https://sfdhr.org/conviction-history-faq)

+ Employee Benefits Overview (https://sfdhr.org/benefits-overview)

+ Equal Employment Opportunity (https://sfdhr.org/equal-employment-opportunity)

+ Disaster Service Workers (https://sfdhr.org/disaster-service-workers)

+ Reasonable Accommodation

+ Right to Work (https://sfdhr.org/information-about-hiring-process#identification)

+ Copies of Application Documents

+ Diversity Statement (https://sfdhr.org/information-about-hiring-process#diversitystatement)

+ Veterans Preference

+ Seniority Credit in Promotional Exams (https://sfdhr.org/information-about-hiring-process#senioritycredit)

Benefits:

1.  Additional Days Off with Pay. As stipulated in the appropriate bargaining agreements and board resolutions, Classified employees working full-year (260 days/year) work schedules are granted, as paid days off, the days between Christmas Day and New Year’s Day, as well as an additional five (5) paid days off during spring break. Eligible school-term-only (STO) employees who are not scheduled to work the designated days between Christmas and New Year’s Day shall be granted three (3) paid days off to be scheduled by mutual agreement between the employee and supervisor. Eligible school- term-only (STO) employees who are not scheduled to work the days designated as Spring Break will not be paid for these days off.

2.  New employees hired on or after October 1, 2013 will contribute 2% of salary to the San Francisco Retiree Health Care Trust Fund (RHCTF).

Contact: If you have questions regarding this recruitment or application process, please contact Eddie Aguirre, City College of San Francisco, Human Resources Classified Unit, by email at [email protected].

ADA Statement: Applicants who require a reasonable accommodation to participate in this hiring process should contact the Title 5/EEO/ADA Compliance Officer at 415/452-5053 to make the necessary arrangements. Please be aware that verification of a covered disability under the ADA may be required.

EEO Statement: It is the policy of the City College of San Francisco to provide all persons with equal employment and educational opportunities regardless of race, color, ancestry, national origin, ethnic group identification, religion, age, gender, marital status, domestic partner status, sexual orientation, disability or AIDS/HIV status, medical conditions, gender identity, or status as a Vietnam-Era veteran. These categories specifically include status as a lesbian, gay, bisexual, transgender, or questioning person in any District program or activity. For further information, contact the Title 5/EEO/ADA Compliance Officer at (415) 452-5053.

The City and County of San Francisco encourages women, minorities and persons with disabilities to apply. Applicants will be considered regardless of their sex, race, age, religion, color, national origin, ancestry, physical disability, mental disability, medical condition (associated with cancer, a history of cancer, or genetic characteristics), HIV/AIDS status, genetic information, marital status, sexual orientation, gender, gender identity, gender expression, military and veteran status, or other protected category under the law.

The City and County of San Francisco encourages women, minorities and persons with disabilities to apply. Applicants will be considered regardless of their sex, race, age, religion, color, national origin, ancestry, physical disability, mental disability, medical condition (associated with cancer, a history of cancer, or genetic characteristics), HIV/AIDS status, genetic information, marital status, sexual orientation, gender, gender identity, gender expression, military and veteran status, or other protected category under the law.