IS Analyst/Programmer II

Req No: 2023-15805
Category: Information Technology
Type: Full-Time Central Staff
Salary: $40.00 - $44.42 per hour
Close Date:

Overview
This position is open until filled with an initial application review to take place after July 21, 2023.

The starting pay range for this position is $40.00 - $44.22 per hour depending upon qualifications and is non-negotiable.

SDSU Research Foundation is seeking a Programmer/Analyst to join our growing team!

WHO WE ARE

Established in 1943, the mission of the SDSU Research Foundation (SDSURF) is to focus on realizing the research objectives of San Diego State University, and to be the backbone for faculty and staff to find, attract, win, and administer their research and sponsored programs. SDSU is one of the top public research universities in the nation, furthering discoveries, interventions, and solutions that improve communities and change the world. The SDSURF provides the full life cycle of grants services to faculty and staff to realize these discoveries, interventions, and solutions that make a difference.

WHAT OUR DEPARTMENT DOES

The Information Systems team serves the evolving information services and technology needs of SDSURF. The team is responsible for the operation, maintenance, security, and ongoing development of SDSURF enterprise systems and providing administrative desktop services for central staff personnel. Our team members work closely with our users and colleagues to develop and implement user-focused technology solutions that support researchers and employees, contributing to increased productivity, security, and accessibility of information and help further the SDSU research mission and strategic growth plans.



Responsibilities
YOUR ROLE IN CREATING THE UNIVERSITYS PRESENT AND FUTURE

As an IS Analyst/Programmer on the IS Development Services team, under the general direction of the IS Development Services Manager, you will support, improve, and modernize administrative systems that support the research and creative endeavors of our staff and faculty.

This position, on occasion, may be required to work hours beyond typical business hours, including after work hours, weekends, and holidays.

Responsibilities

THE WORK YOU WILL DO AND MANAGE

As an IS Analyst/Programmer you will be responsible for an entire range of activities supporting Ellucian Banner ERP implementation (Finance, HR) from troubleshooting, break/fix support, gathering and analyzing requirements to full application development and data integrations with a myriad of external systems and business applications. Consulting with colleagues across the organization, you will develop custom forms, reports, workflows, and data integrations supporting business processes using a variety of technical skills, namely Oracle SQL, PL/SQL, Linux shell scripting, Oracle Application Express (APEX), vendor APIs and other data-transfer methods. You will:

• Engage with users, stakeholders, technical resources, and subject experts across the organization to collect functional and technical requirements, analyze business process requirements, and develop technical specifications.
• Design, prototype, test, debug and deploy secure user-centric programs, custom applications and reports in Banner, APEX and other SDSURF Systems.
• Provide various departments with necessary data for internal and external reporting.
• Write, tune, and validate Oracle SQL queries and reports.
• Provide courteous and effective end-user support for SDSURF administrative systems, researching issues and making recommendations to resolve current issue and address the root cause.
• Actively collaborate and coordinate with IS colleagues to build and share a set of centralized, certified tables and packages from defined business rules to create accurate and consistent reports and programs.
• Help protect our systems and data by documenting code and processes and following change management processes for source code, database objects, host programs and directories (including changes to server programs and permissions) and conducting all activities within prescribed policies and procedures.
• Participate in projects to investigate and evaluate proposed new software, solutions, and approaches to solving data and process challenges.

Qualifications
THE SKILLS WE NEED

Skills, Knowledge and Abilities Needed

• Oracle SQL/PL-SQL programming experience
• Ability to gather requirements from a diverse sources, perform data analysis, coding, testing, integration and maintenance of Oracle and other business applications.
• Strong customer service skills and a strong desire to assist others
• Ability to communicate effectively to instruct or train others through explanation and/or demonstration
• Strong verbal and written communication skills for both technical and non-technical audiences. Self-motivated, ability to stay on task and work both independently and in a team environment.
• Highly motivated self-starter, with a strong and dependable work ethic and desire to be a system owner.
• Well organized, ability to manage priorities and workload to meet deadlines, detail oriented; possess good judgment and common sense.
• Demonstrated ability to handle direct customer interaction professionally.
• Ability to quickly and honestly recognize and report mistakes to mitigate their impact on systems and users.
• Excellent team-working, training skills and a willingness to share knowledge with other team members along with a willingness to learn from other subject experts in order to raise the collective knowledge of our information systems family.
• Ability to write, tune and validate advanced Oracle SQL queries and reports.
• Ability to create, test and debug Linux shell scripts, scheduled jobs, and automated reports.
• Knowledge of Linux operating system, including Bash shell, user/group permissions and environment variables.
• Ability to develop complex Oracle applications, data processes and integration with various systems.
• Strong understanding of the software development lifecycle from technical design, unit testing to user testing, to production migration. Emphasize adherence to standards and controls, and conduct quality assurance over programs before migration to production.

Experience and Education

• Bachelors degree in Information Systems, business, or related field or an equivalent combination of education, certifications and relevant experience.
• Two-years of related work experience of system design, analysis, programming experience
• Two-years of related work experience using SQL in a relational database environment, preferably Oracle SQL and PL/SQL

Preferred Qualifications and Special Skills

• Experience consulting with end-users and stakeholders to analyze business processes, understand business requirements, and develop technical specifications.
• Experience with Oracle Application Express (APEX) and/or Ellucian Banner systems a plus
• Experience with APIs, Web Services or other data integration methods.
• Experience with Oracle database design with strong knowledge of Oracle database concepts (including stored procedures, packages, functions, triggers, tables, views, indexes, etc.)
• Experience with Linux/Unix Shell Scripting
• Proficiency writing advanced queries, using advanced SQL concepts
• Experience with TOAD, SQL Developer, GIT and GitHub
• Working knowledge of relational databases (Oracle preferred)
• Experience with Linux operating system

WHAT YOU WILL RECEIVE

• Comprehensive medical, dental, and vision plans
• Life and disability insurance plans
• Employer contributed 403b retirement plan
• Generous vacation and sick leave accruals
• 13 paid holidays and 1 annual personal holiday
• Hybrid in-office/telework arrangements
• Employee Assistance Program (EAP)
• Access to campus amenities, including Love Library, Aztec Lanes bowling alley, SDSU transit center, and a variety of coffee shops and eateries.
• Discounted Aztec Recreation Center gym membership and SDSU events
• Wellness workshops

HOW TO APPLY AND TIPS FOR MAKING IT THROUGH OUR HIRING PROCESS

You must apply through the SDSURF Career Page. Make sure your application is complete. Including a resume and cover letter is recommended. Respond to supplemental questions thoroughly.

WHAT OUR HIRING PROCESS IS LIKE

We work as fast as we can to make hiring decisions. However, it may take several weeks for all the parties involved to review your application. We keep in touch each step of the way and inform you of the status of your application.

ADDITIONAL APPLICANT INFORMATION

• Candidate must reside in California or live in a commutable distance from SDSU at time of hire.
• Job offer is contingent upon satisfactory clearance based on Background Check results (including a criminal record check).
• San Diego State University Research Foundation is an EEO/AA/Disability/Vets Employer

To apply, visit https://careers-sdsurf.icims.com/jobs/15805/is-analyst-programmer-ii/job?in_iframe=1









Copyright 2022 Jobelephant.com Inc. All rights reserved.

Posted by the FREE value-added recruitment advertising agency
jeid-2e2b69961d32524e82dfc54d9bfcba3e

Return to Search Results