Programmer Analyst

Western University of Health Sciences; Pomona (CA); On-site; USD 103,320,000 - 117,096,000; Full time

Job summary

Western University of Health Sciences in Pomona, CA seeks a Programmer Analyst IRE to manage information systems for the Institutional Research and Effectiveness office. You will design and manage databases, extract data from university systems, develop queries and reports, and support data collection.

This role focuses on creating data-driven studies to support university decision-making, streamline reporting, and improve data integrity across the campus.

Qualifications

• 3–5 years of experience in a similar position, or combination of academic and work experience.
• Experience with Oracle or similar relational database management systems.
• Experience with developing executive dashboards.
• Experience working with APIs, JSON, or web services.

Responsibilities

• Create and modify SQL programming scripts, views, materialized views, procedures etc. for maintenance, report writing, data extracts, and application development.
• Meet with users to determine data and reporting requirements. Report writing using various systems and tools, including but not limited to Power BI, Banner Operational Data Store, PL/ SQL Developer,and IBM Cognos.
• Design, test, implement and maintain web applications.
• Support and enhance outcomes assessment, institutional accreditation, and internal and external reporting functions of the IRE office to support university decision-making.
• Handle service requests submitted to IRE.
• Perform other duties as necessary.

Skills

SQL development

Oracle RDBMS

Data modeling

Web analytics

Report development

Education

Bachelor’s degree in computer information systems, Business Information Systems, or Computer Science

Tools

Power BI

Banner ODS

PL/SQL Developer

IBM Cognos

APIs/JSON

Job description

As you take your first step onto a Western University of Health Sciences campus, each path, each person, each structure comes with a transformative story. WesternU is more than the practice of medicine. We are defined by character and culture.
At WesternU, you will discover humanism at the heart of every interaction: a warm welcome, a sincere smile, a positive word, a kind deed, a thoughtful gesture. You will see students work together on case studies; a parade of pets in campus parks; student clubs offering opportunities for career growth and community involvement; and faculty, staff and students designing their future and the future of WesternU. We display a collaborative mindset in how we operate, educate, and serve others.
Although, geographically, we are two campuses - as humanists, we are one: to enhance and extend the quality of life in our communities and achieve excellence in everything we do. We attract diverse, professional faculty, staff and students that thrive in an environment of humanistic health care education. Join our team of faculty and staff and make a difference.

Position Title

Position Control Number

Position Control Number S04990

Type of Position

Staff

Position Status

Full-time

Campus

Western University Campus-Pomona, CA

Position Location

California

Department

3002-Institutional Research and Effectiveness - IRE

Job Summary

Under the general direction of Associate Vice Provost for Institutional Research and Effectiveness ( IRE ), the Programmer Analyst will manage information systems for IRE . The position will design and manage databases, extract data from university information systems, develop queries and reports, design web sites, and support data collection. This position will develop specialized research datasets in response to queries from university leadership. This position supports IRE’s core activity of capturing, analyzing and interpreting data on academic programs, students, faculty, staff and other vital information for university decision-making. The Programmer Analyst will play a key role in efforts to streamline reporting and improve data integrity across the university, providing timely and useful studies.

Knowledge of:

• Advanced knowledge of SQL with at least 2+ years of Oracle development.
• Oracle RDBMS with an understanding of the Oracle architecture, structures, and functionality.
• Database concepts, including entity relationship diagrams, data flows, and data normalization.
• Advanced knowledge of gathering and analyzing business requirements for web application design and development.
• Web technology, including web performance analysis and load testing.
• Report development concepts, tools, and best practices for creating effective data-driven reports and dashboards.

Skill:

• Strong interpersonal and communication skills, with the ability to collaborate effectively as part of a team.
• Excellent problem solving and logic skills with the ability to work independently.
• Exceptional attention to detail and commitment to data integrity.
• Strong work ethic.

Ability to:

• Stay current with evolving database technologies, enterprise applications, cloud services, business intelligence tools, and higher education technology trends through continuous learning and professional development.
• Stand and/or sit and continuously perform essential job.
• Demonstrate a commitment to working in an organization that values and promotes humanism.

Education:

• Bachelor’s degree in computer information systems, Business Information Systems, or Computer Science, or related field from an accredited academic institution.

Experience or Training:

• 3-5 years of experience in a similar position, or combination of academic and work experience.
• Experience with Oracle or similar relational database management systems.
• Experience with developing executive dashboards.
• Experience working with APIs, JSON , or web services.

Special Requirements, Licenses, and Certifications:

• Ability to travel for work-related meetings, training, conferences or events as needed.

