Pay Transparency Act: Western University of Health Sciences is required to provide a reasonable estimate of the compensation range for this role. This range takes into account the wide range of factors that are considered in making compensation decisions including but not limited to experience, skills, knowledge, abilities, education, licensure and certifications, and other business and organizational needs. It is not typical for an individual to be offered a salary at or near the top of the range for a position. Salary offers are determined based on final candidate qualifications and experience. The full salary range for this position is defined as the Full Pay Range. The budgeted salary or hourly range that the University reasonably expects to pay for this position defined as the Expected Pay Scale. Placement within the Expected Pay Scale is determined by internal equity, and relevant qualifications.
Classification Series Details
Function Information TechnologyFamily Software Applications Classification Series Title Programmer Analyst
Full Salary Range
Minimum $36.74Maximum $41.19
Expected Pay Scale
Minimum $36.74Maximum $39.29
Posting Details
Posting Number S01287Position Title Programmer Analyst Position Status Full-time Campus Western University Campus-Pomona, CA Department 5601-Enterprise Applica. and Databases Job Summary
Programmer Analyst responsible for supporting all institutional activities related to the University's Enterprise Resource Planning (ERP). Proven experience in applications of database in a business environment. Interacts with users, acts as liaison between database management technical group and the functional user group. This position works with the user to evaluate project technology and application needs and assists in the specification of work and resource requirements.
Knowledge, Skills and Abilities
Individuals must possess knowledge, skills and abilities or be able to explain and demonstrate that the individual can perform the essential functions of the job, with or without reasonable accommodation, using some combination of the following skills, abilities and/or qualifications:
1. Knowledge of SQL, PL/SQL, Java, HTML, PhP, Javascript, Angular JS, React, Ajax, CSS, ProC, XML, API's PowerShell, and iPaaS.
2. Thorough knowledge of Oracle Functionality and PL/SQL syntaxes.
3. Knowledge of database concepts including entity relationship diagrams, data flows, and data normalization.
4. Experience with the Linux environment and working knowledge of Linux tools.
5. Experience with IDE Tools such as Eclipse and SQL Developer or similar tools to develop reports and web applications.
6. Experience with reporting tools such as Cognos, PowerBI, and Tableau.
7. Excellent troubleshooting, problem solving, and logic skills.
8. A team player with good communication skills.
Required Qualifications
1. Education: Bachelor's degree in any information systems-related field such as Computer Science, Computer Information Systems, Information Science or a related discipline or equivalent experience and/or certifications 2. Experience: 1+ years of professional experience in an application development environment or equivalent combination of education and experience.
List comments regarding work hours
Work hours will be between 8am – 5pm PST with an opportunity to work remotely/hybrid, contingent upon management agreement.
Posting Date 05/11/2023 Close Date Open Until Filled Yes Special Instructions to Applicants
Essential Job Duties
Job Duties
Create and modify PL/SQL programming scripts (e.g., Views, Functions, Procedures, Triggers, and Materialized Views) needed for maintenance, report writing, data conversion, and modification.
Percentage Of Time 15 Job Duties
Meet with users to determine reporting needs. Report writing using Oracle Reports, Cognos, PLSQL, ProC and/or other tools as required.
Percentage Of Time 15 Job Duties
Programmer will be able to work independently, be able to express the problem, have the ability to synthesize a solution; suggest an implementation and work toward resolution with minimal assistance.
Percentage Of Time 10 Job Duties
Coordinate with users and technical team to apply Patches and Upgrades to Banner software, requiring extensive knowledge of Oracle packages, triggers and stored procedures.
Percentage Of Time 10 Job Duties
Performs tasks following the project plan with completion in a prescribed timeframe.
Percentage Of Time 10 Job Duties
Research new releases, upgrades, patches, known issues, resolutions and suggestions using Ellucian Support Center and eCommunities. Assist users in troubleshooting Banner and BanWeb Self-Service related problems.
Percentage Of Time 10 Job Duties
Programming with PLSQL, Java, JavaScript, PROC, PROCOBOL, and other programming languages as required.
Percentage Of Time 15 Job Duties
Work with 3rd party vendors to integrate with the Banner ERP.
Percentage Of Time 10 Job Duties
Performs other related IT duties as necessary.
Percentage Of Time 5
Physical DemandsPhysical Demands
Do the essential functions of this job require lifting? NoIf yes, list maximum weight and duration
The physical demands described here are representative of those that must be met by any employee to successfully perform the essential functions of this job. Reasonable accommodations may be available to enable individuals with disabilities to perform the essential functions.
While performing the duties of this job, the employee is frequently required to use hands to operate a computer in the performance of job duties, and talk or hear. The employee is regularly required to sit, and reach with hands and arms, and occasionally required to stand, walk, stoop, and smell. Specific vision abilities required by this job include close, distance, and peripheral vision, depth perception and the ability to focus.
Describe Work Environment
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be available to enable individuals with disabilities to perform the essential functions.
Office has moderate noise level from chatter and office machines.
Applicant DocumentsRequired Documents
Optional Documents
Required fields are indicated with an asterisk ().
(Open Ended Question)
(Open Ended Question)