California State University, Stanislaus
(Classified as ANALYST/PROGRAMMER-CAREER)
Full time position available on or after September 25, 2017 for the Office of Information Technology.
ESSENTIAL DUTIES: Position is part of an Agile development team focusing on PeopleSoft ERP projects and Business Intelligence projects. This position provides software development support for our PeopleSoft Administration system, the Data Warehouse, as well as other ancillary systems as assigned. This position requires an advanced and comprehensive knowledge of the required technologies and a working knowledge of related specialties and is able to apply this extensive expertise as a generalist or specialist. Duties include but are not limited to:
• Analyze user system and application needs, determine and evaluate alternative solutions and approaches to meeting those needs, and select the optimal technology solution. Examples
of typical work activities include: Consult with users to identify and document software/system purpose, work flow issues, output needs and determine overall functional and technical system requirements and specifications; Develop alternative solutions and conduct feasibility studies; Evaluate the procurement of third party software and troubleshoot new software installations; Analyze current business processes and process map current systems; Conduct analysis and fit-gap procedures for converting legacy data into newly acquired systems.
• Development of specifications and requirements for the optimal integration and implementation of systems and equipment. Examples of typical work activities include: Develop requests for proposals for system components; Evaluate specifications and requirements against available systems; Design fully integrated systems which may include applications, databases, middleware, and related systems; Ensure system integrity and efficiency; Coordinate development of conversion procedures for migrating legacy data to new systems; Develop/Modify new systems components required to accommodate current business processes; Collaborate with other campuses to develop common systems.
• Design application programs to meet user requirements that optimize the use of available resources. Examples of typical work activities include: Develop program specifications and review them with the user to ensure that requirements are met; Design user-friendly interfaces to systems, applications, and databases; Recommend modifications to third party software to meet user needs.
• Programming and Software Development. Participate in the development of succinct, timely programming code or modify software in a logical fashion, which optimizes programming resources and meets functional user requirements. Example of typical work includes: Write code to meet user specifications. Use productivity tools to develop and modify applications software to meet user needs. Work with users to test and debug programs. Verify data acquisition and output media and format. Modify existing or third party software. Write documentation to provide user support for new or modified programs and production/operational procedures. Participate in the development of new software interfaces and customizations of new administrative systems.
• Applications Installation and Maintenance. Maintain and support assigned systems to ensure minimal downtime and loss of productivity and service. Examples of typical activities include: Evaluate and enhance the efficiency of existing programs in meeting current and future user needs. Maintain and support associated databases. Install new, modified or third party software releases and/or updates. Evaluate and supplement vendor-supplied documentation for third party software.
• Data Warehouse Analysis. Analyze, implement and maintain data warehouse systems to optimize data access and security. Examples of typical work activities include: Assist in the development of data warehouse systems and programs. Work with user community to understand data access and integration needs. Ensure the integration of systems through the data warehouse structure. Troubleshoot and resolve data warehouse and data problems. Develop reports and dashboards, and support users in their adoption of the data warehouse.
• Maintain awareness of current technical developments through research, self-study, and participation in formal training programs.
• Team Mentoring. Transfer information technology related concepts and skills in a continuing effort to promote the growth in institutional knowledge. Other duties or projects as assigned.
• Bachelor’s degree in Computer Science, Computer Information Systems, Business, or a related field or equivalent training and applied experience.
• Minimum of 5 years of experience in Software development.
• Minimum of 3 years of experience working with MS SQL Server or Oracle databases.
• Expert working knowledge of Relational Database design, including tables, views, indexes, and referential integrity.
• Expert working knowledge of an industry standard programming language, and various reporting tools.
• Experience working with PeopleSoft or an equivalent ERP system.
• Experience with the PeopleSoft Development Suite, including App Designer, App Engine, SQR, and PeopleCode.
• Experience working with PeopleSoft HCM, CS, and/or HR modules.
• Experience designing and supporting Data Warehouses, particularly Star-Schema models.
• Experience writing Oracle SQL queries and views.
• Experience with Microsoft BI Tools, including MS SQL Server, MS Analysis Services, and MS Reporting Services
• Experience with Microsoft Visual Studio.Net.
• Master’s Degree in Computer Science, Information Technology, or an equivalent preferred.
• Experience in a higher education setting.
SPECIALIZED KNOWLEDGE, SKILLS, AND ABILITIES:
• Software development experience within an ERP framework, such as PeopleSoft/Oracle preferred.
• Knowledge of system development life cycle, structured systems development concepts, as well as Agile development methodologies.
• Comprehensive knowledge of system/equipment capability, design restrictions, and security requirements. Knowledge of network connectivity, integration, configuration, and protocols.
• Comprehensive understanding and ability to integrate all systems including operating systems, applications, network, and databases, as well as knowledge of distributed processing
technology. Ability to communicate effectively.
• Ability to apply consultative skills to assess user needs and communicate technology systems and solutions. Ability to work and communicate with users to define and meet database
needs and requirements
• Ability to collaborate and network with staff from other campuses on implementing common administrative systems to improve efficiency.
• Ability to use one or more industry standard programming languages and various report/screen generators as required by the position.
• Knowledge of structured programming techniques and the ability to use appropriate productivity tools to provide for more rapid development of applications. Ability to perform interactive
debugging and to test and analyze program failures
• Ability to write/modify programs using multiple applications and databases. Ability to develop program implementation plans, install software, and apply fixes.
• Understanding of technical and vendor documentation and ability to maintain internal documentation.
• Ability to design data structures to maximize efficiency and flexibility, and maintain a data dictionary.
• Ability to provide database support in a multiple hardware and operating system environment.
SALARY RANGE: $4,372- $9,877 per month plus excellent paid benefits. (Position will typically be hired at or near the entry salary.) The California State University offers a premium benefit package that includes, but is not limited to, outstanding vacation, health, dental, and vision plans; a fee waiver education program; membership in the California Public Employees Retirement System (PERS); and 14 paid holidays a year.
POSITION IS OPEN UNTIL FILLED. APPLICATION SCREENING WILL BEGIN SEPTEMBER 19, 2017. (Applications received after the screening date will be considered at the discretion of the university.)
APPLICATION PROCEDURE: Applications will be processed in accordance with Article 9.3 of the CSU/CSUEU Memorandum of Understanding. Preference will be given to qualified individuals currently employed at CSU Stanislaus in bargaining units 2, 5, 7, and 9 except when it is determined that it is necessary to appoint outside applicants to meet the best interest of the campus by obtaining specialized skills and abilities not available from current employees. To be considered, qualified candidates must submit a completed CSUS employment application (download electronic application at http://www.csustan.edu/hr/Employment_Opportunities/Staff/index.html), cover letter, and resumé to:
California State University, Stanislaus ∙ Human Resources Department
Mary Stuart Rogers Educational Services Gateway Building, Suite 320 (3rd Floor)
One University Circle ∙ Turlock, CA 95382
For questions, please contact: Mr. Corey Cardoza (209) 667-3731
A background check (which includes checks of employment records, education records, criminal records, civil records; and may include motor vehicle records, professional licenses, and sex offender registries, as position requires) 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.
Applicants requiring necessary accommodations to the application process may contact the Human Resources Department at (209) 667-3351. California Relay Service is available at (800) 735-2922 voice and (800) 735-2929 TDD. As a federal contractor, we are committed to attracting a diverse applicant pool. Please consider completing the Voluntary Self-Identification of Disability form (your response will not be shared with the search committee) at: http://www.dol.gov/ofccp/regs/compliance/sec503/Voluntary_Self-Identification_of_Disability_CC-305_SD_Edit1.24.14.pdf.
THE INDIVIDUALS WHO APPEAR TO BE THE BEST QUALIFIED FOR THIS POSITION WILL BE CONTACTED BY TELEPHONE FOR AN INTERVIEW
PURSUANT TO THE JEANNE CLERY DISCLOSURE OF CAMPUS SECURITY POLICY AND CAMPUS CRIME STATISTICS ACT, THE ANNUAL SECURITY REPORT (ASR), IS NOW AVAILABLE FOR VIEWING AT HTTPS://WWW.CSUSTAN.EDU/ANNUAL-CAMPUS-SECURITY-REPORT. THE ASR CONTAINS THE CURRENT SECURITY AND SAFETY-RELATED POLICY STATEMENTS, EMERGENCY PREPAREDNESS AND EVACUATION INFORMATION, CRIME PREVENTION AND SEXUAL ASSAULT PREVENTION INFORMATION, AND DRUG AND ALCOHOL PREVENTION PROGRAMMING. THE ASR ALSO CONTAINS STATISTICS OF CLERY ACT CRIMES FOR STANISLAUS STATE FOR THE PREVIOUS THREE YEARS. A PAPER COPY OF THE ASR IS AVAILABLE UPON REQUEST BY CONTACTING THE OFFICE OF THE CLERY DIRECTOR LOCATED AT ONE UNIVERSITY CIRCLE, TURLOCK, CA 95382, OR BY CALLING 209-667-3572.
THE UNIVERSITY IS AN EQUAL OPPORTUNITY EMPLOYER AND DOES NOT DISCRIMINATE AGAINST PERSONS ON THE BASIS OF RACE, RELIGION, COLOR, ANCESTRY, AGE, DISABILITY, GENETIC INFORMATION, GENDER, GENDER IDENTITY, GENDER EXPRESSION, MARITAL STATUS, MEDICAL CONDITION, NATIONAL ORIGIN, SEX, SEXUAL ORIENTATION, COVERED VETERAN STATUS, OR ANY OTHER PROTECTED STATUS. ALL QUALIFIED INDIVIDUALS ARE ENCOURAGED TO APPLY. CSU STANISLAUS HIRES ONLY INDIVIDUALS LAWFULLY AUTHORIZED TO WORK IN THE UNITED STATES. 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.