Data Transformation Specialist

Overview

Remote
Up to $56
Contract - W2

Skills

Property And Casualty Insurance
BIND
Collaboration
Analytics
API
ACORD
Data Modeling
Insurance
Unqork
Snowflake
Reporting
Semantics
Data Governance
Data Lake
Data Structure
ELT
JSON
Communication
Meta-data Management
Quoting
Continuous Integration
Snow Flake Schema

Job Details

Data Transformation Specialist Pre-Bind (Unqork & Snowflake)

Role Overview:
We are seeking a skilled Data Transformation Specialist with 8 10 years of experience working with pre-bind data from Unqork underwriting platforms, and expertise in data modeling, transformation, and integration within a Snowflake-based data lake and analytics platform. The ideal candidate will support the design and implementation of a common data model to enable scalable ingestion, harmonization, and consumption of pre-bind underwriting data across Property & Casualty (P&C) Insurance business units.

Key Responsibilities

  • Analyze and interpret pre-bind submission and quote data structures from Unqork

  • Design and implement logical and physical data models in Snowflake aligned with enterprise standards

  • Develop and optimize ETL/ELT pipelines to load, transform, and structure data for downstream consumption

  • Collaborate with business and underwriting teams to ensure semantic alignment of pre-bind data across lines of business (e.g., Property, Casualty, Programs)

  • Create data validation, cleansing, and enrichment logic to address gaps and ensure readiness for analytics and reporting

  • Support integration of pre-bind data with reporting tools such as Power BI

  • Document data dictionaries, mappings, lineage, and transformation rules

Required Skills & Qualifications

  • 8 10 years of relevant experience in data transformation and modeling

  • Strong understanding of pre-bind underwriting workflows (submissions, quotes, risk attributes)

  • Experience with Unqork data structures and integration patterns (API-based or extract frameworks)

  • Proficiency in Snowflake data modeling and SQL performance tuning

  • Hands-on experience with data pipeline tools and ELT frameworks

  • Solid knowledge of P&C Insurance lines of business and domain-specific nuances (Total Insured Value (TIV), deductibles, coverage types)

  • Familiarity with ACORD standards or similar industry data formats is a plus

  • Ability to interpret and work with semi-structured JSON data from Unqork or APIs

  • Strong collaboration and communication skills with technical and business stakeholders

Preferred Experience

  • Prior experience on data platform transformation or modernization projects

  • Experience with CI/CD practices for data pipelines

  • Working knowledge of data governance tools (e.g., Collibra, Alation) or metadata management

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.

About Biztec Global LLC