Data Engineer
W. R. Berkley Corporation4 days ago
Jacksonville, FL, USASenior
Responsibilities
- Analyze existing databases, data marts, and reporting structures to identify duplication and inconsistent models.
- Develop conceptual, logical, physical, dimensional, ODS, and data warehouse models.
- Define source-to-target mappings, business keys, historical data handling, and transformation rules.
- Establish 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 data warehouse models.
- Support migration of models and pipelines to Databricks using SQL, Python, or PySpark.
- Document control points and evidence for traceable, SOX-compliant data processes.
- Perform other assigned duties and projects.
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 experience with Databricks, Python, PySpark, or Spark.
- Preferred experience implementing data governance, metadata, lineage, data catalog practices, or automated data quality frameworks.
- Preferred experience in a SOX-controlled or regulated environment and knowledge of property and casualty insurance data.
- Preferred experience with Guidewire applications or data, including ClaimCenter or BillingCenter.
- Preferred experience designing governed, feature-ready data for predictive modeling or machine learning.
- Familiarity with quality, lineage, privacy, and control considerations for analytical models and AI solutions, including generative AI, LLMs, RAG, vector data, or unstructured data governance.
Tech Stack
Categories
Data Engineering
About W. R. Berkley Corporation
W. R. Berkley Corporation is a public insurance holding company that sells commercial property‑casualty coverage and insurance‑related services to businesses. Its operating units focus on primary insurance, reinsurance, and monoline excess products tailored to industry niches and regional markets. Founded in 1967 and headquartered in Greenwich, Connecticut, the company trades on the NYSE (WRB) and operates worldwide; subsidiaries include Berkley Technology Services, which supports core systems for its insurance businesses.