Data Engineer - DWH & Data Quality in Insurance

Carolina Casualty (a Berkley Company)

Jacksonville (FL)

On-site

USD 90,000 - 120,000

Full time

6 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Carolina Casualty, part of W. R. Berkley Corporation, seeks a Data Engineer in Jacksonville, FL to transform a fragmented data estate into a trusted enterprise foundation.

You will design ODS and DWH models, enforce data definitions and quality controls, and ensure governance and SOX requirements are embedded in SQL Server and Databricks environments. You will build governance, data lineage and quality metrics, migrate pipelines to Databricks, and collaborate across teams to deliver scalable

Qualifications

  • Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Data Engineering, or a related field.
  • Advanced SQL and Microsoft SQL Server experience.
  • Strong relational and dimensional data modeling capabilities.
  • Experience with ETL/ELT, ODS and enterprise data warehouse solutions.
  • Experience defining data quality rules, reconciliations and source-to-target mappings.
  • Ability to translate business concepts into scalable technical data models.
  • Strong collaboration, documentation and problem-solving skills.

Responsibilities

  • Analyze existing databases, marts and reporting structures to identify duplication and inconsistent models.
  • Develop conceptual, logical and physical models for ODS and DWH solutions, including dimensional models.
  • Define source-to-target mappings, business keys, historical data handling and transformation rules.
  • Help establish data ownership, stewardship, metadata, lineage and critical data element standards.
  • Define and automate data quality metrics for completeness, accuracy, validity, consistency, timeliness and reconciliation.
  • Build and maintain SQL-based pipelines supporting governed ODS and DWH models.
  • Support migration of models and pipelines to Databricks using SQL and, where appropriate, Python or PySpark.
  • Document control points and evidence supporting traceable, SOX-compliant data processes.
  • Perform other duties and/or projects as assigned

Skills

Advanced SQL
SQL Server
Data modeling
ETL/ELT
ODS/DW
Data quality
Business concepts
Collaboration

Education

Bachelor’s degree in Computer Science

Tools

Databricks
Python
PySpark
Spark
Guidewire

Job description

Carolina Casualty, part of W. R. Berkley Corporation, seeks a Data Engineer in Jacksonville, FL to transform a fragmented data estate into a trusted enterprise foundation.

You will design ODS and DWH models, enforce data definitions and quality controls, and ensure governance and SOX requirements are embedded in SQL Server and Databricks environments. You will build governance, data lineage and quality metrics, migrate pipelines to Databricks, and collaborate across teams to deliver scalable

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer - Governed DWH, Databricks & SOX
Data Engineer - Governed DWH, Databricks & SOX

BERKLEY TECHNOLOGY SERVICES • Jacksonville (FL)

On-site
USD 110,000 - 150,000
Data Engineer: ETL & Databricks Modernization
Data Engineer: ETL & Databricks Modernization

Carolina Casualty (a Berkley Company) • Jacksonville (FL)

On-site
USD 110,000 - 130,000
Data Engineer
Data Engineer

Carolina Casualty (a Berkley Company) • Jacksonville (FL)

On-site
USD 90,000 - 120,000
Data Engineer
Data Engineer

BERKLEY TECHNOLOGY SERVICES • Jacksonville (FL)

On-site
USD 110,000 - 150,000
Data Engineer - ETL
Data Engineer - ETL

Carolina Casualty (a Berkley Company) • Jacksonville (FL)

On-site
USD 110,000 - 130,000
Data Engineer - Hybrid: Insurance Data Pipelines
Data Engineer - Hybrid: Insurance Data Pipelines

CURE Auto Insurance • Princeton (NJ)

Hybrid
USD 70,000 - 120,000
Health and dental coverage
Life and disability insurance
401(k) with company match
+3
Finance Director, FP&A & Data Analytics (Insurance)
Finance Director, FP&A & Data Analytics (Insurance)

Carolina Casualty (a Berkley Company) • Jacksonville (FL)

On-site
USD 110,000 - 170,000
Health, Dental, Vision
Life, Disability
Wellness
+2
Data Insights Analyst – BI & Data Quality
Data Insights Analyst – BI & Data Quality

Insurancecenterinc • Woodbridge Township (NJ)

On-site
USD 80,000 - 90,000
Competitive benefits
Finance Director, FP&A & Data Analytics (Insurance)
Finance Director, FP&A & Data Analytics (Insurance)

Berkley Technology Services LLC • Jacksonville (FL)

On-site
USD 110,000 - 170,000
Health
Dental
Vision
+5
Data Engineering Lead: Snowflake, ADF & Databricks
Data Engineering Lead: Snowflake, ADF & Databricks

TechDigital Group • Dallas (TX)

On-site
USD 90,000 - 150,000