Business Intelligence Developer, Oracle Reporting

University of Chicago

University of Chicago

Software Engineering, Operations, Data Science
Chicago, IL, USA
Posted on Tuesday, February 13, 2024


F&A ITS - Enterprise Applications and Services

About the Department

ITS collaborates with campus partners to support the mission of the University of Chicago through the consistent delivery of high-quality solutions and services. We provide secure, stable, and reliable infrastructure and applications to support the mission of the University. We support and enable faculty research and teaching with the effective use of technology. We simplify the technology experience for faculty, students, alumni, and staff, and we ensure technology is mobile-friendly and accessible. We identify, manage, and mitigate the technology risks of the University.

Job Summary

The Business Intelligence Developer will work as part of a team and under specific direction to build Business Intelligence (BI) and other analytic applications, using best practice approaches and a structured project methodology; work under the guidance of a manager or technical lead to support and maintain analytic applications using a coordinated, ITIL-based support model; participate with team members to enhance analytic systems to achieve an integrated reporting and analysis environment; work with University users to effectively leverage analytic systems and tools.


  • Designs, builds and maintains beautiful and functional visualizations (reports and dashboards).
  • Solves complex problems and identifies opportunities for technical improvement and performance optimization of new and existing systems.
  • Reviews and tests code to ensure appropriate standards are met.
  • Profiles data and document objects, business rules, and caveats.
  • Performs and documents data analysis, data validation, and data mapping/design.
  • Partners with IT teams and business professionals to establish data-driven policies and strategies across the organization.
  • Works to achieve an integrated reporting and analysis environment, effectively leveraging analytical systems and tools.
  • Participates in requirements analysis.
  • Engages in translating requirements into a scope document.
  • Liaise with users to ensure deliverables are meeting or exceeding expectations.
  • Provides break/fix support and communicates issues to users as defined by IT Services standards.
  • Administers access control.
  • Troubleshoots and tunes BI and analytic applications.
  • Implements training and help-desk activities.
  • Participates in planning, testing, and roll-out of patches and upgrades to the BI and analytic software.
  • Provides support related to software installation and troubleshooting, performance monitoring, data downloads, etc.
  • Participates in the development and promulgation of BI and analytic system standards and procedures.
  • Works with users to ensure deliverables are meeting or exceeding expectations. Provides support and communicates issues to users as defined by IT standards.
  • Plans, tests and guides roll-out of patches and upgrades to the BI and analytic software. Solves problems in the development and interpretation of BI and analytics system standards and procedures.
  • Performs other related work as needed.

Minimum Qualifications


Minimum requirements include a college or university degree in related field.

Work Experience:

Minimum requirements include knowledge and skills developed through 5-7 years of work experience in a related job discipline.



Preferred Qualifications


  • Bachelor's degree.


  • Background in business, information management, or related field.

Technical Skills or Knowledge:

  • Designing and building dashboards and reports deliverables using OTBI, BI Publisher and FR Studio with an Oracle Financials back end.
  • Working within the ITIL framework including incident, service, problem, and change management processes and procedures.
  • Advanced knowledge of OTBI, BI Publisher and FR Studio.
  • Familiar with Tableau and Business Objects.
  • Working knowledge coding with SQL to profile data and troubleshoot.
  • Knowledge of higher education administrative systems, data, and business processes.
  • Understanding of project management methodology.
  • Application development skills primarily focused on BI tools but are not limited to OTBI, BI Publisher and FR Studio.
  • Expertise using both formal software lifecycle development and project management.
  • Develop applications (e.g., requirements gathering and analysis, framework, deliverable development, testing, etc.).
  • Strong skills with Microsoft Office including Excel.

Preferred Competencies

  • Analytic mindset to synthesize technical, functional, and user inputs, and problem-solve.
  • Good sense of design.
  • Good written and oral communication skills to support users.
  • Driven to provide an excellent customer service experience.
  • Strong sense of accountability for completing work within defined scope and timeline and within project management.
  • Multi-task effectively.
  • High attention to detail and accuracy.
  • Commitment to working in a collaborative team environment.

Working Conditions

  • Hybrid work schedule.

Application Documents

  • Resume/CV (required)
  • Cover Letter (required)

When applying, the document(s) MUST be uploaded via the My Experience page, in the section titled Application Documents of the application.

Job Family

Information Technology

Role Impact

Individual Contributor

FLSA Status


Pay Frequency


Scheduled Weekly Hours


Benefits Eligible


Drug Test Required


Health Screen Required


Motor Vehicle Record Inquiry Required


Posting Statement

The University of Chicago is an Affirmative Action/Equal Opportunity/Disabled/Veterans and does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender, gender identity, national or ethnic origin, age, status as an individual with a disability, military or veteran status, genetic information, or other protected classes under the law. For additional information please see the University's Notice of Nondiscrimination.

Staff Job seekers in need of a reasonable accommodation to complete the application process should call 773-702-5800 or submit a request via Applicant Inquiry Form.

We seek a diverse pool of applicants who wish to join an academic community that places the highest value on rigorous inquiry and encourages a diversity of perspectives, experiences, groups of individuals, and ideas to inform and stimulate intellectual challenge, engagement, and exchange.

All offers of employment are contingent upon a background check that includes a review of conviction history. A conviction does not automatically preclude University employment. Rather, the University considers conviction information on a case-by-case basis and assesses the nature of the offense, the circumstances surrounding it, the proximity in time of the conviction, and its relevance to the position.

The University of Chicago's Annual Security & Fire Safety Report (Report) provides information about University offices and programs that provide safety support, crime and fire statistics, emergency response and communications plans, and other policies and information. The Report can be accessed online at: http://securityreport.uchicago.edu. Paper copies of the Report are available, upon request, from the University of Chicago Police Department, 850 E. 61st Street, Chicago, IL 60637.