Systems Analyst Programmer, Senior

  • SIERRA JOINT COMMUNITY COLLEGE DISTRICT
  • Rocklin, California
  • Nov 11, 2021
Full Time Information Technology and Communication Services

Job Description

Description This position is responsible for all functional and technical aspects of one or more modules of an ERP system used to support and maintain the college business practices, such as Student/Instruction, Human Resources/Payroll, Finance, Financial Aid, and related regulatory compliance reports and procedures. It is also responsible for creating, modifying and maintaining customizations utilized by functional users on multiple campuses. This position is responsible for the successful transition and migration of data, interfaces and customizations to the District's ERP system. To meet these requirements, this position performs advanced analysis, development, coding, testing and documentation of software applications on multiple platforms for academic and/or business purposes, following industry-standard systems development and project management best practices. This position is responsible for all of the functions associated with project management, project liaison, data modeling, and systems development, and for providing future architectural direction of complex, multi-faceted computer systems, applications, and external interfaces on multiple platforms for academic and/or business purposes. Incumbents in this position must frequently consult with staff and coordinate projects for design and modification of ERP modules and bolt-on applications. This position provides technical support, troubleshooting and problem resolution for staff on computer applications; develops and maintains interfaces to external systems; creates, maintains and modifies applications for an evolving business environment and in support of critical functions and operations.
Examples Of Functions and Tasks REPRESENTATIVE DUTIES - The following duties are typical for this classification. Incumbents may not perform all of the listed duties and/or may be required to perform additional or different duties from those set forth below to address business needs and changing business practices.
  1. Serves as a leader for projects by coordinating and otherwise involving staff members from multiple organizational units; follows systems development life-cycle techniques, utilizes joint application development processes, employs project management techniques and is knowledgeable about specialized software packages and applications.
  2. Troubleshoots application errors; isolates problems from symptoms, determines alternatives and develops and implements solutions; works with user community to improve user instructions and training for greater understanding of application functionality.
  3. Defines the scope and objectives for applications, along with constraints and system requirements; analyzes and defines current organizational functions, processes, sources and uses of information, and other data to determine application needs and requirements.
  4. Analyzes user business processes and designs applications and solutions to optimize their use of systems; documents work and information flow using organization and data flow charts and other related materials; designs and produces application design specifications and documentation on inputs, outputs, and data structures.
  5. Designs inputs, including data entry screens, scanner forms and files; designs outputs, including reports, files, and display screens; designs, develops, and implements logical and physical database structures and corresponding internal relationships.
  6. Programs and modifies in-house and third party applications by creating and editing .css, HTML, JavaScript, groovy and related files to meet specifications provided by web designers.
  7. Designs, codes, tests, and maintains application software on ERP administrative systems, sub systems within networked platforms and integrated data management packages that supports the District's business and instructional processes; consults with users on applications and data requirements.
  8. Coordinates and guides the work of project team member in converting or integrating applications among platforms; installs, integrates, tests, and tunes software according to test results.
  9. Coordinates and implements data conversions, integration, and transitions; develops user and system documentation; plans and conducts user training, including preparation of training materials.
  10. Provides technical support, problem resolution, and data research for end users; provides support and training for integrated data management applications.
  11. Participates in and facilitates planning and implementation of long range systems goals; researches and participates in the development of system requirements, and evaluation and selection of information systems.
  12. Establishes standard operating procedures (SOP) and provides inputs to and follows support level agreements (SLA).
  13. Conducts feasibility studies for proposed applications and prepares recommendations for customers; estimates value-added potential in enhanced service, productivity, and financial benefit.
  14. Maintains up-to-date knowledge of evolving computer technologies, including hardware, software, languages, problem solving techniques, and development tools; prepares periodic briefings on technologies that would have relevance to the District.
  15. Coordinates with vendors and users to integrate third party software into District systems and databases.
  16. Designs, codes, tests, and maintains data transformation services for transfer of data between the primary host system and database and auxiliary operating systems, databases, and third party applications.
  17. May train and provide work direction to assigned student workers and temporary help as assigned.
  18. Performs related duties as required.
