DataJobs.io
← Back to all jobs

Job Description

Transform fragmented enterprise data into a trusted foundation through ODS and DWH modeling, governance, and automated 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
  • Support 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 that support 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

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

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) is a strong plus
  • Experience 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

Technologies

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

Location

  • Jacksonville, FL (onsite)

Additional Information

  • Sponsorship not Offered for this Role
  • Salary determined by factors including role scope, complexity, location, and candidate skills, education, training, credentials, experience, and other conditions of employment

Agency / Recruiting Notes

  • Only solicited resumes/candidate profiles submitted by a Berkley Preferred Agency Partner that are requested by Berkley Internal Recruiting to engage in a particular search are subject to agency fees
  • Unsolicited resumes/candidate profiles are not subject to payment of agency fees

Similar Jobs