Data Analyst - Production Support

Data Analyst - Production Support Hybrid Schedule/Partial Remote: Candidate must be willing to work in the office three days per week (Tuesday, Wednesday, Thursday in one of the following locations: Alpharetta, GA; Boston, MA; Charlotte, ; Chicago, IL; Colorado Springs, CO; Conshohocken, PA; Dallas, TX; Florham Park, NJ; Jacksonville, IL; Lenexa, KS; Lubbock, TX; Mt Juliet, TN; New Hyde Park, NY; New York, NY; Purchase, NY; Topeka, KS 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. ROLE RESPONSIBILITIES

• 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

• 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
• 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

• 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

• BS in Computer Science, Information Management or Statistics