Data Engineer - ETL

Carolina Casualty (a Berkley Company)

Jacksonville (FL)

On-site

USD 110,000 - 130,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, a Berkley Company, is seeking a Data Engineer to modernize our on-premises SQL Server environment and guide the move to a Databricks platform. You will redesign legacy ETL processes, build robust ODS and DWH pipelines, and embed data quality and governance into the engineering lifecycle.

Based in Jacksonville, FL, you will implement logs, monitoring, and automated deployment while collaborating with enterprise teams to meet security and architectural standards.

Qualifications

  • Strong SQL and Microsoft SQL Server development experience.
  • Hands-on experience designing, building and supporting ETL/ELT pipelines.
  • Knowledge of relational databases, data warehousing and incremental data processing.
  • Experience troubleshooting complex data issues and reconciling source-to-target results.
  • Experience with source control and disciplined software development practices.
  • Strong analytical, documentation and communication skills.

Responsibilities

  • Assess, document and rationalize existing SQL Server ETL pipelines, databases and data silos.
  • Refactor redundant or fragile SQL processes into standardized ETL/ELT pipelines.
  • Design and develop ingestion, transformation and reconciliation pipelines for governed ODS and DWH environments.
  • Implement logging, monitoring, error handling, auditability, lineage and repeatable deployment practices.
  • Develop Databricks notebooks and pipelines using SQL and Python/PySpark as appropriate.
  • Partner with corporate platform teams to align solutions with enterprise architecture and security standards.
  • Support source-to-target mapping, testing, production support and migration validation.
  • Perform other duties and/or projects as assigned.

Skills

SQL
Microsoft SQL Server
ETL/ELT pipelines
Relational databases
Data warehousing
Troubleshooting data issues
Source control practices
Analytical & documentation

Education

Bachelor's degree in CS/IS/Data Analytics

Tools

Databricks
Python
PySpark
Apache 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.


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.


Responsibilities

The company is an equal opportunity employer.


We are seeking a Data Engineer to simplify and modernize our on-premises SQL Server data environment and support the transition to a corporate-managed Databricks platform. This role will redesign legacy ETL processes, build reliable ODS and DWH pipelines, and embed operational controls, data quality and governance into the engineering lifecycle.


Candidate must sit in the Jacksonville, FL office.


Key Functions/Duties Of Position


  • Assess, document and rationalize existing SQL Server ETL pipelines, databases and data silos.

  • Refactor redundant or fragile SQL processes into standardized, maintainable ETL/ELT pipelines.

  • Design and develop ingestion, transformation and reconciliation pipelines for governed ODS and DWH environments.

  • Implement logging, monitoring, error handling, auditability, lineage and repeatable deployment practices.

  • Develop Databricks notebooks and pipelines using SQL and, as appropriate, Python or PySpark.

  • Partner with corporate platform teams to align solutions with enterprise architecture, security and engineering standards.

  • Support source-to-target mapping, testing, production support and migration validation.

  • 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


  • Strong SQL and Microsoft SQL Server development experience.

  • Hands-on experience designing, building and supporting ETL/ELT pipelines.

  • Knowledge of relational databases, data warehousing and incremental data processing.

  • Experience troubleshooting complex data issues and reconciling source-to-target results.

  • Experience with source control and disciplined software development practices.

  • Strong analytical, documentation and communication skills.


Preferred Qualifications


  • Databricks, Python, PySpark or Apache Spark experience.

  • Experience migrating legacy ETL workloads to a cloud data platform.

  • Dimensional modeling and data quality automation experience.

  • 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 engineering feature-ready datasets or pipelines for predictive analytics and machine learning.

  • Familiarity with model lifecycle concepts, including experimentation, deployment, monitoring and reproducibility.

  • Exposure to generative AI, large language models (LLMs), retrieval-augmented generation (RAG), vector search or AI-assisted data engineering.


Additional Company Details

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
Data Engineer

BERKLEY TECHNOLOGY SERVICES • Jacksonville (FL)

On-site
USD 110,000 - 150,000
Data Solution Architect
Data Solution Architect

FCCI Insurance Group • Sarasota (FL)

Hybrid
USD 134,000 - 207,000
BI Developer
BI Developer

BERKLEY TECHNOLOGY SERVICES • Jacksonville (FL)

On-site
USD 85,000 - 120,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 Solution Architect
Data Solution Architect

FCCI • Sarasota (FL)

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

NTT Ltd • Charlotte (NC)

On-site
USD 120,000 - 180,000
Senior Data Engineer - Databricks
Senior Data Engineer - Databricks

DATAECONOMY Inc • New Jersey

On-site
USD 140,000 - 180,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
Senior Data Engineer-Databricks & Data Modeling
Senior Data Engineer-Databricks & Data Modeling

Winsupply • Moraine (OH)

On-site
USD 120,000 - 170,000