*REPLY TO: [email protected]* *Job Title: Data warehouse Architect/BI Architect w/P&C experience*
* Location: Madison, WI Duration: 6+ Months* *MUST BE GC OR USC*** *MUST HAVE PROPERTY AND CASUALTY INSURANCE EXPERIENCE*** *LAST 4 DIGITS OF SSN#. MUST RESPOND TO SKILLS INVENTORY BELOW (REQUIRED SKILLS) WITH NUMBER OF YEARS AND SKILL LEVEL ON A 5 POINT SCALE (1=LOW, 5=HIGH)* This role requires an experienced data architect with a minimum of 10 years Business Intelligence experience, must have data warehouse architecture and modeling experience with P&C Insurance, should also have design experience, communication skills, and work well in a team environment. Knowledge of ETL tools such as Informatica; database environments (Oracle, DB2); and reporting tools such as Business Objects and SAS is a plus. Experience with data archiving experience would be a plus. This is a senior position that requires candidates to direct/lead modeling staff in the creation of comprehensive BI models supporting all P&C business functions. Candidate should be able to quickly understand existing application architectures and American Family standards. Include a skills grid on the email submittal with *number of years experience *with each *required skill* and how they *rate themselves on a scale of 1-5 *is desired (1=weak, 3= average, 5=expert). *Required* 1. Knowledge and experience in development of data warehouse architecture for large volume analytic solutions. 2. Experience in designing data models to support reporting and analysis. Knowledge of industry accepted design techniquesincluding star and snowflake schemas. 3. Experience in providing technical leadership to project team members. 4. Knowledge and development experience with one or more ETL tools such as Informatica. 5. Database development experience in one or more market-leading database environments such as Oracle, DB2. 6. Knowledge and experience with OLAP and reporting tools such as Business Objects, SAS, and Essbase utilizing both relational and multidimensional tool architectures. 7. Coordinate structure changes with common XML integration model 8. Collaborates with technical advisor and strategic architect on project deliverables and timelines 9. Strong experience using enterprise modeling tool such as ERWin 10. Strong knowledge in XML schema definition 11. Excellent presentation and management communication skills 12. Strong collaboration skills with both business and IT teams 13. Very strong overall technical skills 14. Strong knowledge of relational concepts 15. Strong verbal and written communication skills a must 16. Experience developing BI solutions for the P&C Insurance Industry 17. Strong analytical and SQL skills 18. Team player, quick learner 19. Self-starter with good work ethic 20. Ability to complete tasks with little supervision 21. Strong organizational skills *Desired* 1. A general knowledge of data quality approach and strategy 2. Knowledge of other tools used in Business Intelligence projects, such as data quality analysis, packaged analytics, performance management, etc 3. Knowledge of best practice BI project approaches and strategies 4. Knowledge of the business information needs addressed by BI in one or more functional or industry areas 5. Understanding of process metrics 6. Knowledge and experience of enterprise design architectures 7. Experience in establishing and maintaining an enterprise approach to logical data modeling 1. Resume review & interviews will start as early as the week of Nov 22nd 2. Interviews (Video conference or In-person, *in-person preferred)*** *Required: TOP three skills* 1. Knowledge and experience in development of data warehouse architecture for large volume analytic solutions with specialization in one or more of the following: property & casualty policy lifecycle, property & casualty claims, customer, finance, general ledger, billing 2. Strong leadership and excellent communication skills a MUST! 3. Experience in designing data models to support reporting and analysis. Knowledge of industry accepted design techniques including star schemas with specialization in one or more of the following: property & casualty policy lifecycle, property & casualty claims, customer, finance, general ledger, billing 4. Experience in providing technical leadership to project team consisting of developers, analysts, DBAs and data modelers. 5. Strong experience using enterprise modeling tool *Desired* 1. Experience with Agile methodologies a plus 2. A general knowledge of data quality approach and strategy 3. Knowledge of other tools used in Business Intelligence projects, such as data quality analysis, packaged analytics, performance management, etc. 4. Knowledge of best practice BI project approaches and strategies 5. Knowledge and experience of enterprise information architectures 6. Experience in establishing and maintaining an enterprise approach to logical data modeling 7. Knowledge and development experience with one or more ETL tools such as Informatica. 8. Database development experience in one or more market-leading database environments such as Oracle, DB2. 9 Knowledge and experience with OLAP and reporting tools such as Business Objects, SAS, and Essbase utilizing both relational and multidimensional tool architectures. 10. Coordinate structure changes with common XML integration model 11. Experience with XML schemas *REPLY TO: [email protected]* If you have any query, feel free to talk to me. Thanks & Regards, Vipin D Kaushal |Dynamic Software Services, Inc. Team Lead - Recruitment 766 Sutter Street -13.San Francisco, CA- 94109 *Office:* 415-599-7815|| Fax: 415-520-5437 *Email:* [email protected] <[email protected]%20> ||www.dyssinc.com *Yahoo IM:* click2vipin || *G-Talk:* click2vipin http://in.linkedin.com/pub/vipin-kaushal/b/223/570 -- You received this message because you are subscribed to the Google Groups "SAP ABAP" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sap-abap?hl=en.
