Business Intelligence Technical Lead

About the role

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

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.

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.

Additional Information: LOCAL CANDIDATES REQUIRED

An in person interview will be required before a final hire is made

History & Overview

Symphony Corporation delivers information technology solutions to health systems by synchronizing clinical, financial and administrative data. Our approach merges the client’s existing expertise, infrastructure, and technology assets with Symphony’s well-tested software product development processes, specific industry knowledge, proven experience and technology expertise.

The end result is rapid implementation, cost efficiencies and scalable technology applications that meet current and future business requirements. Since 1997, our thought leadership and technology solutions, including our SymphonyCare platform and S.A.F.E. methodologies, have enhanced the performance of 70 of the nation’s top 100 health systems.

Our development processes have met stringent CMMi Level IV standards, making Symphony an industry leader in product development and custom application development.