| Data Analyst - NY, NJ, Alpharetta GA (Hybrid Remote) at Alpharetta, Georgia, USA |
| Email: [email protected] |
| From: Pooja, ICS Globalsoft [email protected] Reply to: [email protected] Role: Data Analyst Location: NY, NJ, Alpharetta GA (Hybrid Remote) Duration: Long-Term Contract Need 10+ Exp Insurance Background (must) Skills: Guidewire Policy (GW),OLTP applications, SQL Server, DB2 Job Description: 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 companys operations. ROLE RESPONSIBILITIES: Works with business stakeholders and IT application teams to define data needs for the enterprise data warehouse Creates source (GW PC) to target (DWH) 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 TECHNICAL QUALIFICATIONS: 5 + years P&C Insurance subject matter experience (GW Policy) 10 + years of data analysis experience extracting OLTP data specifically for a data warehouse Advanced SQL knowledge working with extracting data from OLTP applications 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 GENERAL QUALIFICATIONS: Knowledge of Guidewire Policy Center, Guidewire Claims Center applications and their data is a huge plus Strong interpersonal skills and ability to work as part of a team Keywords: cprogramm business intelligence information technology Georgia New Jersey New York |
| [email protected] View all |
| Tue Sep 12 19:05:00 UTC 2023 |