EngineerJobs.io
← Back to all jobs

Job Description

The Data Engineer role at Berkley focuses on turning a fragmented data environment into a trusted enterprise foundation. You will design governed data models, define quality and reconciliation standards, and support migration efforts across SQL Server and Databricks.

Onsite Location

Jacksonville, FL (onsite)

Education

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

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.
  • Assist with establishing 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 provide evidence supporting traceable, SOX-compliant data processes.
  • Perform other duties and/or projects as assigned.

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

Technologies

  • SQL
  • Microsoft SQL Server
  • Databricks
  • Python
  • PySpark
  • Spark

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

Benefits

Sponsorship: Not Offered for this Role

Agency and Salary Information

  • Only solicited resumes/candidate profiles 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 agency fees.
  • The actual salary for this position will be determined by factors including scope, complexity, and location; candidate skills, education, training, credentials, and experience; and other conditions of employment.

Similar Jobs