Sr Data Analyst (Data Warehouse)Location: Purchase, NY or Florham Park, NJ; (Day 1 onsite with Hybrid model)Required skills:Guidewire Policy centerDatawarehouseInformaticaTechnical qualifications:10+ years of data analysis experience extracting OLTP data specifically for a data warehouse5+ years P&C Insurance subject matter experience (Guidewire Policy center)Advanced SQL knowledge working with extracting data from OLTP applicationsExtensive knowledge of Data Warehousing, ETL and BI Architectures, concepts and frameworksCapable of creating and tuning Semantic layer Reporting ViewsCapable of facilitating data discovery sessions involving business subject matter expertsKnowledge of RDBMS platforms (e.g. SQL Server, DB2) with experience in generating DDLExperience in Guidewire policy Center