Data Engineer

Data Engineer Opportunity At GUARD Insurance CompaniesGood 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-officeCompetitive pay + generous PTOMedical, dental & vision starting day one401(k), tuition reimbursement & longevity bonusesResponsibilitiesWe are hiring a 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 models in 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 riskApply 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.QualificationsRequired:Hands-on experience in data modeling (conceptual, logical, physical), data engineering, analytics engineering, SQL, and PythonBachelor's or Master's degree in Computer Science, IT, or related field5+ years of data engineering experience, preferably in P&C insuranceExperience 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 practicesExperience with data transformation, semantic modeling, and BI tools (Power BI, Tableau)Strong analytical and problem-solving skillsExperience working in Agile/Scrum environments with product-based deliveryExperience delivering end-to-end data, analytics, or AI solutions with business stakeholdersStrong communication and collaboration skillsPreferred:Experience with distributed processing frameworks (e.g., Spark)Knowledge of data warehousing concepts and toolsAdditional programming experience (e.g., Scala)Understanding of data security and complianceMicrosoft Fabric certifications (e.g., DP-600, DP-700)Experience with AI agents or multi-agent frameworks for business use casesSalary 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, PAThe successful candidate is expected to work in one of our offices 3 days per week and also be available for travel as required.