• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 15th Apr 2022

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 teams to define data needs for the enterprise data warehouse
• 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 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
• 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
• 5 years P&C Insurance subject matter experience (Policy and Claims)
• Advanced SQL knowledge
• 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
COMPETENCY PROFICIENCY (SCALE 1-5)