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

Berkshire Hathaway Specialty Insurance (BHSI) has an exciting opportunity for a Business Intelligence Engineer. A Business Intelligence Engineer is responsible for designing, developing, maintaining, monitoring, and extending the data warehouse and analytics architecture to meet BHSI’s reporting needs. The design and development focus includes but is not limited to dimensional data model design, Extraction Transformation Layer (ETL) frameworks and processing, metadata management, operational data integration, master data definition and data quality, data auditing and profiling, hands on Azure experience and business intelligence reporting solutions.

The new team member will partner with the technical lead team and various business partners to map the technical vision for applications in the Data Warehouse employing Azure and SQL server. Additionally, they will be responsible for reviewing, analyzing, modifying, and creating ETLs, CD/CI pipelines, DevOps, testing, debugging, integration, and implementation processes. Responsibilities also include documenting technical needs for ETL processes and databases, and ensuring optimal technical infrastructure is utilized.

Duties & Responsibilities

• Collaborate with multiple business and technical teams to review and prioritize deliverables.
• Translate and communicate technical requirements into well designed solutions that meet the business and technical goals defined by business stakeholders (internally and externally).
• Design, develop and optimize enterprise level reporting, OLAP and other business intelligence solutions, and cross train others in the use of the tools.
• Debug and troubleshoot data quality problems using SQL tools.
• Build and automate data solutions to support business processes using SQL and PowerBI
• Coordinate upgrades and rollouts of application updates within current tooling and coordinate activities related to training and monitoring performance.
• Coordinate interdepartmental activities and assist in problem resolution to ensure that BHSI meets internal and external customer requirements.
  
  

Qualifications, Skills And Experience

• Extensive experience in data warehouse reporting and ETL tools
• Experience in handling technology projects/programs in Insurance Domain
• Experience with collaborating with onshore/offshore teams.
• 3-5 years of insurance experience
• Minimum 5 years’ experience using SQL Server 2017 or higher preferred.
• Experience with Power BI/Fabric and other visualization tools
• Strong experience in writing production SQL code (stored procedures, functions, ETL jobs)
• Strong understanding of data modeling and warehousing techniques
• Experience with cloud native tooling i.e. Power Automate, Azure Data Factory
• Strong analytical, problem solving, and conceptual skills with ability to work across business areas.
• Strong verbal and written communication skills, with an ability to express business concepts in technical terms, and complex technical solutions in business terms.
• Passionate and professional demeanor that supports a collaborative and team-oriented environment.
• Ability to articulate basic project agile methodology
  
  

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
• Paid Parental Leave
  
  

The base salary range for this position in Stevens Point, WI is $85,000 to $110,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.