Possess knowledge of Guidewire Policy Center, Guidewire Claims Center, SAP FS-CD & SAP FI-GL applications.
10+ years of data architecture and design experience working with development team to extract data directly from source applications and loading to an enterprise data warehouse.
3+ years of experience within the Insurance and reinsurance domain.
Advanced experience with extracting data from Insurance applications.
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 (SQL Server, DB2, etc.) with experience in generating DDL.
Architect and design comprehensive solutions for the enterprise data warehouse. Sourcing 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.
Create logical and physical data models and implement them on SQL Server platforms.
Work closely with the development team to ensure accurate translation of mappings into code.
Develop strategies for data collection and ingestion and write SQL based solutions to validate data accuracy and integrity in the data warehouse.
Analyze and design enterprise data models for optimal reporting. Support reporting teams in understanding and utilizing the data warehouse model effectively.
Participate in release planning and validate changes post-deployment.
Develop SQL Server views for reporting and dashboard development. Troubleshoot and optimize SQL and Informatica mappings and stored procedures.
Numbers & Facts
Location
Alpharetta, GA
Industry
Other/Not Classified
Company Size
100 to 499 employees
Skills
Analysis Skillsunmatched
Business Intelligenceunmatched
Data Collectionunmatched
Data Description Language (DDL)unmatched
Data Modelingunmatched
Data Qualityunmatched
Data Warehousingunmatched
Database Extract Transform and Load (ETL)unmatched
Design Servicesunmatched
Financial Systemsunmatched
General Ledger Softwareunmatched
Guidewireunmatched
IBM DB2unmatched
Identify Issuesunmatched
Informaticaunmatched
Insuranceunmatched
Microsoft SQL Serverunmatched
Reinsuranceunmatched
Relational Databases (RDBMS)unmatched
Reporting Dashboardsunmatched
SAPunmatched
SQL (Structured Query Language)unmatched
Server Programming/Applicationsunmatched
Stored Proceduresunmatched
Strategic Planningunmatched
Team Playerunmatched
🎯
Be found by employers
5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.