QUALIFICATIONS - The following generally describes the knowledge and ability required to enter the job and/or be learned within a short period of time in order to successfully perform the assigned duties.
Knowledge of:
  • ERP systems such as Ellucian Banner with Linux operating system.
  • Programming languages used by the District such as PL/SQL, SQL*Plus, Oracle Forms, Java, css, JavaScript, MySQL, Perl, HTML, HTTP, APIs and Web Services
  • Program development techniques, procedures, tools, documentation requirements, and System Development Life Cycles (SDLC).
  • Complex principles and procedures of computer systems, including analysis and design.
  • Relational database concepts, design techniques, and tools.
  • Computer file methods, structured testing techniques, with object-oriented software development techniques and tools.
  • Problem solving and analytical skills.
  • Complex software applications, operating systems, hardware, telecommunications, and networking principles
  • Interpersonal skills to facilitate small group processes, conduct training, provide technical support, and apply understandable lines of questioning when trying to understand department needs or problems.
Ability to:
  • Analyze technical problems and to develop and apply appropriate solutions.
  • Evaluate user interfaces for compliance with accessibility standards and principles.
  • Identify resources necessary to provide any information and assistance required to complete tasks.
  • Develop and implement project plans leading the successful, on-time completion of tasks.
  • Conduct information interviews through individual conferences and group processes, and then translate user requirements into computer programs and systems.
  • Coordinate systems development functions and steps and follow logical progressions for programming systems.
  • Design, program, install, and maintain programs for original and purchased applications and systems, including databases.
  • Design Database schemas and analyze relational database tables, triggers, and procedures
  • Use entity relationship (ER) and data modeling tools to document designs.
  • Provide training to online users in use of computer equipment and operating procedures and communicate technical and complex information to non-technical users.
  • Read, understand and apply information from technical manuals and education code regulations.
  • Adapt to changing technologies and learn functionality of new equipment and systems.
  • Prioritize work in order to meet deadlines and schedules.
  • Communicate clearly and concisely, both orally and in writing.
  • Establish and maintain effective working relationships with those contacted in the course of work.
  • Operate a variety of computer terminals, printers, and peripheral equipment.

Minimum Qualifications Education and Experience Guidelines - Any combination of education and experience that would likely provide the required knowledge and abilities is qualifying. Examples of ways to obtain the knowledge and abilities would be: Education/Training:
Bachelors Degree or 4 years of college with major course work in computer science or a related field.
Experience:
Nine years of increasingly responsible analysis and programming experience. A Bachelor's degree in computer science or related field may be substituted for four years of related experience.
License or Certificate:
Possession of a valid California driver's license.

PHYSICAL DEMANDS AND WORKING ENVIRONMENT - The conditions herein are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential job functions. Environment: Work is performed primarily in a standard office setting.
Physical: Primary functions require sufficient physical ability and mobility to work in an office setting; to stand or sit for prolonged periods of time; to occasionally walk, stoop, bend, kneel, crouch, reach, and twist; to lift, carry, push, and/or pull light to moderate amounts of weight; to operate office equipment requiring repetitive hand movement and fine coordination including use of a computer keyboard; and to verbally communicate to exchange information.
Vision: See in the normal visual range with or without correction.
Hearing: Hear in the normal audio range with or without correction.

Supplemental Information Sierra College is a Community College located near Sacramento, California where a heavy emphasis is placed on academic excellence and student success. Since its founding in 1936, Sierra College has focused on quality instruction and meeting the evolving needs of the students and communities that it serves. The Sierra Community College District covers more than 3,200 square miles and serves the Northern California foothill counties of Placer and Nevada, as well as parts of El Dorado and Sacramento. We serve over 18,000 students throughout the region in both on-ground and online courses, including students at our main Rocklin Campus as well as at three centers located in Grass Valley, Tahoe/Truckee, and Roseville. Our District prides itself on academic excellence, having been named an Aspen Prize for College Excellence eligible institution for 2019.

Sierra College has a strong commitment to the achievement of equity and inclusion among its faculty, staff, and students and values the rich, diverse backgrounds that make up the campus community. A strong candidate for this position must demonstrate a profound understanding of and experience with successfully supporting individuals with varying backgrounds. This includes persons with disabilities, various gender identities and sexual orientations, as well as individuals from historically underrepresented communities and other groups. Our District is committed to providing strategies for success and proactive student-centered practices and policies focused on eliminating equity gaps to ensure the District provides an inclusive educational and employment environment focused on strategies for success and equitable outcomes for all.

