Description

You will architect and manage solutions for the enterprise data warehouse.

This role is on-site.

Responsibilities

• Collaborate with stakeholders to define and document data architecture and modeling needs.
• Source data from multiple Insurance and Reinsurance Policy, Treaty, Claim, and financial systems.
• Design and implement Source to Target mappings optimized for high-volume data integration.
• Develop strategies for data collection and ingestion, writing SQL solutions to validate data accuracy.
• Troubleshoot and optimize SQL and Informatica mappings and stored procedures.

Required Skills

• 10+ years of data architecture and design experience extracting data to an enterprise data warehouse.
• 3+ years of experience within the Insurance and reinsurance domain.
• Advanced experience extracting data from Insurance applications.
• Extensive knowledge of Data Warehousing, ETL, and BI Architecture concepts.
• Proficiency with SQL Server and DB2, including generating DDL.
• Capability to create and tune Semantic layer Reporting Views.
• Knowledge of Guidewire Policy Center, Guidewire Claims Center, SAP FS-CD & SAP FI-GL applications.

Preferred Skills

• Strong analytical and organizational skills.

Key Skills

Education

Bachelor's degree