IS Analyst/Programmer II
San Diego State University Research Foundation
Get more replies from employers
Send a job-specific resume in minutes.
Benefits offered by this job
Job summary
Qualifications
- Ability to gather requirements from diverse sources.
- Demonstrated ability to handle direct customer interaction professionally.
- Ability to develop complex Oracle applications and integrate systems.
- Experience with APIs and Web Services.
Responsibilities
- Support and modernize administrative systems at SDSURF.
- Gather and analyze requirements and provide end-user support.
- Collaborate with teams to create reports and data integrations.
- Document code and processes adhering to change management.
Skills
Education
Tools
Job description
As an IS Analyst/Programmer you will support, improve and modernize administrative systems that support the research and creative endeavors of our staff and faculty. You will be responsible for 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. You will consult with colleagues across the organization to develop custom forms, reports, workflows, and data integrations supporting business processes using Oracle SQL, PL/SQL, Linux shell scripting, Oracle Application Express (APEX), vendor APIs and other data-transfer methods. Occasionally, you may be required to work outside typical business hours, including after work hours, weekends, and holidays.
- Collect functional and technical requirements from users, stakeholders, technical resources, and subject experts to design, prototype, test, debug and deploy secure user‑centric programs, custom applications and reports in Banner, APEX and other SDSURF Systems.
- Provide courteous and effective end‑user support for SDSURF enterprise systems.
- Investigate and evaluate proposed new software, solutions, and approaches to solve ongoing data challenges.
- Provide various departments with necessary data for internal and external reporting.
- Actively collaborate and coordinate with colleagues to build and share a set of centralized, certified tables and packages from defined business rules to create accurate, consistent reports and programs.
- Document code and processes and adhere to agreed‑upon change‑management processes for source code, database objects, host programs and directories (including changes to server programs and permissions).
- Maintain system, program, and user documentation.
- Conduct all activities in compliance with current SDSU Information Security Plan and SDSU Research Foundation Information Systems Policies and Procedures.
- Oracle SQL/PL‑SQL programming experience.
- Ability to gather requirements from 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, able 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, able 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 and to learn from other subject experts to raise collective knowledge.
- 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, emphasizing adherence to standards and controls and conducting quality assurance before migration to production.
- Two years of related work experience using SQL in a relational database environment, preferably Oracle SQL and PL/SQL.
- 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.
- 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, and indexes).
- 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.
- 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 in system design, analysis and programming.
- Comprehensive medical, dental and vision plans.
- Life and disability insurance plans.
- Generous employer‑contributed 403(b) retirement plan. We match 200% on the first 5% of contributions, up to a 10% maximum employer matching contribution. All contributions are 100% vested.
- 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.
Salary range: $29.76 to $55.18 per hour depending on qualifications and is non‑negotiable.
San Diego State University Research Foundation is an equal opportunity employer. Consistent with California law and federal civil rights laws, SDSU Research Foundation provides equal opportunity in employment without unlawful discrimination or preferential treatment based on race, sex, color, ethnicity, national origin or any other categories protected by federal or state law. Employment decisions are based on an individual’s qualifications as they relate to the job under consideration. Our commitment to equal opportunity ensures that every employee has equal access to resources and support. SDSU Research Foundation complies with Titles VI and VII of the Civil Rights Act of 1964, Title IX of the Education Amendments of 1972, the Americans with Disabilities Act (ADA), Section 504 of the Rehabilitation Act, the California Equity in Higher Education Act, California’s Proposition 209 and other applicable state and federal anti‑discrimination laws. SDSU Research Foundation maintains a nondiscrimination policy that prohibits discriminatory preferential treatment, segregation based on race or any other protected status, and all forms of unlawful discrimination, harassment, and retaliation in all programs, policies, and practices. SDSU Research Foundation makes all employment decisions — including, but not limited to, applicant screening, hiring, promotion, demotion, compensation, benefits, disciplinary actions, and terminations — on the basis of merit.
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
