Programmer Analyst

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., * 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., 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, 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.

Applicant Documents

Required Documents

1. Resume
2. Cover Letter

Optional Documents

1. Curriculum Vitae
2. Letter of Recommendation #1
3. Letter of Recommendation #2
4. Letter of Recommendation #3
5. Portfolio
6. Additional Applicant Document
7. Required License/Certification

Individuals must possess the following knowledge, skills, and abilities or be able to explain and demonstrate that the individual can perform the essential functions of the job.

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.

Required Qualifications 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 Ellucian Banner, Ellucian Operational Data Store, IBM Cognos Analytics, PL/SQL Developer, WordPress, Microsoft PowerBI, HTML and Javascript is strongly desired.
• 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.

Work Schedule

• Mon - Fri; 8 AM to 5 PM.

Working at WesternU

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 $36.06 Hourly Maximum $36.06 Hourly

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. Posting Details