Sompo International has a new opportunity for a Data Analyst role that we invite you to submit candidates for. Candidates are required to screen and interview via video conference.
The intent is to staff this role as soon as possible so please be sure to only submit candidates that would be available to start shortly after being selected.
Candidates for this role are required to work in one of the indicated offices at the time of onboarding. If candidates are not already local, they must complete their relocation prior to their start date. It is expected that eventually staff will be required to return to offices full-time but, as of now SI is currently on a hybrid working schedule, and staff is required to be in the office every Tuesday, Wednesday, and Thursday.
Required Information:
- The role name indicated in this email
- The candidate's rate
- A summary of the candidates' qualifications for the role
- The candidates resume
- Confirm the candidate can start shortly after selection
- Confirm what SI office the candidate will work from
- Confirm if they are already local to that location or not
- If not local, confirm they can complete their relocation prior to onboarding
- Confirm if [Candidate] agrees with the SI's current hybrid working schedule that requires staff to be in the office every Tuesday - Thursday and remote Monday & Friday
Sompo International has a new IT contractor opportunity for a Data Analyst.
ROLE TITLE
Data Analyst (Data Warehouse)
ROLE LOCATION(S)
Purchase, NY; Florham Park, NJ; Remote will be considered
TEAM
Data and Business Intelligence
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 teams to define data needs for the enterprise data warehouse
- Creates source to target 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
- 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
TECHNICAL QUALIFICATIONS
- 5+ years of data warehouse experience
- 5 years of 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
COMPETENCY PROFICIENCY (SCALE 1-5)
| Skill |
Proficiency Level |
Skill |
Proficiency Level |
| Data Analysis |
4 |
Data Modeling |
3 |
| Data Warehousing |
4 |
P&C Experience |
3 |
| Communication |
4 |
|
|
EDUCATION REQUIREMENTS
- BS in Computer Science, Information Management, or Statistics