Business Intelligence Technical Lead II

BUSINESS INTELLIGENCE TECHNICAL LEAD II

A direct Madison, WI client seeks a highly qualified individual to fill the role of the Child Care Data Warehouse Technical Liaison.

ESTIMATED START DATE: 8/10/2015 ESTIMATED END DATE: 08/11/2018

DESCRIPTION:
Lead, Mentor, and Consult for 17 technical staff including Data Modelers, Informatica developers, Business Objects Specialists, and Dashboard/Xcelsius developers.

Work with enterprise wide business and IT senior management to understand and prioritize data and information requirements.

Solve complex technical problems.

Optimize the performance of enterprise Business Intelligence tools by defining data to filter and index that add value to the user.

Create testing methodology and criteria.

Design and coordinates a curriculum for coaching and training customers in the use of Business Intelligence tools to enhance business decision-making capacity.

Develop standards, policies and procedures for the form, structure and attributes of the Business Intelligence tools and systems and validate that standards are being met.

Develop data/information quality metrics.

Research new technology and develops business cases to support enterprise wide Business Intelligence solutions. Participate in special projects as required.

Have 7 to 10 years of experience with large and complex database management systems, Business Intelligence tools and systems.

QUALIFYING MATRIX (PASS/FAIL)

MUST HAVE

Administration - Customer Service

Problem resolution (development and implementation) and 7 Yrs.

Respond to customer requests (verbally and in writing) and 7 Yrs.

Administration - Project Management

Experienced project manager or leader and 4 Yrs.

Expertise in implementation of large complicated models and processes and 5 Yrs.

Administration - Technical Writing

Experience in Technical Writing and Documentation and 7 Yrs.

GENERAL COMPETENCIES

Analytical/problem solving skills 7 Yrs.

Excellent oral and written communication skills and 7 Yrs.

Excellent organization, analytical, and communication skills.

INFORMATION TECHNOLOGY - APPLICATIONS

Ability to develop and implement quality assurance processes and procedures including test/use cases and 5 Yrs.

Information Technology - Databases

Ability to navigate and query a relational database (Oracle) to both develop reports and 7 Yrs.

Data analysis and 7 Yrs.

Data Warehouse - Experience in data warehouse design and development 7 Yrs.

Data Warehouse - Experience in requirements gathering for data warehouse 7 Yrs.

Data Warehouse - Performance tuning 7 Yrs.

Experience in extract, transform, and load coding using Informatica 7 Yrs.

Knowledge of Oracle PL/SQL and 7 Yrs.

INFORMATION TECHNOLOGY - DESIGN

Develop design specifications and 7 Yrs.

Knowledge of Kimball data warehouse design principals 5 Yrs.

Information Technology - Languages/Tools

Business Objects or other BI tools 5 Yrs.

Information Technology - Testing

Conduct unit and system tests and 7 Yrs.

NICE TO HAVE

Administration - Project Management

Demonstrated experience in the design and utilization of performance measures and reports and 2 Yrs.