Required Skills

Data Analyst

Work Authorization

  • US Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

  • W2-Permanent

  • W2-Contract

  • Contract to Hire

  • Need H1B

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 26th Feb 2024

JOB DETAIL

ROLE SUMMARY

The Data Analyst is a hands-on position focused on defining the data needs, gathering requirements and designing  reports pertaining to Commercial Insurance. The position will work within IT to help Sompo International create Insurance related reporting - operations, compliance financial actuarial etc

ROLE RESPONSIBILITIES

Works with business stakeholders and IT teams to define data needs for the reporting requirements

Creates source to target 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 reports are represented correctly

Experience of creating Insurance related reporting - operations, compliance financial actuarial etc

Knowledge of Guidewire Policy Center, Guidewire Claims Center, SAP FS-RI & SAP FS-CD applications and their data is a huge plus

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

TECHNICAL QUALIFICATIONS

5+ years of data warehouse experience

3 years P&C Insurance subject matter experience (Policy and Claims)

Strong knowledge of PowerBI/Cognos

Advanced SQL knowledge for Data Analytics

Cloud exposure will be a plus

Good knowledge of Data Warehousing and BI Architectures, concepts and frameworks

Proven experience in Data Modeling, Data mapping, Reports designing

Capable of creating and tuning Semantic layer Reporting Views

Capable of facilitating data discovery sessions involving business subject matter experts

EDUCATION REQUIREMENTS

BS in Computer Science, Information Management or Statistics

 

Company Information