Data Engineer

Berkshire Hathaway GUARD Insurance Companies; New York (NY); Hybrid; USD 100,000 - 140,000; Full time

Benefits offered by this job

Hybrid schedule: 2 days remote / 3 in‑

Competitive pay + generous PTO

Medical, dental & vision starting day

401(k), tuition reimbursement &lon gev

Job summary

Berkshire Hathaway GUARD Insurance Companies in New York, NY is seeking a hands-on Senior Data Engineer to build governed data products and translate business questions into datasets and Power BI models. You will collaborate with underwriting, product, claims, and analytics teams to deliver insight-driven solutions.

The role requires 5+ years in data engineering, experience with lakehouse platforms (Microsoft Fabric, Databricks, Snowflake), and cloud data pipelines.

Qualifications

• Bachelor’s or Master’s degree in Computer Science, IT, or related field.
• 5+ years of data engineering experience, preferably in P&C insurance.
• Experience with Data Mesh and modern lakehouse platforms.
• Experience building data solutions in cloud environments (Azure preferred).
• Strong SQL and Python, data modeling, and BI tooling expertise.

Responsibilities

• Collaborate with cross-functional teams to transform business questions into data solutions.
• Model and publish curated datasets and semantic models in Power BI or analytics delivery.
• Design and maintain scalable ELT/ETL pipelines and lakehouse structures in Microsoft Fabric.
• Document architecture and governance standards to support onboarding and risk reduction.
• Work in an Agile/Scrum environment with product-based delivery.

Skills

Data modeling

Data engineering

SQL

Python

Power BI

Analytical thinking

Communication

Education

Bachelor’s or Master’s in CS/IT or related

Tools

Microsoft Fabric

Databricks

Snowflake

AWS

Azure DevOps

Job description

Good Things Start Here.

Good things are happening at Berkshire Hathaway GUARD Insurance Companies—an A+ (Superior) rated, nationwide Property & Casualty insurer backed by Berkshire Hathaway. With supportive leadership, collaborative teams, and opportunities to grow, GUARD is a place where people build meaningful, long‑term careers.

Overview

Good Things Start Here.

Good things are happening at Berkshire Hathaway GUARD Insurance Companies—an A+ (Superior) rated, nationwide Property & Casualty insurer backed by Berkshire Hathaway. With supportive leadership, collaborative teams, and opportunities to grow, GUARD is a place where people build meaningful, long‑term careers.

Good Things You Can Count On.

• Hybrid schedule: 2 days remote / 3 in‑office
• Competitive pay + generous PTO
• Medical, dental & vision starting day one
• 401(k), tuition reimbursement & longevity bonuses

Responsibilities

We are hiring ahands‑on senior level Data Engineer to build trustworthy, well governed data products and turn them into insights that drive underwriting, claims, product, distribution, and operations for the organization. You will collaborate directly with business leaders to translate questions into curated datasets, intuitive Power BI models, analytic insights and clear narratives that influence decisions. You’ll context switch comfortably between data & analytic engineering and meeting with business stakeholders to understand their processes and needs.

What You’ll Do

• Collaborate closely with cross-functional teams; including Underwriting, Product, Claims, Finance, and Distribution/Operations- to transform business questions into clearly documented requirements and actionable data solutions.
• Model and publish curated, analysis ready datasets, semantic modelsin Power BI or analytics delivery that illuminate small commercial metrics.
• Continuously learn and expand business knowledge to proactively produce automated analytic solutions to business challenges.
• Design, develop, and maintain scalable ELT/ETL pipelines and lakehouse structures in Microsoft Fabric; Follow platform standards, optimize for performance, reliability, and cost.
• Follow and implement documentation standards, governance and data quality controls across datasets.
• Use Azure DevOps (ADO) for CI/CD and version control (branching, pull requests, release pipelines) to harden delivery and improve repeatability.
• Document technical architecture and workflows to support onboarding and reduce risk
• Apply best practices in data modeling and engineering to create reusable, high‑quality data products.
• Work in an Agile/Scrum environment, contributing to sprint planning, backlog refinement, and demos.
• Support development and scaling of data products, BI solutions, and AI‑driven use cases across business areas.

Required

Qualifications

• Hands‑on experience in data modeling (conceptual, logical, physical), data engineering, analytics engineering, SQL, and Python
• Bachelor’s or Master’s degree in Computer Science, IT, or related field
• 5+ years of data engineering experience, preferably in P&C insurance
• Experience with Data Mesh (domain ownership and decentralized data products)
• Strong experience with modern lakehouse platforms (e.g., Microsoft Fabric, Databricks, Snowflake, AWS)
• Experience building data solutions in cloud environments (Azure preferred; AWS a plus)
• Familiarity with Azure DevOps (ADO) and CI/CD practices
• Experience with data transformation, semantic modeling, and BI tools (Power BI, Tableau)
• Strong analytical and problem‑solving skills
• Experience working in Agile/Scrum environments with product-based delivery
• Experience delivering end‑to‑end data, analytics, or AI solutions with business stakeholders
• Strong communication and collaboration skills

Preferred

• Experience with distributed processing frameworks (e.g., Spark)
• Knowledge of data warehousing concepts and tools
• Additional programming experience (e.g., Scala)
• Understanding of data security and compliance
• Microsoft Fabric certifications (e.g., DP-600, DP-700)
• Experience with AI agents or multi‑agent frameworks for business use cases

Salary Range

$100,000 – $140,000.

In accordance with applicable pay transparency laws, the above range represents a good‑faith estimate. Final compensation will be determined based on factors such as experience, credentials, geographic location, and other considerations permitted by law.

This role may be based out of any of our office locations, including: Plano, TX, New York, NY, Scottsdale, AZ, Wilkes-Barre, PA

The successful candidate is expected to work in one of our offices 3 days per week and also be available for travel as required.