Data Analyst with Policy Claim Insurance exp

Role: Data Analyst with Policy Claim Insurance exp

No. of Positions: 1

Hiring Mode: Contract (TP)

Location: On-site

Boston, MA; Charlotte, NC; Colorado Springs, CO; Conshohocken, PA; Dallas, TX; Fargo, ND; Florham Park, NJ; Garden City, NY; Houston, TX; Jacksonville, IL; Lenexa, KS; Los Angeles, CA; Lubbock, TX; Mt Juliet, TN; New York, NY; Purchase, NY; Topeka, KS

Job Description:

• Proven 5+ years' experience of data analysis - extraction of OLTP data within an enterprise data warehouse.

• Possess 5+ years of PolicyClaims Insurance subject-matter expertise.

• Candidate has advanced level SQL knowledge.

• Possess optimal knowledge for concepts and frameworks for Data Warehousing, ETL, and BI Clienthitectures.

• Candidate is capable of creating and tuning Semantic layer Reporting Views.

• ble 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-RISAP FS-CD applications with their data is considered a plus.

• Work with business stakeholders and IT teams to analyze and resolve data issues for the enterprise data warehouse.

• Create source (OLTP applications) to target (DWH) 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.

• Perform data validation, to insure correct data movement into the enterprise data warehouse Clienthitecture.