Description

ROLE RESPONSIBILITIES

  • Work with business stakeholders and IT teams to analyze and resolve data issues for the enterprise data warehouse.
  • Create source-to-target mapping documents to capture additional application data elements.
  • Load the source-to-target mapping documents from source systems into the enterprise data warehouse.
  • Collaborate with the ETL team to ensure the source-to-target mapping documents are in correct ETL code.
  • Ensure the ETL code align with STM requirements.
  • Perform data validation, to insure correct data movement into the enterprise data warehouse architecture.
  • Consult with reporting teams to develop a general understanding of any identified variances – between the enterprise data warehouse and source system applications.

TECHNICAL QUALIFICATIONS

  • Proven 3+ years’ experience in data analysis within an enterprise data warehouse.
  • Possess2 years of Policy & Claims Insurance subject-matter expertise.
  • Candidate has advanced level SQL knowledge.
  • Possess optimal knowledge for concepts and frameworks for Data Warehousing, ETL, and BI Architectures.
  • Candidate is capable of creating and tuning Semantic layer Reporting Views.
  • Able to facilitate data discovery sessions, which will include an audience of business subject-matter experts.
  • Proven knowledge of RDBMS platforms (e.g., SQL Server, DB2), with experience in generating DDL.
  • Possess knowledge of Guidewire Policy Center, Guidewire Claims Center, SAP FS-RI & SAP FS-CD applications with their data is considered a plus.

EDUCATION REQUIREMENTS

  • B.S. Degree in Computer Information Science, Information Management, or Statistics.

Education

Any Graduate