Data Engineer

BERKLEY TECHNOLOGY SERVICES

Jacksonville (FL)

On-site

USD 110,000 - 150,000

Full time

8 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

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

The role focuses on designing ODS and DWH models, governing data definitions, and ensuring SOX compliance across SQL Server and Databricks environments. You will build and optimize SQL pipelines, define data quality metrics, and collaborate with teams to deliver scalable, governance-driven data solutions in a regulated

Qualifications

  • 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
Data quality
Documentation
Collaboration
Problem-solving

Education

Bachelor's degree in Computer Science / Information Systems / Data Analytics

Tools

Databricks
Python
PySpark
Spark

Job description

Company Details

Carolina Casualty is a member company of W. R. Berkley Corporation, an insurance holding company that is among the largest commercial lines insurance writers in the United States. We specialize in liability, physical damage, cargo and other insurance solutions for the commercial auto markets including trucking, public transportation and others.

Join Carolina Casualty, where innovation meets purpose.

Carolina Casualty is a proud member of W. R. Berkley Corporation, one of the largest commercial lines insurers in the country. What sets us apart is not just our size, but how we work and who we are.

We specialize in liability, physical damage, cargo, and other insurance solutions for the commercial auto market, including trucking and public transportation industries that keep America moving. Our team tackles real, complex challenges for the people and businesses that make that possible every day.

Values

At CCIC, we live by three simple truths:

  • Always do right. Integrity is not just a slogan. It guides every decision we make.
  • Everything counts; everyone matters. Every role, every voice, and every contribution help shape who we are as an organization.
  • Embrace innovation and act responsibly. We are willing to challenge the status quo while remaining thoughtful and committed to our people, customers, and partners.
About the Company

If you are looking for a place where your work makes an impact, your ideas are valued, and doing the right thing is expected, we would love to meet you.

The company is an equal opportunity employer.

Responsibilities

We are seeking a Data Engineer with strong data modeling, governance and data quality capabilities to transform a fragmented data estate into a trusted enterprise foundation. This role will design ODS and DWH models, establish consistent data definitions and quality controls, and ensure that governance and SOX requirements are incorporated into both the current SQL Server environment and the future Databricks platform.

Candidate must sit in the Jacksonville, FL office.

Key Functions/Duties of Position:

  • 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
Qualifications
Education Requirement

Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Data Engineering, or a related field

Qualifications: Include necessary skills/experience and core competencies required
  • 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.
Preferred Qualifications
  • Databricks, Python, PySpark or Spark experience.
  • Experience implementing data governance, metadata, lineage or data catalog practices.
  • Experience with automated data quality frameworks.Experience in a SOX-controlled or regulated environment.
  • Property and casualty insurance industry knowledge, including policy, billing, claims or underwriting data, is a strong plus.
  • Experience working with Guidewire applications or data, including Guidewire ClaimCenter (GWCC), Guidewire BillingCenter (GWBilling) or related policy systems.
  • Experience designing governed, feature-ready data for predictive modeling or machine learning.
  • Understanding of quality, lineage, privacy and control considerations for analytical models and AI solutions.
  • Familiarity with generative AI, LLMs, RAG, vector data or unstructured data governance.
Additional Company Details

Only solicited resumes/candidate profiles that are submitted by a Berkley Preferred Agency Partner that have been requested by Berkley Internal Recruiting to engage in a particular search will be subject to the payment of Agency fees as defined in the formal agency agreement. Any unsolicited resumes/candidate profiles are not subject to payment of the agency fees. The actual salary for this position will be determined by a number of factors, including the scope, complexity and location of the role; the skills, education, training, credentials and experience of the candidate; and other conditions of employment.

Sponsorship Details

Sponsorship not Offered for this Role

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer
Data Engineer

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

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

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

On-site
USD 110,000 - 130,000
BI Developer
BI Developer

BERKLEY TECHNOLOGY SERVICES • Jacksonville (FL)

On-site
USD 85,000 - 120,000
Director, Actuarial
Director, Actuarial

W. R. Berkley • Jacksonville (FL)

On-site
USD 150,000 - 204,000
Health, Dental, Vision
Life Insurance
401(k) and Profit-Sh sharing
+1
Data Solution Architect
Data Solution Architect

FCCI • Sarasota (FL)

Hybrid
USD 134,000 - 207,000
Data Solution Engineer
Data Solution Engineer

FCCI Services Inc. • Sarasota (FL)

Hybrid
USD 92,000 - 142,000
Paid Family Leave
Competitive PTO & Holidays
Recognition & Bonus Programs
+2
Data Engineer - DWH & Data Quality in Insurance
Data Engineer - DWH & Data Quality in Insurance

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

On-site
USD 90,000 - 120,000
Data Solution Architect
Data Solution Architect

FCCI Insurance Group • Sarasota (FL)

Hybrid
USD 134,000 - 207,000
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