Job Description

The University of Wisconsin-Madison is a large university in terms of student enrollment (42,000), physical size (935 acres on the main campus) and employees (16,000 staff and 2,000 faculty). As a top academic and research institution, the UW-Madison is seeking to provide robust business intelligence support for the teaching, research, community service and administrative missions of the University.

• The UW-Madison is seeking Business Intelligence Data Architect / Developer consultant with experience including Oracle Business Intelligence Enterprise Edition v. 12c (OBIEE 12c). The successful proposer will assist the University in its goal of implementing OBIEE 12c for UW-Madison (Note that the foundation for OBIEE 12c will be implemented by the UW System, but UW Madison needs to set up its own area of 12c for the best implementation for its campus).

Key Responsibilities for this position include, but are not limited to:

• Design and develop highly complex technology solutions.
• Act as an expert architecture resource
• Recommend best practices for Enterprise BI solution
• Lead the design and implementation of a quality and stable solution the successful contractor must have availability from September 2016 through, at a minimum, March 2017.

Project Background Information:
Key Project Goals:

• Replace Interactive Reporting (Hyperion) Query Library at UW-Madison
• Ability for users to successfully use and take advantage of the OBIEE 12c's full capabilities
• Ability for users to access, without interruption, the data/information they need to conduct their work

Business Intelligence Vision:

Long-term vision:

• Ability to report off of both Institutional and non-Institutional Administrative and Local data sets.
• Developing a process to bring non-Institutional data sets into the OBI 12c environment
• Implementing institutional data definitions within the OBI 12c environment.
• Making the OBI 12c environment more efficient by re-architecting data structures.
  
  Phases to get to vision - This work effort includes only phase 1:

• Area specific Semantic Layers Developed

• Allow users to continue to do their work using an array of tools without interruption including OBI 12c
• Direct connection to source data models (primarily the InfoAccess Data Warehouse)
• Hyperion Interactive Reporting Query Library retired (currently ~1700 users)
• Migrate ~300 Hyperion Interactive Reporting Client users to OBI12c and retiring the Hyperion Client.
• Introduce user friendly language and an easier interface for users to perform their reporting and data analysis work
• Assist UW-Madison SME's and training staff in leveraging OBIEE tools, e.g. dashboards could replace some converted queries

• Re-architected data structures developed (future project)

• Semantic layer developed for specific area
• Reports migrated to use a basic semantic layer
• Common user friendly language and data definitions across the campus (advanced semantic layer)
• Full use of OBIEE functionality

TapFin Job Description for Business Intelligence Technical Lead III:Design, develop, and maintain relational databases for data storage and data mining. Perform data warehouse design and testing, including data design, database architecture, metadata, and repository creation. Develop processes and procedures for entering information into data warehousing systems and for ensuring reliability of information entered. Seek continuous improvement in performance of data warehouse and ensure security of data. Recognized as expert in field, knowledgeable of emerging trends and industry practices. Conducts the most complex and vital work critical to the organization. Works without supervision with complete latitude for independent judgment. May mentor less experienced peers and display leadership as needed. Typically requires 15 or more year's experience or equivalent education.

Qualifications

Additional Information

1. LOCAL CANDIDATES REQUIRED
2. An in person interview will be required before a final hire is made