IS Business Analyst-Principal, City College of San Francisco (1054)

Company Description 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. Appointment Type & Position Details APPOINTMENT TYPE: One (1) Temporary Provisional (TPV), Full time, full year position. This is a Temporary Provisional (TPV) position excluded by the Charter from the competitive Civil Service examination process. It is considered "at will" and shall serve at the discretion of the Department Head. This position will be subject to the Permanent Civil Service examination process at a later date. Successful participation in the Permanent Civil Service examination and selection through an open competitive process is needed in order to be considered for the permanent appointment. SPECIAL CONDITION: Recent and verifiable experience utilizing BANNER Software, such as BANNER accounting modules to analyze financial aid budgets; balance accounting books for each financial aid program such as financial aid grants, work study grants, board of governor's grant, student loans, CalWORKS/TANF, other sources of matching funds (HSA Dept.), credit and non-credit financial aid programs, Federal Work Study budget for entire college and yearly FISAP report through Banner. Salary Range (Steps 1-5): $65.8393 - $83.0712/hourly; $136,946 - $172,788/annually. The position's salary placement shall be at the entrance salary step, except as otherwise provided in the SEIU Local 1021 collective bargaining agreement. Department: Admissions and Records Dean's Office Location: Ocean Campus and other District Campus Centers Note: This position is not a remote work position and requires an office presence. Job Description Under the general direction of the Dean of Enrollment Services or designee, serves as the technical authority for one or more related specialties within Admissions & Records; assumes technical responsibility for the completion of projects; performs or oversees all or most of the systems development life cycle and ongoing administration functions and area operations, 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; directs and participates in complex studies. Essential Job Duties and Responsibilities Administers applications and operations for functional areas of the college (e.g. finance, human resources, student, financial aid, etc.) for the purpose of ensuring availability of services to authorized users. Designs a variety of programs to functional area software applications (e.g. reports, queries, software interfaces, etc.) for the purpose of ensuring effective and efficient use of the acquired software applications. Maintains software applications for functional areas of the college (e.g. business applications, student records software, software upgrades, interface scripts, report generation, etc.) for the purpose of ensuring efficient operations under the college’s standards. Manages assigned projects and program components (e.g. applications interfaces, updated applications software, etc.) for the purpose of delivering services in compliance with established guidelines and objectives. Participates in a variety of planning and development activities (e.g. long-term plans, required updates, new applications, etc.) for the purpose of providing information to support web needs and requirements for the college. Prepares written materials (e.g. procedures, system level documentation, reports, etc.) for the purpose of documenting activities, providing written reference, and conveying information. Recommends equipment, supplies, and materials (e.g. applications software that meets system requirements, migration to updated software, etc.) for the purpose of acquiring required items and completing jobs efficiently. Researches a variety of work-related topics (e.g. trends, products, equipment, tests, etc.) for the purpose of acting as a subject matter expert resource and recommending procedures and purchases. Responds to inquiries from a variety of sources (e.g. staff, administrators, college personnel, outside vendors, service providers, etc.) for the purpose of providing technical assistance and support. Troubleshoots malfunctions (e.g. incorrect information generated from queries, software bugs, etc.) for the purpose of resolving operational issues and restoring services. Performs other related duties as assigned for the purpose of ensuring the efficient and effective functioning of the work unit. Note: Please note the duties specified above are representative of the range of duties assigned to the 1054 IS Business Analyst-Principal class code and not intended to be an inclusive list. Qualifications Special Condition: Recent and verifiable experience utilizing BANNER Software, such as BANNER accounting modules to analyze financial aid budgets; balance accounting books for each financial aid program such as financial aid grants, work study grants, board of governor's grant, student loans, CalWORKS/TANF, other sources of matching funds (HSA Dept.), credit and non-credit financial aid programs, Federal Work Study budget for entire college and yearly FISAP report through Banner. An associate degree in business administration, public administration, information systems, economics, finance, 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 one of the fields above or a closely-related field]. Experience: Five (5) years of experience in the information systems field, including system analysis, business process design, development and implementation of business application solutions or IT project management. 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 one of the fields above or a closely related field. Completion of the 1010 Information Systems Trainee Program may be substituted for the required degree. Desirable Qualifications Knowledge and experience working with Ellucian Banner Student Information System or other higher education SIS. Experience in higher education information technology support. Strong SQL language programming and query optimization skills. Strong problem solving skills Knowledge and experience working with Oracle Database Server. Knowledge and experience working with Evisions Argos Reporting platform. Knowledge and experience working with Appworx/Automic process automation tool. Strong analytical skills. Strong interpersonal communication skills. Strong oral and written communication skills and documentation skills. Good team player. Has the ability to train end users. Benefits New employees hired on or after October 1, 2013 will contribute 2% of salary to the San Francisco Retiree Health Care Trust Fund (RHCTF). 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 designated days designated as Spring Break will not be paid for these days off. 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 Human Resources Department at View email address on click.appcast.io. ADA Statement Applicants who require a reasonable accommodation to participate in this hiring process should contact the Human Resources Department at View email address on click.appcast.io to make the necessary arrangements. Please be aware that verification of a covered disability under the ADA may be required. 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. #J-18808-Ljbffr City and County of San Francisco