Senior Business Intelligence Engineer

Berkshire Hathaway Specialty Insurance; Boston (MA); On-site; USD 110,000 - 130,000; Full time

Benefits offered by this job

Health, Dental & Vision

Disability Insurance

Life Insurance

401(k) with company match

Paid time off

Tuition reimbursement

Job summary

Berkshire Hathaway Specialty Insurance Company (BHSI) in Boston, MA is seeking an experienced Senior Business Intelligence Engineer to join the Global BI team supporting SME business through advanced analytics and data products. You will translate business requirements into trusted data models, dashboards, and reusable analytical assets to drive performance.

The role requires strong SQL, Power BI expertise, and experience in data warehousing or semantic modeling, with ability to collaborate

Qualifications

• Bachelor’s degree or higher in a related field.
• 5+ years of experience in Business Intelligence, analytics, reporting, data management, or related discipline.
• Strong understanding of insurance reporting and analytics concepts.
• Advanced SQL skills to investigate, analyze, validate and reconcile complex datasets.
• Experience with Power BI or comparable enterprise BI platforms.
• Experience with dimensional models, semantic models, data warehouses, or modern analytical data platforms.
• Ability to translate complex business questions into analytical solutions and insights.
• Strong analytical and problem-solving skills with effective communication across teams.

Responsibilities

• Develop a deep understanding of SME business processes, products, and information needs to design BI solutions.
• Partner with stakeholders to translate questions into scalable deliverables.
• Design, develop, test, deploy and support Power BI reports, dashboards, and semantic models.

Skills

Business Intelligence

SQL

Power BI

Data modeling

Stakeholder communication

Education

Bachelor’s degree in Business/Analytics/CS/IS/Math

Tools

Power BI

Azure Analytics

Microsoft Fabric

Job description

Salary Range: $110,000.00 To $130,000.00 Annually

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?

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 manually assembled reporting.
• Contribute to the Global BI Center of Excellence through reusable patterns, standards, templates, documentation and technical best practices.

Qualifications, Skills and Experience:

Required

• Bachelor’s degree in Business, Analytics, Computer Science, Information Systems, Mathematics, or a related field.
• 5+ years of experience in Business Intelligence, analytics, reporting, data management, or a related discipline.
• Strong understanding of insurance reporting and analytics concepts.
• Advanced SQL skills with the ability to independently investigate, analyze, validate and reconcile complex datasets.
• Strong experience with Power BI or comparable enterprise BI and visualization platforms.
• Experience working with dimensional models, semantic models, data warehouses, or modern analytical data platforms.
• Demonstrated ability to translate complex business questions into analytical solutions, reporting and actionable insights.
• Strong analytical and problem-solving skills, with the ability to communicate effectively and build trusted relationships across business and technology teams.
• Proven ability to manage multiple priorities in a fast-paced environment.

Preferred

• Experience supporting digital insurance, small commercial insurance, direct-to-broker, or other high-volume transactional businesses.
• Familiarity with insurance lifecycle concepts, including submissions, indications, quotes, binds, policies, premium, distribution and underwriting performance.
• Experience developing enterprise semantic models, governed BI datasets and reusable data products.
• Experience with Microsoft Fabric, Azure-based analytics technologies or modern cloud-based analytical platforms.
• Experience with data governance, metadata management, data quality initiatives or business data dictionaries.
• Experience working within Agile delivery models and business-led analytical environments.

What Success Looks Like

The successful Senior Business Intelligence Engineer will:

• Become a trusted BI partner for the SME business and a subject matter expert on both the business and its underlying data.
• Establish a consistent, trusted view of performance across the SME business.
• Build scalable, governed BI capabilities that reduce fragmented or manually assembled reporting.
• Create stronger alignment around SME business definitions, KPIs and performance measurement.
• Develop and execute a BI roadmap driven by business value and strategic priorities.
• Strengthen collaboration between business stakeholders, BI, Data Engineering and Technology teams.
• Balance the speed and agility needed for a digital business with the governance and consistency expected of an enterprise BI function.

BHSI Offers:

• A competitive package and exciting growth opportunities for career-oriented teammates.
• A dynamic, action oriented, and thoughtful environment centered on always doing the right thing for our customers, teammates, and our other stakeholders.
• A purposely non-bureaucratic organization that embraces simplicity over complexity and emphasizes individual excellence in a team framework.
• Benefits that support your life and well-being, which include:
• Comprehensive Health, Dental and Vision benefits
• Disability Insurance (both short-term and long-term)
• Life Insurance (for you and your family)
• Accidental Death & Dismemberment Insurance (for you and your family)
• Flexible Spending Accounts
• Health Reimbursement Account
• Employee Assistance Program
• Retirement Savings 401(k) Plan with Company Match
• Generous holiday and Paid Time Off
• Tuition Reimbursement

The base salary range for this position in Boston, MA is $110,000 to $130,000, along with annual bonus eligibility. Total compensation for a candidate is determined by their relevant skills, location, and experience. We value our teammates - both their capabilities and character - as demonstrated by our amazing culture.

NOTE: Compensation will be commensurate with experience. This job description is not intended to be all-inclusive. Team Member may perform other related duties as negotiated to meet the ongoing needs of the organization.