Preferred Qualifications

Experience:

• Experience with Microsoft 365 technologies.

Key Responsibilities

• Create and modify SQL programming scripts, views, materialized views, procedures etc. needed for maintenance, report writing, data extracts, and application development.
• Meet with users to determine data and reporting requirements. Report writing using various systems and tools, including but not limited to Power BI, Banner Operational Data Store, PL/ SQL Developer,and IBM Cognos.
• Design, test, implement and maintain web applications.
• Support and enhance outcomes assessment, institutional accreditation, and internal and external reporting functions of the IRE office to support university decision-making.
• Handle service requests submitted to IRE .
• Perform other duties as necessary.

Work Schedule

• Mon – Fri; 8 AM to 5 PM.

We believe in making an impact in the lives of our employees, personally, and professionally. Every employee has different individual and/or family needs. We offer benefits that are both comprehensive and flexible to address your unique needs. We believe work-life harmony is positive and achievable.
We offer competitive salaries, generous paid time off, insurance plans, reimbursements, and retirement benefits. Additionally,
Our faculty, staff, and administrators are 100% focused on student success.
Our University culture creates the context for a nurturing and supportive environment.
Faculty, staff, and students can expect to make deep, personal relationships within the University community.
As a Faculty, Staff, or Student at WesternU, you can focus on work that you love, be your authentic self, and lead to the future with innovation in health sciences.
WesternU’s core value of humanism encourages all to bring their whole self in all that they do.
We are committed to fostering a culture of respect, equity, collaboration, and fun at all levels for all people!

Expected Pay Scale

Minimum

Minimum $36.06 Hourly

Maximum

Maximum $36.06 Hourly

Physical Demands

Do the essential functions of this job require lifting?

Do the essential functions of this job require lifting? Yes

If 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 PC 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. The employee must occasionally lift and/or move up to 15 pounds. 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.
Duties are normally performed in a typical office setting. The noise level in this setting is typically low to moderate. Remote work environment.

Posting Information

Posting Number

S01835

Posting Date

10/05/2026

Close Date

10/05/2027

Open Until Filled Yes

Conditions of Employment - Background Check

To secure employment, successful fulfillment of a background check, including a criminal records check, may be required. Western University of Health Sciences will extend a conditional offer of employment, subject to rescission if the background check unveils disqualifying information or if it is found that the candidate deliberately withheld or misrepresented information. Non-completion of the background check to satisfaction may impact the ongoing employment of a current Western University of Health Sciences employee who received a conditional offer for the position.

Pay Transparency Act

Pay Transparency Act- Western University of Health Sciences is required to provide a reasonable estimate of the compensation range for this role. This range considers various factors 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 Expected Pay Scale is defined as the budgeted salary or hourly range that the University reasonably expects to pay for this position. Placement within the Expected Pay Scale is determined by internal equity and relevant qualifications.

Equal Opportunity Statement (EEO)

It is the policy of Western University to provide equal employment opportunity to all employees and applicants for employment as required by law without regard to age, race, color, national origin ancestry, citizenship, ethnicity, creed, religion or religious creed, sex or gender (including gender identity), marital status, sexual orientation, disability (both physical and mental) including HIV and AIDS, medical condition (cancer and genetic characteristics), pregnancy (which includes childbirth, breastfeeding and medical conditions related to pregnancy, childbirth or breastfeeding), age, genetic information, military and veteran status, or any other applicable protected characteristic as outlined by federal, state, or local laws.This policy applies to all employment practices within WesternU including without limitation, hiring, recruiting, promotion, termination, layoffs, leave of absence, compensation, benefits, and training. WesternU makes hiring decisions based solely on qualifications, merits, and business needs at the time.

Required Documents

• Resume
• Cover Letter

Optional Documents

• Curriculum Vitae
• Letter of Recommendation #1
• Letter of Recommendation #2
• Letter of Recommendation #3
• Portfolio
• Additional Applicant Document
• Required License/Certification

Supplemental Questions

Required fields are indicated with an asterisk (*).

• * How did you hear about this employment opportunity? Please provide the name of the website, individual, or organization.

  (Open Ended Question)

• * Are you a current employee at Western University of Health Sciences?
  • Yes
  • No

309 E. Second St.
Pomona, CA 91766-1854
[phone]

[phone]

COMP-Northwest:
200 Mullins Dr.
Lebanon, OR 97355-3983
[phone]

CHS-Northwest:
2665 S. Santiam Highway,
Lebanon, OR 97355
[phone]

COMP-Northwest:
[phone]
CHS-Northwest:
[phone]