• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• W2-Permanent

• W2-Contract

• Contract to Hire

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 6th Feb 2024

Candidates must be local from these places

Boston, MA; Charlotte, NC; Colorado Springs, CO; Conshohocken, PA; Dallas, TX; Fargo, ND; Florham Park, NJ; Garden City, NY; Houston, TX; Jacksonville, IL; Lenexa, KS; Los Angeles, CA; Lubbock, TX; Mt Juliet, TN; New York, NY; Purchase, NY; Topeka, KS

Need LinkedIn profile with submittal!

PV will take Technical Screening, please submit only strong comm. Skills!

Senior Data Analyst with Guidewire and P&C Insurance

6+ months

Hybrid – 3 days 2 remote

No CPT/H1B

Recent 6 years in P and C insurance is a MUST and using Guidewire

The candidate must have Datawarehouse, ETL OTLP and SQL experience with Guidewire Knowledge Must Have P&C insurance experience

Required:

• Need 9-10 years of total experience.
• Proven 5+ years’ experience of data analysis – extraction of OLTP data within an enterprise data warehouse.
• Possess 5+ years of Policy  Claims Insurance subject-matter expertise.  
• Candidate has advanced level SQL knowledge.
• Possess optimal knowledge for concepts and frameworks for Data Warehousing, ETL, and BI Architectures.
• Candidate is capable of creating and tuning Semantic layer Reporting Views.
• Able to facilitate data discovery sessions, which will include an audience of business subject-matter experts.
• Proven knowledge of RDBMS platforms (e.g., SQL Server, DB2), with experience in generating DDL.
• Possess knowledge of Guidewire Policy Center, Guidewire Claims Center, SAP FS-RI  SAP FS-CD applications with their data is considered a plus.

ROLE 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 correct ETL code.

• Ensure the ETL code align with STM requirements.

• Perform data validation, to insure correct data movement into the enterprise data warehouse architecture.

• Consult with reporting teams to develop a general understanding for the data warehouse model / optimal ways to use it.

ROLE SUMMARY

The Data Analyst is a hands-on position with a focus 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.