Data Engineer - Governed DWH, Databricks & SOX

BERKLEY TECHNOLOGY SERVICES

Jacksonville (FL)

On-site

USD 110,000 - 150,000

Full time

8 days ago

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

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

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

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

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

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

BERKLEY TECHNOLOGY SERVICES • Jacksonville (FL)

On-site
USD 110,000 - 150,000
Senior Data Engineer - Databricks
Senior Data Engineer - Databricks

DATAECONOMY Inc • New Jersey

On-site
USD 140,000 - 180,000
Data Platform Chief Architect & Engineering Lead
Data Platform Chief Architect & Engineering Lead

Healogics LLC • Jacksonville (FL)

Remote
USD 163,000 - 190,000
Senior Data Engineer - Databricks
Senior Data Engineer - Databricks

DATAECONOMY Inc • Raleigh (NC)

On-site
USD 120,000 - 190,000
Hybrid Data Engineer: Databricks Lakehouse & Governance
Hybrid Data Engineer: Databricks Lakehouse & Governance

Church & Dwight Co., Inc. • Ewing Township (NJ)

Hybrid
USD 93,000 - 132,000
Senior Data Engineer - Databricks Lakehouse & AI-Ready Data
Senior Data Engineer - Databricks Lakehouse & AI-Ready Data

Church & Dwight Co., Inc. • Princeton (ME)

Hybrid
USD 93,000 - 132,000
Medical
Dental
Vision
+8