Analyst Programmer (Career Skill Level)/ Administrative Computing



Job Details

Analyst Programmer (Career Skill Level)/ Administrative Computing
Employer

California State University, San Bernardino

Salary

$52,464.00 - $118,524.00 Annually

Location

San Bernardino, CA

Job Type

Full-Time

Job Number

2017-00651

Division

Information Technology Services

Department

Administrative Computing

Opening Date

08/14/2017

Closing Date

Continuous

Overview

Employment Status:  Full-time, probationary "exempt" position.

Work Schedule:  Generally, Monday through Friday, 8:00 a.m. to 5:00 p.m.

First Review Deadline:  This position will remain open until filled. Applications will be reviewed beginning August 31, 2017.

Typical Activities

Under minimal supervision of the Director of Administrative Computing and Business Intelligence, the incumbent will be responsible for supporting production, ongoing development, upgrades and enhancements to CSUSB enterprise administrative applications in support of Student Affairs, Academic Affairs, Administration and Finance, University Advancement.  The incumbent will perform the following job duties: 

  • Support of PeopleSoft Applications specifically, but not limited to Student Administration.
  • Create routine to complex reports, data extractions, and data/system interfaces from campus systems that cannot be met by current end-user reporting solutions.
  • Review release notes for database and application upgrades and patches.
  • Investigate all system updates for technical changes that affect supported software, data integrity, or system processing effectiveness.
  • Resolve support issues and provide solutions to the functional team.
  • Other duties as prescribed in the Classification and Qualification Standards of the CSU for an Analyst/Programmer at the career level.

The core functions of the Analyst/Programmer are:

Technical support for PeopleSoft Applications
  • Provide technical support to all PeopleSoft users. Responsible for supporting production, ongoing development, upgrades, and enhancements to Oracle/PeopleSoft Enterprise Resource Management system.
  • Create/maintain/enhance custom reports, queries, and data extracts.  Design custom PeopleSoft pages and views as needed.
  • System integration to and from PeopleSoft to other vendor and campus systems.
  • Write SQR processes to automate business processes
Technical Support for Financial Aid/Admissions Office
 
  • Will work with the user community to understand data access and integration needs of the financial aid and/or Admissions office.
  • Provide system team progress on major issues that impact staff's ability to function and/or operate FA and Admission system processes or procedures. 
  • Responsible for testing upgrades, business processes changes, and automation of the FA and Admissions processes.
 
Technical Support as needed in other area
  • Technical Support for other applications such as OnBase or other imaging systems, Hobsons, Cal State Online, etc
  • Technical Support for integrations to other systems
  • Team player for Administrative Computing & Business Intelligence projects

Minimum Qualifications

Applicants must possess the following:

  • Equivalent to a Bachelor's degree in Information Systems, Computer Science, or a related field along with three years of professional experience programming and creating complex SQL queries (additional relevant experience may be substituted for academic work).
  • 3-5 years' experience in PeopleSoft Application Development using Application Designer. PeopleSoft/ People Tools environment with Data Mover, PS Query, SQR, People Code, Application Engine or related tools Oracle Database programming- PL/ SQL.
  • Extensive working knowledge of PeopleSoft security;  relational database design; and data warehouse concepts.
  • Demonstrated ability to independently identify and solve complex production problems.
  • Demonstrated ability to work with outside systems integration.
  • Position requires clear, positive, solution-oriented communication to translate user needs into effective technical solutions.

Preferred
  • Experience in a University environment along with experience in PeopleSoft/ People Tools environment with Data Mover, PS Query, SQR, People Code, Application Engine or related tools Oracle Database programming- PL/ SQL
  • Experience doing development in PeopleSoft as it is related to the functions of the Financial Aid Office and/or Admissions Office
  • Experience with Imaging software
  • CSU system experience a plus

Supplemental Information

A background check (including a criminal records check) must be completed satisfactorily before any candidate can be offered a position with the CSU. Failure to satisfactorily complete the background check may affect the application status of applicants or continued employment of current CSU employees who apply for the position.

