Position Summary: Date Posted 09/05/2017 Open Until Filled No Anticipated Application Deadline (Close date) 10/29/2017 Working Title Oracle Developer Job Classification Systems/Programmer IV Department Name 02025-Financial Information Systems Job Type Staff Position Number 0135419 Hiring Range TBD based on qualifications Position Description
The Department of Financial Information Systems at the University of Pittsburgh is seeking a qualified Oracle Developer. The incumbent will collaborate with end users to identify the needs and opportunities for creating and enhancing business analytics and reports.
The Oracle Developer will be responsible for the following duties: - Analyze user needs to develop specifications and document solutions to fulfill business requirements. - Design and build queries, reports, and dashboards using Oracle Business Intelligence Enterprise Edition ( OBIEE ) established frameworks and standards. - Perform basic ETL development activities related to loading data using Oracle ODI . - Assist management in the development of project plans, timelines, and documentation. - Lead client demonstrations and requirement gathering meetings. - Review application prototypes and functionality enhancements.
Education Required Baccalaureate Minimum Related Experience Level Required 5-6 years experience Additional Education and/or Experience Essential to the Position
Bachelor's degree in Information Science, Computer Science, Business or related field including 5-6 years reporting, analytics and data warehouse experience. Knowledge of database concepts, systems architecture and data structures. Proficient with SQL and Advanced Excel, Experience with Oracle DBMS. Experience working with Oracle Business Intelligence Enterprise Edition (OBIEE) preferred. General Accounting or HR applications experience preferred but not required.
The following PA Act 153 clearances and background checks may be required prior to commencement of employment and as a condition of continued employment: PA State Police Criminal Record Check, FBI Criminal Record Check, PA Child Abuse History Clearance.
Background Check For position finalists, employment with the University will require successful completion of a background check. Assignment Category Regular, Full-Time Percent Effort 100 Scheduled Work Hours 8:30 a.m. - 5:00 p.m. If Varied Work Schedule, Please Specify If Part Time, Actual Standard Weekly Hours Campus Pittsburgh University Benefits
The University offers an excellent comprehensive benefits package for all full-time and part-time regular employees including:
Education benefits and a retirement plan with employer match
Group medical insurance, life insurance, and optional vision and dental insurance
Free transit service within Allegheny County for employees of the Oakland campus (Port Authority Transit)
Time off benefits including vacation, sick and personal time
Founded in 1787, the same year the U.S. Constitution was signed, the University of Pittsburgh is one of the oldest institutions of higher education in the United States. One of three state-related research universities in Pennsylvania, Pitt is a member of the Association of American Universities (AAU), which comprises 62 preeminent doctorate-granting research institutions in North America.
Pitt... faculty members have expanded knowledge in the humanities and sciences, earning such prestigious honors as the National Medal of Science, the MacArthur Foundation’s “genius” grant, the Lasker-DeBakey Clinical Medical Research Award, and election to the National Academy of Sciences and the Institute of Medicine. Pitt scientists have defeated polio, unlocked the secrets of DNA, lead the world in organ transplantation, and pioneered TV and heavier-than-air flight, among numerous other accomplishments.
Pitt students have earned Rhodes, Goldwater, Marshall, and Truman Scholarships, among other highly competitive national and international scholarships.
Alumni have pioneered MRI and TV, won Nobel and Pulitzer Prizes, led corporations and universities, served in government and the military, conquered Hollywood and The New York Times bestsellers list, and won Super Bowls and NBA championships.