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
Engineer
ETL
Informatica
Information Technology (IT)
Microsoft SQL Server
Pyspark
Reporting and Analytics
Software Development
Spark
SQL
SQL Server
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