DeveloperJobs.io
← Back to all jobs

Job Description

This role focuses on transforming a fragmented data landscape into a trusted enterprise data foundation through modeling, governance, and data quality.

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 for traceable, SOX-compliant data processes
  • Perform other duties and/or projects as assigned

Requirements

  • 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
  • PySpark or 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 (policy, billing, claims, or underwriting data) is a strong plus
  • Experience working with Guidewire applications or data, including Guidewire ClaimCenter (GWCC) and 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

Location

  • Jacksonville, FL (onsite)

Benefits

  • Sponsorship not Offered for this Role

Additional Company Details

  • 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 the 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
  • Sponsorship details: Sponsorship not Offered for this Role

Similar Jobs