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.
Key Skills: