Back to HomeAgent PortalFind an Agent


Business Intelligence Analyst, Richmond, VA


Berkley Mid-Atlantic Group (BMAG) is a property & casualty insurance carrier serving the Mid-Atlantic, a member of W.R. Berkley Corporation (NYSE: WRB), one of the largest property casualty insurance holding companies in the United States.  We are backed by the strength of a large fortune 500 corporation and operate with the closeness and flexibility of a small company. We exclusively work with select independent agents to insure the future of business.

Our leadership encourages a culture that empowers employees to question the status quo and seek innovative ways to continue to exceed the expectations of our customers.  We believe our strength comes from building an exceptional team that embraces collaboration, growth and ownership.  We currently have an opening for a Business Intelligence Analyst in our Richmond, VA office.    If you share our vision and want to work for an organization that values your contributions, we want to hear from you.


This position will join the Business Intelligence Team supporting Property & Casualty Lines and use available data sources to help provide meaningful. Ideal candidates will be able to work with large datasets and find meaningful information that will help the business reach its goals. This includes the design, development, and implementation of new Business Intelligence and reporting solutions, as well as providing support on existing tools and projects. Candidates must be skilled in SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS, MDX), and Microsoft Excel for reporting and analytics—or skilled in use of comparable BI software. SQL Server Integration Services (SSIS) and SQL/T-SQL development are also valued.


  • Work with business stakeholders to gather requirements and design / implement new BI / reporting solutions
  • Collect business intelligence data from available industry reports, public information, or purchased sources
  • Look at the data trends and recommend solutions for creating more revenue and reducing loss.
  • Resource will be supporting Business Intelligence and Data Warehouse.
  • Data Investigation and reporting – Extracts data from operational systems and reporting databases using a variety of tools, including SSIS. Ability to understand and identify relationships within the data and between databases, understands requirements of the customer, and the location of required data. Validates accuracy of the results and able to provide meaningful insights.
  • Provide technical support for existing reports, dashboards, or other tools like SQL querying databases, SQL Server Integration Services, SQL Server Reporting Services and SQL Server Analysis Services, Pyramid, Excel etc.  
  • Answers developer and end user questions through the development life cycle
  • Completes functional testing on assigned projects
  • Work Management – Manages multiple tasks, with the ability to deal with ambiguity and shifting priorities.
  • Communicates status clearly and timely to management and other team members. Provides accurate time reporting and reasonable estimates for work efforts.
  • Documentation of methods, business requirements, SQL coding, and reporting criteria to a level consistent with departmental standards
  • Strong experience working with SQL servers and relational database systems.


  • Strong skills in T-SQL development
  • 2+ years of SQL Server Reporting Services (SSRS), Excel, and SQL Server Analysis Services (SSAS, MDX), or a comparable background using other business intelligence software (e.g. Tableau, MicroStrategy, etc.)
  • 1+ years of Testing and Data Quality
  • Skilled in SQL/T-SQL
  • 2+ years of SQL Server Integration Services (SSIS)
  • Strong skills in Excel (creating pivot tables, macros, etc.)

Optional Requirements

  • Insurance Knowledge
  • Pyramid Analytics a plus


  • Bachelor’s Degree or three plus years of commensurate experience


Interested applicants should forward a resume to: This email address is being protected from spambots. You need JavaScript enabled to view it. 

Home Careers Current Positions Careers Business Intelligence Analyst, Richmond, VA

Find An Office Near You


Home Office / Capital Region, Glen Allen, VA

P: (800) 283-1153, Mail:

Ohio Office, Columbus, OH

P: (800) 283-1153, Mail:

Pittsburgh Office, Sewickley, PA

P: (800) 283-1153, Mail:

Harrisburg Office, Harrisburg, PA

P: (800) 283-1153, Mail: