Business Intelligence Technical Lead Location : Madison, WI Length : 3 years
Job Description:
Role : Business Intelligence Technical Lead
Location : Madison, WI
Client : The State of Wisconsin
Length : 3 years
Full Job Description:
We are seeking a highly qualified individual to fill the role of Data Warehouse Technical Liaison. The individual in this role would be supporting the management, design, and support of multiple Child Care, Working Families and Child Welfare warehouses. The individual in this role will:
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 8 to 10 years of experience with large and complex database management systems, business intelligence tools and systems.
Qualification Rating - Must Have:
Candidate must fill out their specific years of experience in the following areas and their resume must match prior to submittal!! Minimum requirements are listed below.
Administration - Customer Service
Problem resolution (development and implementation) * 7 Yrs.
Respond to customer requests (verbally and in writing) * 7 Yrs.
Administration - Project Management
Experienced project manager or leader * 4 Yrs.
Expertise in implementation of large complicated models and processes * 5 Yrs.
Administration - Technical Writing
Experience in Technical Writing and Documentation * 7 Yrs.
General Competencies
Analytical/problem solving skills *7 Yrs.
Excellent oral and written communication skills * 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 * 5 Yrs.
Information Technology - Databases
Ability to navigate and query a relational database (Oracle) to both develop reports * 7 Yrs.
Data analysis * 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 * 7 Yrs.
Information Technology - Design
Develop design specifications * 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 * 7 Yrs.
Nice to Have
Administration - Project Management
Demonstrated experience in the design and utilization of performance measures and reports * 2 Yrs.
General Competencies
State of Wisconsin Privacy Regulations *Yes
Information Technology - Languages/Tools
Dashboarding/Business Objects Xcelsius * 2 Yrs.