Software Analyst Programmer

Position Details

Position Information

Position Title
Software Analyst Programmer

Classification Title
Administrator

Grade Level
26

Starting Wage/Salary
$67,340 - $78,000/yr plus exceptional benefits

Revision Date
09/01/2023

Position Type/Employee Class
Administrative

FTE
1.0

Contract Months
12

Overtime Eligible
Exempt

Location
Bend

Hybrid Remote Work Eligible?
Yes but no COCC position is fully remote. Hybrid/Remote possibilities to be determined by the supervisor/department and discussed during interview process.

Exceptional COCC Benefits Summary


CLICK HERE TO VIEW BENEFITS & PERKS

Primary Purpose

The Software Analyst – Programmer is part of a team which is responsible for maintaining a portfolio of enterprise applications, including the college’s Ellucian Banner enterprise resource planning ( ERP ) platform. 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 COCC ERP system, and related enterprise applications, including those on-premise and in the cloud, through the entire product lifecycle.

Essential Duties and Responsibilities

End-User Support

• 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.
• Assist in maintaining user access to the ERP systems and other enterprise software applications.
• Regularly and independently troubleshoot and resolve technical problems.
• Consult with and assist users to define, address and resolve a wide variety of challenges from across the college.

Application Development, Maintenance & Support

• 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.
• 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.
• Participate in Enterprise Application Management ( EAM ) team projects as an analyst/programmer; projects include incorporating changes to existing functionality or implementing new functionality.
• Consistently develop, document, and maintain ITS processes and solutions.
• Perform and/or manage medium scale initiatives independently, with limited supervision.
• Concurrently troubleshoot issues while managing multiple projects through completion.
• Develop and modify interfaces to other business systems and applications as needed.
• Develop and maintain database objects, views and reports.

Department Specific

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.

• Knowledge of relational databases and programming languages, including SQL or PL/ SQL .
• Knowledge of programming principles and best practices.
• 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.
• Ability to work cooperatively with, and contribute to, a diverse workplace through ideas or experience.
• Able to develop, write, and debug software or use other tools to work with data and produce reports or other data outcomes.
• Ability to read, analyze, and interpret information technology administration guides, user manuals, professional journals, technical procedures, and/or governmental regulations.
• Excellent written communication and documentation skills.
• Experience working with third-party, cloud-based applications.
• Experience working in a help desk environment.
• Strong organizational, analytical, problem solving, time management and documentation skills.
• Ability to work with customized role- and class-based user privilege assignment on ERP system.

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.

Minimum Requirements

Education

• Associate’s Degree in a related technology field or equivalent work experience.

Experience

• Two years of professional work experience using SQL or PL/ SQL .
• One year of professional experience in software programming and development.

Equivalency Statement

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 the supplemental question presented during the application process.

Preferred Qualifications

Education

• Bachelor’s degree in Computer Science, Information Technology, or related field or an equivalency of at least three years of related work experience in lieu of a degree.

Experience

• Familiarity and/or programming experience with Ellucian’s Banner ERP .
• Proficiency working in a command-line or shell environment, such as Linux.
• 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.

EEO Statement

The goal of Central Oregon Community College is to provide an atmosphere that encourages our faculty, staff and students to realize their full potential. In support of this goal, it is the policy of Central Oregon Community College 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 or military status, pregnancy or any other classes protected under federal and state statutes in any education program, activities or employment. Persons with questions about this statement should contact Human Resources at 541.383.7216 or the Vice President for Student Affairs at 541.383.7211.

This policy covers nondiscrimination in both employment and access to educational opportunities. When brought to the attention of the appropriate parties, any such actions will be promptly and equitably responded to according to the process outlined in general procedures sections N-1, N-2, or N-3.

In support of COCC’s EEO statement, bilingual fluency in English and Spanish is considered a plus, along with experience working in a diverse multicultural setting.
Supplemental Questions

Required fields are indicated with an asterisk (*).

1. * What is your highest level of education?
   • No High School Diploma or GED
   • High School Diploma or GED
   • Professional Certification or License (not a degree)
   • 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. * As a desirable qualification, please describe your proficiency in the following: Linux command line, C, Pro*C, Java, JavaScript, Groovy, .NET, CSS, HTML and/or XML.
   
   (Open Ended Question)
   
   
5. The College recognizes the value of skills and knowledge gained outside of formal higher education and paid employment. Applicants who do not meet minimum education and/or experience requirements, but present other qualifications or experience equivalent to those required are encouraged to apply and provide an equivalency statement here. Your statement should make clear the requirement you are addressing and why you feel your education/experience is equivalent. Please be aware that applicants who do not meet the minimum requirements and do not provide an equivalency statement may not advance to the next stage of the recruitment process.
   
   (Open Ended Question)
   
   
6. In support of COCC’s commitment to diversity, equity, and inclusion, bilingual fluency in English and another language is considered a plus: Please list any languages other than English in which you are fluent (read and write)
   
   (Open Ended Question)
   
   
7. * 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
8. * 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
9. * 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 215 (215 if applicable) or certification that you expect to be honorably discharged from the military within 120 days of certifying veteran status as supporting documentation. You will have the opportunity to upload the document(s) in the next step of this application process.
   • Yes, I am a veteran
   • No, I am not a veteran
10. 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)
    
    
11. * 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

Required 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. US Military DD 214