• US Citizen

• Green Card

• Corp-Corp

• W2-Permanent

• W2-Contract

• Contract to Hire

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 18th Oct 2023

Job Title/Role

Production Support Data Analyst

Minimum Mandatory Skills

• 3+ years of data analysis experience for a data warehouse
• 2 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

Job Description:
Detailed JD

The Production Support Data Analyst is a hands-on position focused on supporting the data accuracy and completeness of the enterprise data warehouse. The position will work within IT to help Sompo International in the maintenance of the company’s data warehouse that measures performance of all aspects of the company’s operations

• Works with business stakeholders and IT teams to analyze and resolve data issues for the enterprise data warehouse
• When necessary will creates source to target mapping documents to capture additional 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 and that ETL code operates in line with STM requirements
• Performs data validation to confirm data is moved into the data warehouse correctly
• Works with reporting teams to assist them in understanding any reported variances between the data warehouse and source system applications

Experience level:

6+ years of experience in SQL;

3+ years of data analysis experience for a data warehouse;

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