Data Warehouse Production Support Analyst (R1282)

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 RESPONSIBILITIESWork with business stakeholders to gather information required for root cause analysis of reported issuesCoordinate with all necessary IT teams to analyze and resolve data issues for the enterprise data warehouseCreate source to target mapping documents to capture additional application data elements for loading from source systems into the enterprise data warehouseCollaborate 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 requirementsPerform data validation to confirm data is moved into the data warehouse correctlyWork with reporting teams to assist them in understanding any reported variances between the data warehouse and source system applicationTECHNICAL QUALIFICATIONS4+ years of data analysis experience for a data warehouse2 years P&C Insurance subject matter experience (Policy and Claims)Advanced SQL knowledgeExtensive knowledge of Data Warehousing, ETL and BI Architectures, concepts, and frameworksCapable of creating and tuning Semantic layer Reporting ViewsCapable of facilitating data discovery sessions involving business subject matter expertsKnowledge of RDBMS platforms (e.g. SQL Server, DB2) with experience in generating DDLGENERAL QUALIFICATIONSKnowledge of Guidewire Policy Center, Guidewire Claims Center, SAP FS-RI & SAP FS-CD applications and their data is a plusStrong interpersonal skills and ability to work as part of a teamEDUCATION REQUIREMENTSBS in Computer Science, Information Management or Statistics or equivalentSALARY RANGE : $75,000 - $100,000 Actual compensation for this role will depend on several factors including the cost of living associated with your work location, your qualifications, skills, competencies, and relevant experience.Sompo International is an equal opportunity employer committed to a diverse workforce. M/F/D/VVisit our website at www.sompo-intl.com

#J-18808-Ljbffr