Senior Business Intelligence Engineer

Who are we?  A strategic and trusted insurance partner, Berkshire Hathaway Specialty Insurance (BHSI), provides a broad range of commercial property, casualty and specialty insurance coverages and outstanding service to customers and brokers around the world. Part of Berkshire Hathaway’s insurance operations, we bring our solutions to market with our stellar brand name, top-rated balance sheet, and the expertise of our global team of professionals, who exude excellent capabilities and strong character.

We are a values-based organization where respect, integrity, excellence, collaboration, and passion define who we are and how we do business. We value diversity of backgrounds, experience, and perspectives and strive to foster an inclusive environment that enables all our team members to bring their best selves to work. We are one team committed to building a culture where every teammate has the opportunity to contribute and be recognized.

Want to be part of the team building the finest property, casualty and specialty lines insurance company in the world?

Learn more about our unique culture and history.

Job Opportunity: BHSI has an exciting opportunity for an experienced Senior Business Intelligence Engineer to join our Global Business Intelligence team in Boston, Massachusetts. This role will support BHSI’s Small and Medium Enterprise (SME) business, including our digital and direct-to-broker distribution capabilities.

The Senior Business Intelligence Engineer will partner closely with business, underwriting, operations, technology, Data Engineering, and BI teammates to design, build, and evolve the reporting and analytics capabilities needed to support a growing, digitally enabled insurance business. This individual will develop a strong understanding of the SME business and translate business requirements into trusted data models, semantic models, dashboards, reporting, analytics, and reusable data products.

As part of the Global Business Intelligence organization, this role will apply consistent BI engineering standards while ensuring solutions meet the unique needs of the SME business. The successful candidate will combine strong technical capability, analytical thinking, business curiosity, and a commitment to data quality, with the ability to collaborate across business and technical teams and independently deliver production-quality BI solutions.

Duties & Responsibilities:

Develop a deep understanding of SME business processes, products, distribution models, performance drivers, and information needs and apply that knowledge to BI solution design.

Partner with business stakeholders and BI leaders to translate business questions and analytical needs into scalable solutions and prioritized deliverables.

Design, develop, test, deploy, and support Power BI reports, dashboards, semantic models, and reusable analytical data products that provide a trusted view of SME business performance.

Build and maintain reporting across the SME insurance lifecycle, including submissions, indications, quotes, binds, policies, premium, portfolio performance, distribution, and operational activity.

Use advanced SQL to investigate, transform, validate, reconcile, and optimize complex datasets across multiple source systems and analytical platforms.

Develop dimensional and semantic models that support consistent business definitions, reusable measures, governed datasets, and self-service analytics.

Partner with Data Engineering and Technology teams to define data requirements, improve data quality, resolve defects, and deliver scalable and reliable data pipelines and analytical solutions.

Monitor and improve the usability, reliability, performance, and adoption of BI solutions while reducing fragmented or…