Data Analyst With Guidewire

Data Analyst with Guidewire
Alpharetta, GA; Conshohocken, PA; Florham Park, NJ, Purchase NY

The Data Analyst is a hands-on position focused on defining the data needs for the enterprise data warehouse. The position will work within IT to help Sompo International create an industry-leading data warehouse that measures performance of all aspects of the company’s operations.

ROLE RESPONSIBILITIES

• Works with business stakeholders and IT application teams to define data needs for the enterprise data warehouse

• Creates source (GW PC) to target (DWH) mapping documents to capture application data elements for loading from source systems into the enterprise data warehouse

• Collaborates with ETL team to ensure that source to target mappings are correctly translated into ETL code

• Performs data validation to confirm data is moved into the data warehouse correctly

• Works with reporting teams to assist them in understanding the data warehouse model and optimal ways to use it

TECHNICAL QUALIFICATIONS

• 5 + years P&C Insurance subject matter experience (GW Policy)

• 10 + years of data analysis experience extracting OLTP data specifically for a data warehouse

• Advanced SQL knowledge working with extracting data from OLTP applications

• Extensive knowledge of Data Warehousing, ETL and BI Architectures, concepts and frameworks

• Capable of creating and tuning Semantic layer Reporting Views

• Capable of facilitating data discovery sessions involving business subject matter experts

• Knowledge of RDBMS platforms (e.g. SQL Server, DB2) with experience in generating DDL

GENERAL QUALIFICATIONS

• Knowledge of Guidewire Policy Center, Guidewire Claims Center applications and their data is a huge plus

• Strong interpersonal skills and ability to work as part of a team