ITS Software Analyst - Programmer



Posting Details


Posting Number: 06001864 Position Title: ITS Software Analyst - Programmer Posting Date: 06/25/2021 Closing Date: 07/25/2021 Open Until Filled (notes): Length of Position: 12 months per year Anticipated Start Date: Position Type/Employee Class: Administrative FTE: 1.0 FTE Salary Level: Administrative Salary Level 26 Starting Pay Range Maximum starting salary of $76,000 per year, based on applicant's qualifications Hours per Week: 40 hr/wk Work Schedule: Typically 8:00am - 5:00pm Days of the Week: Typically Monday - Friday Job Summary/Purpose:
The Software Analyst – Programmer will be part of a team responsible for maintaining the college’s Ellucian Banner enterprise resource planning ( ERP ) platform and other enterprise software applications. In addition, the Software Analyst – Programmer will provide technical advice and support to end-users, including; troubleshooting issues, creating reports and data extracts, and data analysis. The Software Analyst – Programmer works closely with a larger team comprised of Business Analysts, Systems Administrators and DBA’s to manage all aspects of the ERP system and related integrations for COCC .

Terms of Employment:
  • This is a 12-month exempt position at pay level 26 in the Administrative salary schedule.
  • Requires flexible work schedule, which may include evenings and/or weekends as well as travel throughout the district.
  • Requires the provision of official transcripts upon hire.
  • COCC employees must work and reside in the state of Oregon at the time their work is being performed.
  • The College is NOT able to support Visa applications for this position. Applicants must already be eligible to work in the United States to be considered for this position.
  • Upon hire, must pass criminal and/or driving history; only information relevant to the position will be considered.
Essential Functions:
End-User Support
  1. Support end-users of the Banner ERP system and other integrated, campus-wide software applications by responding to and addressing issues reported through the ITS help desk.
  2. Assist in maintaining user access to the ERP systems and other enterprise software applications.
  3. Regularly and independently troubleshoot and resolve technical problems.
  4. Consult with and assist users to define, address and resolve a wide variety of challenges from across the college.



Application Development, Maintenance & Support
  1. Perform analysis, development, integration, testing, QA, implementation, support and documentation of the college’s cloud-hosted Ellucian Banner enterprise resource planning ( ERP ) platform and other enterprise applications, both on-premise and in the cloud.
  2. Assist in management of the ERP software application including performing required/scheduled installation procedures, assigned programming activities, updating tables and rules, and troubleshooting/performing QA related to system technical problems.
  3. Participate in Enterprise Application Management ( EAM ) team projects as an analyst/programmer; projects include incorporating changes to existing functionality or implementing new functionality.
  4. Consistently develop, document, and maintain ITS processes and solutions.
  5. Perform and/or manage medium scale initiatives independently, with limited supervision.
  6. Concurrently troubleshoot issues while managing multiple projects through completion.
  7. Develop and modify interfaces to other business systems and applications as needed.
  8. Develop and maintain database views and reports.
Knowledge, Skills and Abilities:
Individual must possess the following knowledge, skills and abilities, or be able to explain and demonstrate that the individual can perform the duties and responsibilities of the job, with or without reasonable accommodation, using some other combination of skills and abilities. Individual is expected to follow all College work rules and policies.
  1. Knowledge of relational databases and programming languages, including SQL or PL/ SQL .
  2. Basic knowledge of programming principles and best practices.
  3. Possess strong interpersonal and customer service skills, including the ability to communicate technical and complex information both verbally and in writing to a variety of audiences.
  4. Ability to work cooperatively with, and contribute to, a diverse workplace through ideas or experience.
  5. Able to develop, write, and debug software or use other tools to work with data and produce reports or other data outcomes.
  6. Ability to read, analyze, and interpret information technology administration guides, user manuals, professional journals, technical procedures, and/or governmental regulations.
  7. Excellent written communication and documentation skills.
  8. Experience working with third-party, cloud-based applications.
  9. Experience working in a help desk environment.
  10. Strong organizational, analytical, problem solving, time management and documentation skills.
  11. Ability to work with customized role- and class-based user privilege assignment on ERP system
Physical Demands and Other Ergonomic Requirements:
Position typically works regular office hours, M-F, 8 am to 5 pm. A flexible work schedule, including nights and weekends, may be necessary at times due to the nature of the responsibilities and/or business requirements. Incumbent must be able to function effectively indoors in an office environment engaged in work of a primarily sedentary nature. Requires the ability to work at a workstation for extended periods. Regularly required to use hands and fingers, handle or feel objects, tools or controls, reach with hands and arms and requires near visual acuity to write, read written materials and computer screens, and sufficient hearing and speech ability for ordinary telephonic conversations. Physical movements involve guiding, feeding materials into proper position. Lifting objects vary daily, ranging from 1lb to over 25lbs. Use of computer screen is required 70% of the work time. All individuals are required to perform essential functions with or without reasonable accommodation. Equal Employment Opportunity (EEO) Statement
It is the policy of the Central Oregon Community College Board of Directors that there will be no discrimination or harassment on the basis of age, disability, sex, marital status, national origin, ethnicity, color, race, religion, sexual orientation, gender identity, genetic information, citizenship status, veteran status or any other protected classes under Federal and State statutes in any educational programs, activities or employment. Persons having questions about equal opportunity and nondiscrimination should contact the Equal Employment Officer, c/o COCC’s Human Resources office, 541.383.7216. In support of COCC’s EEO statement, employees with bilingual fluency in English and Spanish is a plus, along with experience working in a diverse multicultural setting. Minimum Qualifications:
  • Associate’s Degree in a related technology field or equivalent work experience.
  • Two years of professional work experience using SQL or PL/ SQL .
  • One year of professional experience in software programming and development.
  • One year of experience in a command-line or shell environment, such as Linux




