Back to HomeAgent PortalFind an Agent

Berkley Mid-Atlantic Group | a W. R. Berkley Company

COMPANY SUMMARY

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 Analyst – Core Systems 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.

 

POSITION SUMMARY

Work with business stakeholders to gather requirements and design / implement new BI / reporting solutions

   

RESPONSIBILITIES

 

  • 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.

 

 REQUIRED QUALIFICATIONS

 

  • Strong skills in T-SQL development (stored procedure, functions etc…)
  • 5+  SQL Server Analysis Services (SSAS, MDX)
  • 5+  years SQL Server Reporting Services (SSRS)
  • 5+ Years of SQL / T-SQL
  • 3+  years SQL Server Integration Services (SSIS)
  • 2+  years Testing and Data Quality
  • Strong skills in Excel

 

Optional Requirements

  • Insurance Knowledge
  • Pyramid Analytics a plus

 

 EDUCATIONAL REQUIREMENTS

 ·         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.

butt topic smallcomm

A simplified solution for writing your small commercial customers by providing quick quote technology and underwriting support for businesses

>> Read More

Expert underwriters, territory and risk managers who deliver product and service solutions that cater to large and mid-size customers in more than 1,000 classes of business.

>> Read More

butt topic agentportal

Licensed BMAG agents may log in to the Agent Portal for simple and clear access to news, product updates, customer data, reports and much more.

>> Read More

Berkley Mid-Atlantic Group… Insuring the Future of Business®

Delaware • Kentucky • Maryland • New Jersey  • Ohio • Pennsylvania • Virginia • Washington D.C. • West Virginia

Home Careers Business Intelligence Developer, Richmond, VA

Find An Office Near You

1

Home Office / Capital Region, Glen Allen, VA

P: (800) 283-1153, Mail: info@wrbmag.com.
2

Ohio Office, Columbus, OH

P: (800) 283-1153, Mail: info@wrbmag.com
3

Pittsburgh Office, Sewickley, PA

P: (800) 283-1153, Mail: info@wrbmag.com
4

Harrisburg Office, Harrisburg, PA

P: (800) 283-1153, Mail: info@wrbmag.com