Data Engineer Lead

Integrity.

Care.

Trust.

Compassion.

Expertise.

Do these words resonate with you? These values of Builders culture create success in all we do.

We strive to provide deeply supportive partnerships to our customers, agents, and each other.

Builders is proud to be named among the Great Places to Work.

Our award-winning culture has earned top marks in Company Direction, Employee Appreciation, Work-Life Balance, Leadership, and Compensation and Benefits.

Our strong culture keeps us Built Strong in a forever-changing world, and our AM Best A Rating is evidence of our financial strength.

Position Summary The Data Engineering Lead serves as the technical owner of the companys Azure Databricks lakehouse platform supporting its property and casualty insurance business.

This role drives the design, development, and evolution of the platform, leveraging Databricks technologies including Delta Lake, Unity Catalog, Lakeflow pipelines, and Databricks SQL.

The Data Engineering Lead establishes and promotes engineering standards, best practices, and architectural principles to ensure a scalable, secure, reliable, and high-performing data platform.

A key responsibility is to lead the phased migration and modernization of data from Guidewire and legacy policy, claims, and billing systems into the Azure Databricks lakehouse.

The role champions effective data governance, security, and lineage through Unity Catalog, partnering closely with the Data Governance Lead to translate governance policies into practical, consistent engineering practices.

In addition, the Data Engineering Lead provides technical direction, mentorship, and leadership to a team of engineers and contractors, fostering collaboration, engineering excellence, and the successful delivery of strategic data initiatives.

Responsibilities Design the Databricks lakehouse architecture (bronze/silver/gold medallion on Delta Lake) for property and casualty policy, rating, claims, billing, reinsurance and customer data.Plan and lead the phased data migration from Guidewire (PolicyCenter, ClaimCenter, BillingCenter) and legacy systems into the lakehouse on Azure Databricks, including historical loads, incremental/CDC (change data capture) loads, reconciliation and decommissioning support.Model property and casualty insurance data: accounts, policies, insured risks and exposures, coverages, endorsements, premiums, claims, reserves, payments and recoveries.Deliver data for Actuarial and Finance: written/earned/unearned premium, loss triangles, IBNR (incurred but not reported) inputs, loss ratios, Schedule P and NAIC (National Association of Insurance Commissioners) statutory reporting.Integrate third-party data sources such as geospatial and weather data.Define the Unity Catalog design: metastore, catalogs, schemas, environments (development, test and production), naming conventions, permissions, row/column-level security and lineage.Manage pipeline orchestration and operations in Databricks: design job schedul...