Job Description

Position: Enterprise Data Specialist

Location: Alpharetta, GA; Charlotte, NC; Chicago, IL; Colorado Springs, CO; Conshohocken, PA; Dallas, TX; Denver, CO; Fargo, ND; Garden City, NY; Houston, TX; Jacksonville, IL; Lenexa, KS; Los Angeles, CA; Lubbock, TX; Morristown, NJ; Mt Juliet, TN; New York, NY; Purchase, NY; Topeka, KS***Day 1 Onsite***

Job Description:

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.

Job Tags

Similar Jobs

GD Mission Systems

Software Engineer Job at GD Mission Systems

...on requirements Posted Date: 4/16/2025 Category: Engineering-Software Employment Type: College Hiring Company: General Dynamics Mission Systems, Inc. Basic Qualifications Requires a Bachelors degree in Software Engineering, or a related Science,...

Vitaly Health

Locum Tenens - Family Medicine Physician Job at Vitaly Health

...Job Title: Locum Tenens - Family Medicine Physician Location: Wisconsin State Position Overview: Our team at Vitaly Health is looking for a Family Medicine Physician to join our Medical Center on an ongoing Locum Tenens basis, with a start date of June 2025....

CA Exposition and State Fair

Media/Marketing Associate Job at CA Exposition and State Fair

...not be offered for this position. The California State Fair Media/Marketing Associate will assist in the development and execution of... ...digital advertising, community promotions, media relations, print, social media, video production & graphic design. The focus will be...

Teksky

Injection Molding Process Technician Job at Teksky

...Responsibilities of an Injection Molding Process Technician Processes troubleshooting of various types of thermoplastic injection... ...Knowledge and application of injection molding principles with strong mechanical aptitude. ~3-5 Years of Plastics experience....

Rapid Response Monitoring

Armed Corporate Security Guard Job at Rapid Response Monitoring

...in-office and reports to our facility on site in Syracuse, NY.About the RoleRapid Response Monitoring is looking for Armed Corporate Security Officers to maintain a safe and secure environment for customers and employees by patrolling and monitoring premises and personnel...

Enterprise Data Specialist Job at Inherent Technologies, Georgia

MjgzUGxsQW1Dd1U0aEhNQ0orSnRUV3R6