This role is a 6 Month Contract, on-site M-F and requires someone with a P&C (Property and Casualty) / Insurance Industry background.

The Data Analyst is a hands-on position focusing 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 architecture. Furthermore, this data warehouse architecture will measure performance in all aspects of the organization’s operations.

Responsibilities:

Work with business stakeholders and IT teams to analyze and resolve data issues for the enterprise data warehouse.
Create source (OLTP applications) to target (DWH) mapping documents to capture additional application data elements.
Load the source-to-target mapping documents from source systems into the enterprise data warehouse.
Collaborate with the ETL team to ensure the source-to-target mapping documents are in the correct ETL code.
Ensure the ETL code aligns with STM requirements.
Perform data validation, to ensure correct data movement into the enterprise data warehouse architecture.
Consult with reporting teams to develop a general understanding of the data warehouse model / optimal ways to use it.

Requirements:

Background working in the P&C (Property and Casualty) / Insurance Industry.
5+ years’ experience in data analysis – extracting OLTP data within an enterprise data warehouse.
Possess 5+ years of Policy & Claims Insurance subject-matter expertise.
Advanced level SQL knowledge.
Possess optimal knowledge of concepts and frameworks for Data Warehousing, ETL, and BI Architectures.
Capable of creating and tuning Semantic layer Reporting Views.
Able to facilitate data discovery sessions with business subject-matter experts.
Proven knowledge of RDBMS platforms (e.g., SQL Server, DB2), with experience in generating DDL.
Possessing knowledge of Guidewire Policy Center, Guidewire Claims Center, SAP FS-RI & SAP FS-CD applications with their data is considered a plus.

#J-18808-Ljbffr

Simplex Hires LLC

New Jobs

Senior Accountant - Manufacturing Industry

Senior Guidewire PolicyCenter Developer - P&C / Insurance