The person holding this position is considered a `mandated reporter' under the California Child Abuse and Neglect Reporting Act and is required to comply with the requirements set forth in CSU Executive Order 1083 as a condition of employment.

California State University, San Bernardino is an Affirmative Action/Equal Opportunity Employer.  We consider qualified applicants for employment without regard to race, religion, color, national origin, ancestry, age, sex, gender, gender identity, gender expression, sexual orientation, genetic information, medical condition, disability, marital status, or protected veteran status. 

This position may be "Designated" under California State University's Conflict of Interest Code. This would require the filing of a Statement of Economic Interest on an annual basis and the completion of training within 6 months of assuming office and every 2 years thereafter.  Visit the Human Resources Conflict of Interest webpage link for additional information: https://www.csusb.edu/human-resources/current-employees/employee-relations/conflict-interest

This position adheres to CSU policies against Sex Discrimination, Sexual Harassment, and Sexual Violence, including Domestic Violence, Dating Violence, and Stalking. This requires completion of Sexual Violence Prevention Training within 6 months of assuming employment and on a two-year basis thereafter. (Executive Order 1096)

You have medical, dental and vision plans from which to choose coverage.  You may cover yourself and your eligible spouse or domestic partner and children.  You are eligible to enroll in coverage if you are appointed at least half-time and for more than six months.  If you enroll on a timely basis, coverage begins on the first of the month after your date of hire.  You also may enroll during any annual open enrollment period.
HEALTH CARE
Medical Benefits - You have a choice of several Health Maintenance Organizations (HMOs), depending on location, or Preferred Plan Provider (PPO) insurance plans through the California Public Employees' Retirement System (CalPERS)).  You and the CSU share the cost of coverage, with the CSU paying the greater portion of the monthly premium.  You may pay your portion of the cost on a pre-tax basis through the Tax Advantage Premium Plan (TAPP).

Dental Benefits – You may choose between two dental plans:  a traditional indemnity (fee-for-service) plan allowing you to see almost any dental provider, or a "dental HMO" plan offering a network of dentists from which to choose.  Currently, the CSU pays the full dental premium for you and your eligible dependents.

Vision Benefits – Vision coverage includes an annual eye exam, and glasses or contact lenses every other year.  Currently, the CSU pays the full vision premium for you and your eligible dependents.

Cobra Benefits – If you lose your eligibility for medical, dental, and vision benefits under specified circumstances (for example, you leave employment with the CSU), the Consolidated Omnibus Budget Reconciliation Act of 1986 (COBRA) and the Omnibus Budget Reconciliation Act of 1989 (OBRA) allows you to continue to receive health care coverage at your expense.  You and your dependents can receive COBRA benefits for up to 18, 29 or 36 months, depending on the circumstances.

FLEXIBLE BENEFITS PLANS

FlexCash – If you waive the CSU medical and/or dental coverage because you have other non-CSU coverage, you can receive additional cash in your paycheck each month.  You will be taxed on this additional income.  Currently, you can receive $128 FlexCash per month if you waive medical coverage and $12 FlexCash per month if you waive dental coverage.

SURVIVOR PROTECTION BENEFITS

Life and Accidental, Death & Dismemberment (AD&D) Insurance – The CSU provides you with $10,000 of basic term life insurance coverage and $10,000 of basic accidental death and dismemberment (AD&D) insurance coverage.  The CSU pays the full cost of this coverage.  Coverage is automatic and effective on the first of the month after your date of hire.

ADDITIONAL CSU BENEFITS

CSU Fee Waiver Program – If you are a full-time employee, you are eligible each term to waive certain fees at a CSU campus for a maximum of two courses or six units, whichever is greater.  You may transfer your fee waiver benefit to your spouse, domestic partner, or dependent child (up to age 25); however, not all of the fees may be waived or reduced for your dependents.

RETIREMENT PLANS

CalPERS Retirement Plan – The California Public Employees Retirement System is a defined benefit retirement plan that provides lifetime benefits based on members' years of service, age, and final compensation.  Full-time employees appointed for at least six months, or part-time employees working at least half-time and appointed for at least one year, are automatically enrolled in the CalPERS Retirement Plan. 

Depending on hire and/or membership date, employees are placed in one of three retirement formulas.  Each formula determines the employee contribution rate, and the benefit factor and final compensation period used to calculate retirement allowance.
 
Retirement Plans
 

 

Employee Contribution

5% of monthly pay in excess of $5135% of monthly pay in excess of $5136% of monthly pay
 
Pre-Tax Savings Plans – As a CSU employee, you have three voluntary retirement savings plans available to you, which allow you to invest pre-tax dollars to supplement your CalPERS Retirement Plan benefit.  They are:

  • The CSU 403(b) Tax Sheltered Annuity (TSA) Plan
  • The Savings Plus 401(k) Thrift Plan
  • The Savings Plus 457 Deferred Compensation Plan
You may participate in any or all of the plans.  Each is governed by a different section of the IRS Code resulting in different rules and provisions. 
TIME-OFF BENEFITS - (Paid Leave)

Holidays – The CSU offers employees 14 paid holidays each year; 13 scheduled on specific days and one you may take any time during the year.

Vacation – Depending upon your years of service, you earn vacation monthly as follows:  5/6 day up to three years; 1 1/4 days up to six years; 1 5/12 days up to 10 years; 1 7/12 days up to 15 years; 1 3/4 days up to 20 years; 1 11/12 days up to 25 years; and two days per month thereafter.  If you have less than 10 years of service with the CSU, you can accrue up to a maximum of 272 hours (34 days); if you have more than 10 years, the maximum is 384 hours (48 days).  Part-time employees accrue vacation on a prorated basis.

Sick Leave – For each month of continuous service, you accumulate eight hours of credit for sick leave with pay.  Part-time employees accrue sick leave on a prorated basis.

Maternity/Paternity/Adoption Leave – You are eligible for up to 30 workdays per calendar year starting within sixty (60) days of the arrival of your new child, due to birth, adoption, or foster care assignment. 

01
Are you a current CSU San Bernardino employee?
  • Yes
  • No
02
What is your current classification title at CSU San Bernardino? (This should be your classification rather than your working title.) If you are not affiliated with CSU San Bernardino, please write in Not Applicable.
03
Do you possess the equivalent to graduation from a four-year college or university degree in Information Systems, Computer Science, or a related field?
  • Yes
  • No
04
Do you possess the equivalent to three years of professional experience programming and creating complex SQL queries?
  • Yes
  • No
05
Do you possess the equivalent to 3-5 years' experience in PeopleSoft Application Development using Application Designer?
  • Yes
  • No
06
Please describe in detail your understanding of PeopleSoft security; knowledge of relational database design; knowledge of data warehouse concepts as it relates to this position.
07
Please explain how your experience in PeopleSoft Application Development using Application Designer, PeopleSoft/ People Tools environment with Data Mover, PS Query, SQR, People Code, Application Engine or related tools Oracle Database programming- PL/ SQL matches the requirements of this position.

* Required Question

Employer
California State University, San Bernardino
Address
5500 University Parkway

San Bernardino, California, 92407
Phone
(909) 537-5138

Apply

OnlineApplication

Warning! You are using Internet Explorer 8. Some features of the Online Application are not fully supported in this version. Please upgrade to a later version of Internet Explorer for optimal performance.

Loading ...