Berkshire Hathaway Homestate Companies - Workers Compensation Division
Principal Data Architect
ARCHITECTURE LEADERSHIP
Develop and evolve the enterprise data architecture blueprint including cloud, on premises, and hybrid environments ensuring alignment with business and analytical/AI needs.
Set the direction for modern data integration, event driven design, master data management, and responsible AI enablement.
Evaluate current systems and design a practical modernization path forward that reduces technical debt and improves data quality and performance.
DATA PLATFORM AND ENGINEERING DESIGN
Lead the architectural design of enterprise data platforms for structured and unstructured data.
Architect a medallion platform (Bronze, Silver, Gold) across Microsoft Fabric and Snowflake, defining what lives where and why.
Design a metadata-driven lakehouse architecture across Bronze (raw ingestion), Silver (conformed and quality-controlled), and Gold (business-ready data products) layers, leveraging declarative metadata to drive ingestion pipelines, transformation logic, lineage, quality controls, partitioning strategies, and workload orchestration.
Establish Iceberg and Delta Lake as strategic open table standards, enabling ACID transactions, time travel, schema evolution, and cross-platform interoperability between OneLake, Snowflake, and downstream analytics workloads.
Define cross-platform access patterns (shortcuts, mirroring, external tables) for secure, governed access.
Design standards for ingesting data (batch, CDC, event-driven) from policy, claims, CRM, billing, underwriting, and workflow systems.
Establish scalable patterns for operational data feeds, partner data exchanges, real-time integration, and analytical pipelines.
Define the strategy and technical patterns for managing data copies, extracts, and transformations securely, including when to copy versus virtualize.
COLLABORATION AND LEADERSHIP
Partner closely with the Director of Data Strategy to make sure architecture aligns with business priorities.
Work with engineering, application teams, analytics, and actuarial groups to ensure efficient, well designed data flows.
Provide technical leadership for system modernization efforts and influence guide how data is structured, integrated and maintained across the enterprise.
DATA QUALITY AND GOVERNANCE
Define architectural standards that support enterprise data quality, lineage, metadata, and stewardship expectations.
Experience implementing enterprise data governance using Microsoft Purview and Microsoft Fabric governance capabilities, including data cataloging, lineage tracking, sensitivity labeling, data quality monitoring, access controls, and compliance reporting.
Establish reliable integration patterns for the company’s core systems.
Ensure the architecture meets audit, compliance, and security requirements.
Embed data quality checks, lineage, and classification tagging into the metadata-driven framework at each layer boundary, so governance is built in rather than added later.
TECHNICAL EXECUTION
Lead complex architecture reviews, solution designs, technical roadmaps, and build reference architectures.
Define semantic modeling standards and consumption patterns supporting Power BI Direct Lake, semantic models, Snowflake data sharing, and AI-ready data products.
Assess performance, cost, and scalability trade-offs across Fabric capacity and Snowflake compute.
Define semantic layer and consumption patterns (Power BI Direct Lake, Snowflake sharing) and AI-ready data foundations.
Oversee proof of concepts, technical assessments, and platform evaluations.
Bring structure and clarity to a mixed technology environment with legacy systems and modern cloud services.
EDUCATION/CERTIFICATIONS
- EDUCATION: Bachelor's degree in Computer Science, Data Science, or related field, required. Master's degree preferred.
- CERTIFICATIONS: One or more preferred:
SnowPro Advanced: Architect or SnowPro Core
Microsoft Certified: Fabric Analytics Engineer Associate (DP-600)
Microsoft Certified: Fabric Data Engineer Associate (DP-700)
Microsoft Azure Solutions Architect Expert (AZ-305)
TOGAF® Enterprise Architecture Certification
Certified Data Management Professional (CDMP)
DAMA Data Governance Certification
EXPERIENCE
12 plus years of experience in data architecture, data engineering, or system integration required.
Experience designing metadata-driven ingestion and transformation frameworks across medallion layers, including configuration-based onboarding of new sources.
Strong experience with large scale operational systems, transactional databases, and customer-facing platforms.
Deep experience with enterprise data feeds, real-time integration patterns, analytical data pipelines, and AI enabling architectures.
Experience designing enterprise data models, integration architectures, master and reference data solutions (MDM/RDM), and governed data ecosystems.
Hands-on experience architecting medallion platforms on Microsoft Fabric and/or Snowflake, with working knowledge of Iceberg and Delta table formats and cross-platform interoperability.
Strong understanding of insurance data, regulatory requirements, and complex transactional systems.
Experience designing data models, integration patterns, master data structures, and governed data ecosystems.
WHAT WE OFFER
- Hybrid Work Schedule (up to 2 days work from home)
- Multiple Office Locations - Financial District Downtown or Walnut Creek
- Paid Time Off
- Paid Holidays
- Immediate Vesting of Retirement Savings + Company Match
- Group Health Insurance (Medical, Dental, and Vision)
- Life and AD&D Insurance
- Long Term Disability Insurance
- Hospital Indemnity Insurance
- Accident and Critical Illness Insurance
- Flexible Savings Accounts
- Paid Community Volunteer Day
- Employee Assistance Program
- Tuition Reimbursement Program
- Employee Referral Program
- Diversity, Equity and Inclusion Program
Similar Jobs
What you need to know about the Chicago Tech Scene
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory


