Senior Data Analyst (Hybrid) job vacancy

Vacancy expired!

The

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

TECHNICAL QUALIFICATIONS

5+ years of data analysis experience for a data warehouse
5 years P&C Insurance subject matter experience (Policy and Claims)
Advanced SQL knowledge
Extensive knowledge of Data Warehousing, 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

EDUCATION REQUIREMENTS

BS in Computer Science, Information Management or Statistics

At Sompo International, we recognize that the talent, skills, and commitment of our employees drive our success. This is why we offer competitive, high-quality compensation and benefit programs to eligible employees.Our compensation program is built on a foundation that promotes a pay-for-performance culture, resulting in higher incentive awards, on average, when the Company does well and lower incentive awards when the Company underperforms. The total compensation opportunity for all regular, full-time employees is a combination of base salary and incentives that gets adjusted upfront based on overall Company performance with final awards based on individual performance.We continuously evaluate and update our benefit programs to ensure that our plans remain competitive and meet the needs of our employees and their dependents. Below is a summary of our current comprehensive U.S. benefit programs:

Two medical plans to choose from, including a Traditional PPO & a Consumer Driven Health Plan with a Health Savings account providing a competitive employer contribution.
Pharmacy benefits with mail order options.
Dental benefits including orthodontia benefits for adults and children.
Vision benefits.
Health Care & Dependent Care Flexible Spending Accounts.
Company-paid Life & AD&D benefits, including the option to purchase Supplemental life coverage for employee, spouse & children.
Company-paid Disability benefits with very competitive salary continuation payments.
401(k) Retirement Savings Plan with competitive employer contributions.
Competitive paid-time-off programs, including company-paid holidays.
Competitive Parental Leave Benefits & Adoption Assistance program
Employee Assistance Program
Tax-Free Commuter Benefit
Tuition Reimbursement & Professional Qualification benefits.

ID: #49253703
State: New Jersey Florhampark 07932 Florhampark USA
City: Florhampark
Salary: $105,000 - $135,000
Job type: Permanent
Showed: 2023-02-17
Deadline: 2023-03-31
Category: Et cetera