Address
Form of work 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 Clienthitecture.
Consult with reporting teams to develop a general understanding for any identified variances - between the enterprise data warehouse and source system applications.
Mandatory skills
Proven 3+ years' experience of data analysis within an enterprise data warehouse.
Possess 2 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 Clienthitectures.
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.
Preferred/Desired skills
Possess knowledge of Guidewire Policy Center, Guidewire Claims Center, SAP FS-RI & SAP FS-CD applications with their data is considered a plus.
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 Clienthitecture.
Consult with reporting teams to develop a general understanding for any identified variances - between the enterprise data warehouse and source system applications.
Mandatory skills
Proven 3+ years' experience of data analysis within an enterprise data warehouse.
Possess 2 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 Clienthitectures.
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.
Preferred/Desired skills
Possess knowledge of Guidewire Policy Center, Guidewire Claims Center, SAP FS-RI & SAP FS-CD applications with their data is considered a plus.