As an institution, Sierra College is committed to eliminating the equity gap in all student populations with dynamic, learner-centered practices and policies that fully engage the college community. The ideal candidate will share the College's commitment to helping its racially and socioeconomically diverse students succeed in their degree and career objectives. Currently, Sierra College enrolls 18,300 students per term, where approximately: 21% of Sierra College's students are Latin(o)(a)(x)(e), 3% are African-American, 3% are Filipino, 6% are Asian-American, 1% are Native American, 1% are Pacific Islander, 7% are multiracial and 57% are White.

The successful candidate will join a College dedicated to the use of culturally responsive strategies and methods that meet the varying needs of our students, faculty, staff, and surrounding community. Sierra College demonstrates its commitment to equity by supporting ongoing professional development for students, faculty, and staff. These opportunities include trainings and workshops on equity and inclusion, SC4 (Sierra College Community, Creativity, Culture, and Collaboration Training), active Academic Senate standing committees concerned with student success and equity, a Presidential Equity Advisory Committee (PEAC), culturally responsive student engagement centers, support for our undocumented and AB540 students, campus-wide equity summits, a robust set of programs, events, and conferences related to equity-mindedness and supporting the success of our diverse students.

Need Help With Your Online Account?
  • Use the online Help Guide or contact the NEOGOV Applicants Support Line at 855-524-5627 if you need assistance with your online applicant account.
  • Applicant Support is available between 6 a.m. and 5 p.m. Pacific Time, Monday through Friday.

REQUIRED APPLICATION DOCUMENTS:
  1. A Sierra College application,
  2. A resume, and
  3. A cover letter of no more than 4 pages that addresses:
    • Please describe the transferable experience, knowledge, skills and abilities you possess to serve in this role.
    • What culturally-inclusive/equity-minded practices/strategies would you incorporate into this role?
    • Please describe your evidence of the responsiveness to and understanding of the racial, socioeconomic, and cultural diversity within the community college student population, including students with different ability statuses (e.g., physical and/or learning), sexual orientations, gender identity and expressions as these factors relate to the need for equity-minded practices within the classroom and in the campus community.
Given the current pandemic in our country, interviews will likely take place virtually via Zoom or a conference call.

TRAVEL EXPENSES BORNE BY THE CANDIDATE (if in person interviews)

Other terms and conditions of employment are specified in the applicable collective bargaining agreements on file in the District Human Resources Department. Position description of record on file in the Human Resources Department.

*Sierra Community College District currently operates campuses in Rocklin, Roseville, Truckee and Grass Valley. In its management of a multi-campus environment, the District reserves right of assignment including the right to change assignment locations and shift assignments based on District need. Although this position may currently reside at the Rocklin campus, the assignment location may be subject to change as needed. Additionally, the district reserves the right to cancel, revise or re-announce this position as well as any and all positions at any time.

EEO/TITLE IX EMPLOYER
Sierra College is an equal employment opportunity employer committed to nondiscrimination and the achievement of diversity and equity among its faculty, staff, and students.

Persons with inquiries about the application of Title IX and/or EEO may contact the Director of Diversity, EEO & Title IX (Title IX Coordinator) at the address below, at (916) 660-7006 or via email at EEOT9@sierracollege.edu.

Persons with questions regarding reasonable accommodation of physical and other disabilities should contact the Sierra College Human Resources Department at (916) 660-7105.

If you have limitations hearing or speaking, the State of California offers a specially-trained Communications Assistant (CA) that can relay telephone conversations for all of your calls. Dial 711 to reach the California Relay Service (CRS). Dialing 711 is for everyone, not just those who have difficulty hearing on a standard phone. If you prefer having your calls immediately answered in your mode of communication, dial one of the toll-free modality and language-specific numbers below. The call will be routed to the CRS provider.

TTY/VCO/HCO to Voice
English 1-800-735-2929
Spanish 1-800-855-3000

Voice to TTY/VCO/HCO
English 1-800-735-2922
Spanish 1-800-855-3000

From or to Speech-to- Speech
English & Spanish 1-800-854-7784


Closing Date/Time: Continuous

Job Address

Rocklin, California United States View Map