Data Engineer - ETL
W. R. Berkley Corporation4 days ago
Jacksonville, FL, USAMid Level
Responsibilities
- Assess, document, and rationalize existing Microsoft SQL Server ETL pipelines, databases, and data silos.
- Refactor legacy SQL processes into standardized ETL/ELT pipelines.
- Design and develop ingestion, transformation, and reconciliation pipelines for operational data store and data warehouse environments.
- Implement logging, monitoring, error handling, auditability, data lineage, and repeatable deployment practices.
- Develop Databricks notebooks and pipelines using SQL, Python, or PySpark.
- Partner with corporate platform teams on enterprise architecture, security, and engineering standards.
- Support source-to-target mapping, testing, production support, and migration validation.
Requirements
- Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Data Engineering, or a related field.
- Strong SQL and Microsoft SQL Server development experience.
- Hands-on experience designing, building, and supporting ETL/ELT pipelines.
- Knowledge of relational databases, data warehousing, and incremental data processing.
- Experience troubleshooting complex data issues and reconciling source-to-target results.
- Experience with source control and disciplined software development practices.
- Strong analytical, documentation, and communication skills.
- Preferred experience with Databricks, Python, PySpark, or Apache Spark.
- Preferred experience migrating legacy ETL workloads to a cloud data platform, dimensional modeling, and data quality automation.
- Experience in a SOX-controlled or regulated environment and property and casualty insurance data is preferred.
- Experience with Guidewire applications, including Guidewire ClaimCenter or Guidewire BillingCenter, is preferred.
- Experience engineering feature-ready datasets or pipelines for predictive analytics and machine learning is preferred.
- Familiarity with model lifecycle concepts and exposure to generative AI, large language models, retrieval-augmented generation, vector search, or AI-assisted data engineering is preferred.
Benefits
- The candidate must work from the Jacksonville, Florida office.
- The company is an equal opportunity employer.
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.