Enterprise Data Specialist

  • Morristown, NJ
  • Posted 11 hours ago | Updated moments ago

Overview

On Site
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 12

Skills

Data Modelling
Business Intelligence
dashboards
Data Integration
Data Warehousing
Performance Tuning
Data Analysis
Reinsurance
Data Architecture
Microsoft SQL Server
data discovery
data ingestion
SQL Databases
Guidewire PolicyCenter
Knowledge of Finance
Extract Transform Load (ETL)
Data Systems
Modelling Skills
Insurance Claim Processing
Physical Data Models

Job Details

Job Title: Enterprise Data Specialist
Work Mode: Onsite only Locations (Onsite):

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

Position Overview

The Enterprise Data Specialist plays a critical role in designing, modeling, and mapping enterprise-scale data solutions for Clients's data warehouse. This role partners closely with business and IT teams to deliver high-quality data architecture, integration, and reporting solutions across insurance systems.

Insurance domain experience is mandatory.

Key Responsibilities

  • Design and architect enterprise data warehouse solutions sourcing from multiple insurance systems (Policy, Claims, Treaty, Financials).

  • Collaborate with business stakeholders and IT teams to define data architecture and modeling requirements.

  • Create logical and physical data models and implement them on SQL Server platforms.

  • Develop Source-to-Target mappings optimized for high-volume data integration.

  • Work closely with development teams to translate mappings into Informatica and SQL code.

  • Facilitate data discovery sessions with business SMEs.

  • Develop strategies for data ingestion and validation using SQL-based solutions.

  • Design enterprise data models to support reporting and analytics.

  • Create SQL Server views for dashboards and reporting.

  • Participate in release planning and post-deployment validation.

  • Troubleshoot and optimize SQL, Informatica mappings, and stored procedures.

  • Create and tune semantic layer reporting views.

Required Qualifications

  • 12+ years of experience in data architecture, data modeling, and data warehouse design.

  • 3+ years of experience in the Insurance/Reinsurance domain (mandatory).

  • Strong experience extracting data from Insurance applications.

  • Extensive knowledge of Data Warehousing, ETL, and BI architectures.

  • Hands-on experience with Informatica.

  • Strong expertise in SQL Server (DDL, views, performance tuning).

  • Experience working with Guidewire PolicyCenter and/or ClaimsCenter.

  • Strong ability to generate and validate enterprise data models.

Preferred Qualifications

  • Informatica Certification

  • Experience with DB2 or other RDBMS platforms.

eye

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.