Programmer/Analyst

Location
Los Angeles, California
Posted
Mar 16, 2017
Administrative Jobs
Technology, Analysts & Programming
Institution Type
Four-Year Institution

The Programmer/Analyst is a member of the Institutional Information Systems Group (ISG) of ITS that supports the Occidental College community’s access to and use of institutional information.  Working with the BI Manager and cross-functional teams, this position will analyze, develop, and implement complex computer applications and databases in order to meet users’ operational and analytical reporting needs; document and maintain specified areas of application software; coordinate execution of new projects; and act as a resource to campus constituents.  The position augments the decision support service capability offered through ITS.

Essential Functions

  • Conducts business process review and analysis; implements business process improvement to streamline services, create efficiencies; and facilitates continuous technology improvement.
  • Interprets users’ business needs and translates them into application and operational requirements.
  • Configures information systems to support and enhance business processes.
  • Designs and develops operational and statistical dashboards/reports using Argos to query and extract data from large databases.  Produces data reports from complex data sets with optimization in mind. 
  • Designs and develops database objects (datamarts, functions, views, tables, packages, etc.) using PL/SQL to support reporting needs.
  • Works with management and end-users to define reporting and business analysis needs and to develop appropriate information access strategies.
  • Evaluates the technical needs of the departments across campus and delivers practical and innovative solutions to software challenges.
  • Provides systems analysis for Ellucian’s Banner ERP and other administrative applications, often spanning multiple functional areas.
  • Works independently to understand the technical operation of a wide variety of software and services.
  • Performs complex analytical and technical work in relation to various computer applications, databases, websites, and systems.
  • Conducts user training and workshops.
  • Other duties as assigned.

Qualifications

  • A baccalaureate degree and three years’ experience working in a software development environment, or an appropriate combination of training, work experience, and skills.
  • 3+ years of experience writing complex SQL.
  • 3+ years of experience in designing, developing, and tuning Oracle PL/SQL (packages, procedures, functions, and triggers).
  • Experience with SQL Developer and SQL Loader.
  • Proficient with report writing and data mining techniques using SQL, PL/SQL, and ETL processes.
  • Strong knowledge of Oracle database fundamentals and relational database concepts.
  • Ability to effectively and independently recommend, document, communicate, implement, and sustain improvements in processes, procedures, and operations.
  • Knowledge of software life-cycle, including design, testing, and implementation techniques.
  • Excellent troubleshooting and analytical problem-solving skills.
  • Demonstrated skills in verbal communication and technical writing, as well as the ability to explain technical subjects to non-technical audiences.
  • Ability to use effective interpersonal and communications skills, including tact and diplomacy, while forging strong working relationships with IT professionals and end-users.
  • Strong organizational skills and the ability to work both independently and in teams on small- and large-scale projects in a fast-paced, multi-tasking environment.
  • Must have a collaborative spirit and the ability to contribute meaningfully to group discussions and work within a high performing team to create innovative solutions to complex problems.
  • Testing, debugging, and documenting software programs. Maintaining and modifying existing software applications. 
  • Current standards in relation to the compliance of security and data protection.
  • Ability to maintain confidentiality of work-related information and materials.

Desired Qualifications

  • Experience with Enterprise Resource Planning systems with an Oracle back-end database (e.g. Ellucian Banner or PeopleSoft) or educational software applications such as Student, Finance, Advancement, or Human Resources systems.
  • Performing upgrades to administrative database and software applications such as PowerFAIDS, Mainsaver, Kronos, and Resource25.
  • Experience with Cognos, Argos, or Crystal Reports.  
  • Experience working in a higher education setting is desirable.
  • Demonstrates Initiative: Works proactively to identify deficiencies, and to recommend and/or implement the necessary solutions, methods, procedures, or projects to correct them.
  • Action Oriented: Works diligently and exudes a high level of energy, thinks quickly on one's feet, makes things happen, maximizes spontaneous opportunities and eagerly pursues new challenges.
  • Analytical: Works to understand a complex situation, issue or problem by breaking it down into manageable pieces. Uses a step-by-step approach to evaluate consequences and implications.
  • Problem Solving: Analyzes interrelated elements of problems and works systematically to solve them; uses sound judgment to develop efficient and feasible resolutions to challenging issues.

Application Instructions

Please submit a resume and cover letter explaining how your qualifications meet the requirements of the position to resumes@oxy.edu.

Apply for Programmer/Analyst

Already uploaded your resume? Sign in to apply instantly

Apply

Upload from your computer

Or import from cloud storage

Your Resume must be a .doc, .pdf, .docx, .rtf, and no bigger than 1Mb


4000 characters left


By applying for a job listed on Inside Higher Ed Careers you agree to our terms and conditions and privacy policy. You should never be required to provide bank account details. If you are, please email us.