ROLE TITLE
Data Analyst (Data Warehouse)
ROLE LOCATION(S)
Purchase, NY; Florham Park, NJ,
ROLE SUMMARY
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 the performance of all aspects of the company's operations.
ROLE RESPONSIBILITIES
- Works with business stakeholders and IT application teams to define data needs for the enterprise data warehouse
- Creates source (OLTP applications) 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 of data analysis experience extracting OLTP data specifically for a data warehouse
- 5 + years of P&C Insurance subject matter experience (Policy and Claims)
- 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, 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
COMPETENCY PROFICIENCY (SCALE 1-5)
Skill
Proficiency Level
Skill
Proficiency Level
Data Analysis
5
Data Modeling
3
Data Warehousing
4
P&C Experience
3
Communication
4
EDUCATION REQUIREMENTS
- BS in Computer Science, Information Management or Statistics