The Execu|Search Group Looking for Insurance Data Analyst at Purchase, NY Full Time

A services company in Westchester County is actively seeking a new Insurance Data Analyst for a great Remote opportunity with their growing staff. In this role, the Insurance Data Analyst will be responsible for working within IT to help create an industry-leading data warehouse that measures performance of all aspects of the company’s operations.

Responsibilities:

The Insurance Data Analyst will:

• Work with business stakeholders and IT teams to define data needs for the enterprise data warehouse
• Create source to target mapping documents to capture application data elements for loading from source systems into the enterprise data warehouse
• Collaborate with ETL team to ensure that source to target mappings are correctly translated into ETL code
• Perform data validation to confirm data is moved into the data warehouse correctly
• Work with reporting teams to assist them in understanding the data warehouse model and optimal ways to use it
• Perform other duties, as needed

Qualifications:

• 5+ years of Data Analysis experience for a Data Warehouse
• 5 years P&C Insurance subject matter experience (Policy and Claims)
• Bachelor’s Degree
• 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
• Great interpersonal skills
• Excellent communication skills (written and verbal)
• Strong attention to detail
• Highly organized

Desired Skills:

• Knowledge of Guidewire Policy Center, Guidewire Claims Center, SAP FS-RI & SAP FS-CD applications and their data