Business Intelligence Technical Lead

Symphony Corp; Madison (WI); On-site; USD 100,000 - 130,000; Full time

Job summary

Symphony Corp is seeking a Business Intelligence Data Architect/Developer consultant to assist the University of Wisconsin-Madison in implementing OBIEE 12c. The role requires designing and developing complex solutions, leading implementation, and ensuring data access for users.

The successful candidate should have extensive experience with OBIEE 12c, data warehousing, and be able to work independently while mentoring peers. Local candidates are required for this position.

Qualifications

• Experience with OBIEE 12c implementation and maintenance.
• 15+ years in data architecture or related fields.
• Ability to conduct independent work and mentor junior staff.

Responsibilities

• Design and develop complex technology solutions.
• Lead implementation of a stable BI solution.
• Replace Hyperion Query Library at UW-Madison.

Skills

Oracle Business Intelligence Enterprise Edition v. 12c

Database design and maintenance

Data warehousing

Complex problem-solving

Education

Bachelor's degree or equivalent experience

Tools

OBIEE 12c

Hyperion Interactive Reporting

Job description

Job Description

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.

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.
• 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 – 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
• 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