Job Details

ID #44398454
State New York
City New york city
Job type Permanent
Salary USD $125,000 - $145,000 125000 - 145000
Source Perennial Resources International
Showed 2022-07-27
Date 2022-07-25
Deadline 2022-09-23
Category Et cetera
Create resume

Senior Data Analyst-Hybrid Onsite

New York, New york city, 10017 New york city USA

Vacancy expired!

Sr Data Analyst – Location: PA – Conshohocken, New York, NY – Purchase, NY – Florham Park, NJ – Charlotte, NC – writing SAP, Guidewire mapping data from these to the data warehouse, insurance background, ideally commercial

. Good SQL skills, complicated data, SAP or Guidewire experience with RI and CD, GL (not required but preferred). Working on a Data warehouse environment, we have a traditional data environment. Most of the team is in NJ or Purchase, NY. Open to other offices. Corporate office is 3 times a week minimum in the office.

ROLE SUMMARY 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 the firm 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, 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

EDUCATION REQUIREMENTS
  • BS in Computer Science, Information Management or Statistics

Vacancy expired!

Subscribe Report job