Position Type: Computer and Information Technology
Programmer Analyst II
Department Description:
Detailed Description:
Programmer Analyst II; Enterprise Applications
Posting # 2657
Department Description:
At Enterprise Applications (EA) we provide enterprise technology services for business and academic information systems. We collaborate with business users across campus to purchase, implement and maintain enterprise technologies for the university's diverse business and academic needs. Additionally, we innovate mobile and web applications designed in-house to enhance the student experience at USD, and empower students to improve their overall success.
University Description:
The University of San Diego, a contemporary and engaged Roman Catholic institution, was founded by the Diocese of San Diego and the Society of the Sacred Heart in 1949. Governed by an independent board of trustees since 1972, USD remains committed to a liberal arts education grounded in the Catholic intellectual tradition and the pursuit of truth, goodness and beauty. Inspired by this centuries old tradition of Catholic higher education, the University welcomes people of all faith traditions and any, or no, religious background. The future success of USD relies on the contributions of those who seek to foster the development of engaged global citizens and an earnest confrontation of humanity's urgent challenges.
Detailed Description:
The Programmer Analyst II is a hands-on technical position that is responsible for providing high quality technology solutions to business departments across the University. The position pro-actively implements and takes ownership of system production issues and development projects as assigned by the Manager and Lead Developer. This position will work directly with users to understand their technology needs and will prepare design documents, program, and test technical solutions.
This position will assist in providing oversight for the technical maintenance of the various ERP application systems, smaller vendor applications, and interfaces between the various systems using best practices and following Software Development Life Cycle (SDLC) procedures.
Duties & Responsibilities:
Systems Analysis and Project Management
Analyze the user requirements document and consult with peers and business users as well as other contacts in the field to provide a well-researched solution using the integrated ERP technologies such as Ellucian applications, Oracle applications, CBORD applications, Salesforce applications, other smaller applications, Banner Document Management Suite (BDMS), Luminis Portal, ODS/Cognos Reporting and workflow
Act as Project Lead for small projects
Work with team to create a project plan with level of detail depending on the complexity of the project, to outline tasks and timeline to implement solution. Execute and regularly update the plan. Notify supervisor of possible delays.
Support and provide guidance for application upgrades by ensuring thorough testing of new changes as well as existing interfaces etc.
Recommend improvements in processes, promote a positive and collaborative environment and communicate concerns in a constructive and timely manner.
Pro-actively manage and take ownership of assigned productions issues:
Issue is properly identified
Thorough analysis to determine the underlying cause of problem
User departments have been involved
Involve peers when designing solution.
Well planned and executed testing strategy.
Production implementation is well coordinated
Escalation of issues as needed
Programming and Testing
Use knowledge of Oracle Concepts, development tools such as Oracle*Developer Suite 10g/11g toolset , SQL Developer and programming languages such as PL/SQL and functions such as stored procedures and triggers to provide complete technical solutions.
Use Application APIS as much as possible to build internal and external interfaces.
Modify seeded application reports as needed using Oracle*Developer Suite 10g/11g toolset or other appropriate toolset for modifying reports.
Work with senior team members to architect technical solutions using deep understanding of the appropriate application technical architecture as well as middle tier integration technologies to ensure all future enhancements or integration solutions are well planned and architected.
Diagnose/resolve technical problems independently, articulate and discuss solution with peers in a confident manner with a view to getting input to provide the best solution for USD.
Multi task in the fast-paced, production environment to juggle priorities as needed to provide resolution to high profile technical issues.
Diagnose performance issues using SQL trace technology as well as database explain statements and ability to analyze output of these traces.
Supervise/Mentor staff and miscellaneous tasks as assigned by Manager
Supervise junior analysts/programmers as assigned
Set work schedules, goals and objectives;
Stay current with technology trends.
Recommend and evaluate relevant software products.
Job Requirements:
Minimum Qualifications:
Bachelor's degree in Information Systems, Business Administration, or related discipline or an equivalent combinations of experience and education or certification.
Minimum of 3 years of experience as a Programmer/Analyst or equivalent in an information systems development environment.
Preferred Qualifications:
Experience with integrating data in and out of Workday leveraging Workday SOAP APIs, Document Transformation, Enterprise Interface Builder (EIB), Cloud Connect, and Workday Studio is highly desirable
One to three years hands-on technical experience with at least three of the following technologies:
Relational database expertise, design and application tuning. (Oracle, SQLServer, MySql)
Performance Expectations - Knowledge Skills and Abilities:
Developing interfaces/integrations to migrate data between integrated systems both on premise and cloud based.
Data integration toolset, ie. Mulesoft, Talend, Informatica
Strong Database development experience in writing functions, packages, procedures, triggers and views in Oracle PL/SQL.
Experienced in using J2EE Design patterns for design/development of complex software applications.
Salesforce technical development (APEX, Lightning components, Process Builder, formula fields)
Good understanding of SOA technologies, REST and SOAP web services
Good understanding of web application technologies such as Javascript, CSS, HTML/HTML5
Good understanding of deploying web applications to Weblogic and Tomcat
Mobile Technologies.
Experience implementing ERP systems such as Ellucian He Banner System, Oracle e-Business Suite (EBS), or Salesforce as well as supporting such systems in a production environment
Experience in handling and supporting patches and upgrades in a production environment.
Knowledge of and experience with Oracle development tools such as Oracle*Developer Suite 10g/11g toolset, SQL Developer, including OracleForms, SQL, PL/SQL, stored procedures and triggers.
Understanding of database technical architecture, APIs, middle tier integration, Webservices and integration.
Demonstrated ability to diagnose/resolve technical problems independently and to lead development and implementation of new and complex applications.
Strong interpersonal skills and ability to communicate effectively with technical staff as well as non-technical users.
Clearly demonstrated ability to multi task and work in a collaborative team environment and to work cooperatively with others.
Tools & Equipment Used:
Windows personal computer, Microsoft Office applications, Enterprise Applications software.
Background check: Successful completion of a pre-employment background check.
Degree Verification Requirement: Persons offered employment in this position will be required to provide official education transcripts for degree verification purposes.
Posting Salary: Commensurate with experience; Excellent Benefits.
The University of San Diego offers a very competitive benefits package, to include medical, dental, vision, a retirement contribution given to you by the University (with three year vesting period), and access to on-campus Fitness Centers. Please visit the benefits section of our website to view all of the perks and benefits that USD has to offer.
Special Application Instructions:
Resume and Cover Letter Required
Visit https://careers.pageuppeople.com/867/cw/en-us/job/494181/programmer-analyst-ii to complete our online application. In addition, please upload a cover letter and resume to your application profile for the hiring managers' review. If you have any questions or difficulties please contact the Employment Services Team at 619-260-6806, or email us at jobs@sandiego.edu
Additional Details:
Hours: 37.5
Closing date: September 19, 2020
Note: External job postings will be up for at least five days. After that time, applications will be reviewed by the hiring manager/committee throughout the posting period. A candidate may be selected at any time which could then close this posting on a date earlier than listed.
The University of San Diego is an equal opportunity employer committed to diversity and inclusion and is especially interested in candidates who can contribute to the diversity and excellence of the campus community.
