Full-Time Data Analyst

Job Description

The Data Analyst is a hands-on position with a focus on defining the data needs for the enterprise data warehouse. The position will work within IT to help our Insurance Client create an industry-leading data warehouse architecture. Furthermore, this data warehouse architecture will measure performance in all aspects of the organization’s operations.

Responsibilities:

• 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 the correct ETL code.
• Ensure the ETL code aligns with STM requirements.
• Perform data validation, to ensure correct data movement into the enterprise data warehouse architecture.
• Consult with reporting teams to develop a general understanding of the data warehouse model / optimal ways to use it.

Qualifications

• 5+ years’ experience in data analysis – extraction of OLTP data within an enterprise data warehouse.
• 5+ years of Policy & Claims Insurance subject-matter expertise.
• Advanced level SQL knowledge.
• Optimal knowledge of concepts and frameworks for Data Warehousing, ETL, and BI Architectures.
• 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.
• Knowledge of Guidewire Policy Center, Guidewire Claims Center, SAP FS-RI & SAP FS-CD applications with their data is considered a plus.