Data Engineer
Big Data
Bigdata
Cloud Data Engineering
Cloud Data Platform
Cloud Platform
Cloud Platforms
Data
Data Analysis
Data Analytics
Data Architecture
Data Engineer
Data Engineering
Data Integration
Data Integration Tools
Data Lakehouse
Data Pipeline
Data Platform
Data Processing
Data Warehouse
Database
Databases
Databricks
ETL
Informatica
Information Technology (IT)
Microsoft SQL Server
Pyspark
Reporting and Analytics
Software Development
Spark
SQL
SQL Server
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.