Business Intelligence Engineer, E&S

IT · Richmond, Virginia
Department IT
Employment Type Full-Time
Minimum Experience Experienced
Compensation USD

We’re writing the future of risk.
Hamilton Insurance Group, Ltd. (“Hamilton”) is a Bermuda-headquartered company that underwrites specialty insurance and reinsurance risks on a global basis through its wholly-owned subsidiaries. Hamilton leverages analytics and research to create underwriting and investment value for its clients and shareholders.

We’re looking for a

Business Intelligence Engineer

Based in Richmond, Virginia, this role will develop our business intelligence (BI) solutions for Hamilton’s Global Data Warehouse. The candidate will be familiar with data warehouse builds and have experience working with large, complex data sets, along with expertise in Power BI.


What you will do


  • Execute data requests
  • Present information through reports
  • Translate business requirements into technical specifications
  • Design, build and deploy BI solutions using Power BI
  • Conduct unit testing and troubleshooting
  • Evaluate and improve existing BI systems
  • Collaborate with our global teams to integrate systems into the Global Data Warehouse
  • Develop/analyze database queries
  • Create visualizations and reports for requested projects
  • Develop and update technical documentation
  • Foster a team culture of continuous development
  • Be available for on-call support as needed


What you require for the role


  • Proven experience as a BI Developer or Data Scientist
  • Background in data warehouse design and data mining
  • In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) frameworks
  • Expertise with Microsoft Power BI
  • Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)
  • Proven ability to take initiative and be innovative
  • An analytical mind with a problem-solving aptitude
  • Experience working in an environment leveraging remote communication collaboration tools
  • Familiarity with agile and software development lifecycle work - including design, build, code review, testing, release and bug fixing

What you can expect from us

Join us, and we will ask you to Be smart, Be sensible, Be open and, above all else, Be more—strive harder, reach further, never give up. These First Principles are the intellectual and moral compass of everyone at Hamilton. They shape the way we build our team, the way we work and the way we will prosper.

We’re committed to creating an inclusive workspace where all employees thrive. We embrace all backgrounds, perspectives, experiences and talents – without discrimination. Whatever differences set you apart, whether visible or invisible, you will be welcome at Hamilton.

Thank You

Your application was submitted successfully.

  • Location
    Richmond, Virginia
  • Department
  • Employment Type
  • Minimum Experience
  • Compensation