Data Engineer

Berkshire Hathaway GUARD Insurance Companies; Wilkes-Barre (Luzerne County); Hybrid; USD 100,000 - 140,000; Full time

Benefits offered by this job

Hybrid schedule: 2 days remote / 3 in‑

Predictable hours (no nights, weekends

Competitive pay + generous PTO

Medical, dental & vision starting day

401(k), tuition reimbursement & longev

Job summary

Berkshire Hathaway GUARD Insurance Companies seeks a senior Data Engineer to build trusted, governed data products and turn them into actionable insights across underwriting, claims, and operations.

You will translate business questions into datasets and BI models, collaborating with leaders to deliver scalable ELT/ETL pipelines in modern lakehouse platforms while contributing in an Agile environment. Hybrid work with occasional travel is expected.

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 modeling, analytics engineering, SQL, and Python.
• Experience with data mesh concepts and domain ownership.
• Strong familiarity with modern lakehouse platforms (Microsoft Fabric, Databricks, Snowflake).
• Experience building data solutions in cloud environments (Azure preferred; AWS a plus).
• Familiarity with Azure DevOps (ADO) and CI/CD practices.
• Experience with Power BI or Tableau for analytics delivery.
• Strong communication and collaboration skills.

Responsibilities

• Collaborate with cross-functional teams to translate business questions into documented requirements and 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.
• Develop automated analytic solutions and insights for underwriting, claims, product, and operations.
• Follow governance and data quality controls across datasets and document architectures.

Skills

Data modeling

SQL

Python

Cloud data engineering

BI tools

Data Mesh

Azure DevOps

Agile/Scrum

Education

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

Tools

Microsoft Fabric

Databricks

Snowflake

Azure

Power BI

Tableau

AWS

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
• Predictable hours (no nights, weekends, or holidays)
• Competitive pay + generous PTO
• Medical, dental & vision starting day one
• 401(k), tuition reimbursement & longevity bonuses

Responsibilities

We are hiring hands-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
• Applicants must be authorized to work in the U.S. without current or future sponsorship

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, and/or Scottsdale, AZ

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