This position is open until filled with an initial application review to take place after December 4, 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 talented and motivated programmer with SQL and systems analysis experience to join our growing team. This is an excellent opportunity for early to mid-career professionals who are eager to contribute to innovative projects and accelerate their professional development. 

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. We are responsible for the operation, maintenance, security, and ongoing development of SDSURF enterprise systems and providing administrative desktop services for central staff personnel. We collaborate with users and colleagues to develop and implement user-focused technology solutions that contribute to increased productivity, security, and accessibility of information and help further the SDSU research mission and strategic growth plans. We pride ourselves on fostering a collaborative and inclusive work environment, where creativity and dedication are  highly valued. 

Responsibilities

YOUR ROLE IN CREATING THE UNIVERSITY’S 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

As an IS Analyst/Programmer you will assist in supporting Ellucian Banner ERP,gathering and analyzing requirements with a myriad of external systems and business applications.  Consulting with colleagues across the organization, you will develop custom forms, reports, workflows and support  data integrations supporting business processes using a variety of technical skills, namely Oracle SQL, PL/SQL, Oracle Application Express (APEX).  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 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 issues, including root cause analysis.

Qualifications

THE SKILLS WE NEED

Skills, Knowledge and Abilities Needed

• Professional  SQL or equivalent technical experience
• Strong customer service skills and a strong desire to assist others
• Ability to communicate effectively
• 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.
• 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 team.
• Ability to write, tune and validate SQL queries and reports.
• Ability to create, test and debug  scripts, scheduled jobs, and automated reports.
• 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

• Bachelor’s 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 or related experience

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.
• knowledge of Oracle database concepts (including stored procedures, packages, functions, triggers, tables, views, indexes, etc.)
• Experience with Linux/Unix Shell Scripting
• Proficiency writing  queries, using advanced SQL concepts
• Experience with TOAD, SQL Developer, GIT and GitHub
• Working knowledge of relational databases (Oracle preferred)

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
• 14 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

If you are excited about the prospect of contributing to impactful projects and expanding your skill set, we invite you to apply through the SDSURF Career Page. Make sure your application is complete.  Including a resume and cover letter is recommended. 

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

Thank you for considering SDSU Research Foundation as your next career move.