The College recognizes the value of skills and knowledge gained outside of formal higher education and paid employment. Applicants who do not meet minimum qualifications but present other qualifications or experience equivalent to those required will be considered and are encouraged to apply. To qualify under equivalency, applicants must indicate how they qualify under equivalency by responding to supplemental questions presented during the application process. Preferred Qualifications:
  • Bachelor’s degree in Computer Science, Information Technology, or related field or an equivalency of at least three to four years of related work experience in lieu of a degree.
  • Familiarity and/or programming experience with Ellucian’s Banner ERP .
  • Proficiency in one or more of the following is a plus: Linux command line, C, Pro*C, Java, JavaScript, Groovy, . NET, CSS, HTML and/or XML .
  • Experience in creating reports from an Oracle or MS SQL database system, using a report writing application such as Argos, Cognos, or Crystal Reports is a plus.
Special Instructions to Applicants:
Note that you will be required to upload/create the required documents indicated in this posting at the time you apply. Unofficial transcripts are acceptable at application. It is the responsibility of the applicant to upload all required documents, including transcript(s). If you have questions please contact Human Resources at 541-383-7216. Is a Criminal History Check required? Yes Is a Credit History Check Required? No Open Until Filled No Supplemental Questions

Required fields are indicated with an asterisk (*).

  1. * Choose your highest level of education:
    • No High School Diploma or GED
    • High School Diploma or GED
    • Associates Degree
    • Bachelors Degree in Progress
    • Bachelors Degree
    • Masters Degree in Progress
    • Masters Degree
    • Ph.D. in Progress
    • Ph.D.
    • J.D.
    • M.D.
    • Other Doctorate Level Degree
  2. * Please describe how you meet the minimum requirement of two (2) years of professional work experience using SQL or PL/SQL.

    (Open Ended Question)

  3. * Please Describe how you meet the requirement of one (1) year of professional experience in software programming and development.

    (Open Ended Question)

  4. * Please describe how you meet the minimum requirement of One (1) year of experience in a command-line or shell environment, such as Linux.

    (Open Ended Question)

  5. * While it is a preferred qualification, please describe your familiarity and/or programming experience with the Ellucian’s Banner ERP.

    (Open Ended Question)

  6. * While it is a preferred qualification, please describe your hands-on experience in creating reports from Oracle or MS SQL database system, using report writing applications such as Argos, Cognos, or Crystal Reports.

    (Open Ended Question)

  7. * COCC employees must work and reside in the state of Oregon at the time their work is being performed. Are you, or will you be residing in the state of Oregon by the start date of this position?
    • Yes
    • No
  8. * The College is NOT able to support Visa applications for this position. Applicants must already be eligible to work in the United States to be considered for this position. Are you, or will you be eligible to work in the US by the start date of the position?
    • Yes
    • No
  9. The College recognizes the value of skills and knowledge gained outside of formal higher education and paid employment. Applicants who do not meet minimum qualifications, but present other qualifications or experience equivalent to those required will be considered and are encouraged to apply. There may be other requirements where an equivalency is acceptable. Please be aware that applicants who do not meet the minimum requirements and do not provide an equivalency statement will not be selected for an interview. Your statement should make clear the requirement you are addressing. Example: The position requires a Master’s degree. You have a Bachelor’s degree and work experience when combined you feel is equivalent to the degree requirement. Please make clear why you feel it is equivalent.

    (Open Ended Question)

  10. * Are you a U.S. military veteran? (COCC provides qualifying veterans and disabled veterans with preference in employment. To receive veterans’ preference in this recruitment process, you must upload your DD214 and DD215 (if applicable) form(s) as supporting documentation. You will have the opportunity to upload the document in the next step of this application process.)
    • Yes, I am a veteran
    • No, I am not a veteran
  11. If you have identified yourself as a qualified veteran or disabled veteran by submitting your DD214 and DD215 (if applicable) form(s) as proof of veteran status, please describe any transferable skills earned during your military service that you feel relate to the requirements/preferences of this position.

    (Open Ended Question)

  12. * Background checks are required for all employees of COCC. Should an offer of employment be made to you and accepted by you, you will receive an email from COCC / HireRight Screening requesting your consent and basic information to complete the check. The offer of employment will be conditional upon satisfactory completion of the criminal background check. Confirmed findings on a criminal background check will not automatically disqualify you from being hired into a position. Results are evaluated on a case-by-case basis, considering the job responsibilities and other risk factors. Additional information regarding COCC’s criminal history check policy can be found online in the General Procedures Manual, Section HR-2-1. Please indicate here if you will provide consent to the criminal history check when requested by the College:
    • Yes, I will provide my consent when requested
    • No, I will not provide my consent when requested
Applicant Documents
Required Documents
  1. Resume/Vitae
  2. Cover Letter
  3. College Transcript 1 (unofficial)
Optional Documents
  1. Letter of Recommendation 1
  2. Letter of Recommendation 2
  3. College Transcript 2 (unofficial)
  4. US Military DD 214
  5. Other Document 1