Applications Developer
Role details
Job location
Tech stack
Job description
The Senior Applications Developer reports to the Information Management Systems and Services (IMSS) Associate Director of Financial Systems and will be part of a small team assigned to support a wide variety of administrative systems across Caltech. These systems include but are not limited to, Oracle E-business Suite, Oracle Analytics Cloud (OAC), data warehouse tools, Assetworks AiM, Huron Research Suite, SciQuest, Ellucian Advance and SAP Concur., The successful candidate will work with business system analysts and stakeholders to architect secure, scalable solutions within an Oracle-centric ecosystem, including Oracle E-Business Suite (EBS), Oracle APEX development, and Oracle Analytics Cloud (OAC). They will design and develop custom applications, complex integrations, and data warehouse solutions leveraging Oracle Data Integrator (ODI), PL/SQL, REST and SOAP APIs, and low-code development frameworks. The successful candidate will also play a key role in supporting the organization's planned migration to Oracle Fusion (Oracle Cloud ERP/HCM), contributing to solution architecture, data migration strategy, and roadmap alignment across legacy and modern Oracle platforms. Essential Job Duties
- Design, code, test, and debug complex application components and integrations using Oracle EBS, APEX, PL/SQL, Oracle Data Integrator (ODI), and REST/SOAP web services.
- Develop and maintain data models, ETL/ELT processes, and reporting solutions for the Oracle Analytics Cloud data warehouse.
- Analyze and document business and research requirements, collaborate with business analysts to elicit customer needs, and translate them into technical designs and test plans.
- Troubleshoot and resolve complex application, integration, and performance issues across on-premises and cloud systems, coordinating with vendors and on-site resources as needed.
- Create technical documentation and contribute to end-user training materials for supported systems and custom solutions.
- Collaborate with on-site and offshore team members, providing technical guidance, code reviews, and mentoring to less experienced staff.
- Contribute to solution architecture, standards, and best practices that improve reliability, security, and developer productivity in an Oracle-centric and cloud-ready environment., Caltech complies with the Fair Employment and Housing Act (FEHA) and the Americans with Disabilities Act (ADA). We consider reasonable accommodation measures that may be necessary for eligible applicants and employees to perform the essential functions of a position.
Requirements
- Bachelors or equivalent with at least 5 years of related professional experience.
- Expertise in an Oracle-centric environment:
- RDBMS
- SQL, and PL/SQL
- Oracle E-Business Suite (EBS)
- Oracle APEX
- Oracle Analytics Cloud (OAC)
- Oracle Data Integrator (ODI)
- Oracle Visual Builder
- Oracle Forms
- Strong background in systems integration (REST and SOAP APIs), data modeling/data warehousing, and application architecture.
- Proficient with version control (Git), and Microsoft Office tools including Excel, Word, PowerPoint, and Visio.
- Strong experience with business process analysis, SDLC, QA/testing methodologies, and change control procedures.
- Demonstrated ability to translate technical concepts for non-technical audiences and communicate effectively at all organizational levels.
- Strong written and verbal communications.
- Understand basic business and accounting concepts.
- Proven ability to work independently, manage competing priorities, and deliver results in a team-oriented environment.
- Commitment to application and data security best practices, continuous improvement, and exceptional customer service., * Master's degree or higher in computer science or similar technical field.
- Experience working with one or more of the following systems:
- Oracle Fusion Cloud (Oracle Cloud ERP)
- Oracle Integration Cloud (OIC)
- Huron Research Suite
- Assetworks AiM
- Jaggaer SciQuest
- Ellucian Advance
- Tableau
- SAP Concur
- Experience with SaaS platforms, cloud-native architectures and services (AWS, Oracle Cloud Infrastructure, or Azure).
- Exposure to data analytics, ETL pipelines, or AI/ML integrations.
- Experience collaborating with or supervising offshore development resources.
- Experience working in a non-profit or higher education environment.
- Experience as a business analyst working directly with customers to elicit business requirements and troubleshoot system issues.
- Interest in continuous learning and staying current with evolving technologies.
Benefits & conditions
$120,000 to $165,400 per year
The salary of the finalist(s) selected for this role will be set based on a variety of factors, including but not limited to, internal equity, experience, education, specialty and training.
As one of the largest employers in Pasadena, CA, Caltech is committed to providing comprehensive benefits to eligible employees and their eligible dependents. Our benefits package includes competitive compensation, health, dental, and vision insurance, retirement savings plans, generous paid time off (vacation, holidays, sick time, parental leave, bereavement, etc.), tuition reimbursement, and more. Non-benefit eligible employees will have access to some benefits such as onsite counseling and sick time. Learn more about our benefits and staff perks.