Data Analyst

Company Details

W. R. Berkley Corporation, founded in 1967, is one of the nation’s premier commercial lines property casualty insurance providers.

Founded in 2004, Berkley Environmental has underwriting and account executive units in seven regions. Berkley Environmental offers an array of coverages for virtually all classes traditionally known to have environmental liability exposures on both an admitted and non-admitted basis.

We provide a comprehensive portfolio of commercial property casualty insurance, automobile liability and workers’ compensation, along with claim services, providing expertise to meet the unique business needs of our customers.

Berkley Corporation has reached a milestone and is celebrating 50 years, click here to read more on the history of the company.

Company URL :

The company is an equal opportunity employer.

Responsibilities

The Data Analyst provides support within the Actuarial Department for data calls, regulatory filings and internal / external reporting.

Responsibilities for this position include gathering business requirements, developing custom SQL queries, building spreadsheets and reports, reconciling data and participating in ad hoc requests and projects

• Assist with compiling, reconciling and analyzing data that support various Actuarial responsibilities.
• Gain extensive knowledge of source systems and available data.
• Collaborate with IT to understand and identify critical fields in data warehouses.
• Define and document business requirements for financial / statistical reporting.
• Develop and maintain data queries in SQL to transform relational data into reportable data for monthly, quarterly and annual reporting needs.
• Collaborate with Regulatory to complete required exhibits for regulatory filings.
• Assist in the analysis of data, including comparisons and reconciliations to General Ledger and Annual Statement data to ensure accuracy and completeness.
• Improve and enhance existing reporting tools.
• Assist Management in developing new analytical reports.
• Identify beneficial external data sources.
• Develop effective working relationships with various departments through demonstrated knowledge, professionalism and enthusiasm.
• Perform other related duties as required.

Qualifications

• 5+ years of experience in the P&C insurance industry, preferably with an information technology or financial background.
• Proficient in the Structure Query Language (SQL), preferably with Microsoft SQL Server, which includes being able to independently write SQL selection statements and familiarity with Relationship Database Concepts, Joins, Sub-Queries, Aggregate Functions, Temporary Tables, and Common Table Expressions.
• Proficiency in Excel, with exposure to VBA a plus.
• Strong analytical, critical thinking and problem-solving skills.
• Strong project management, organization and planning skills.
• Demonstrated experience in effective collaboration and providing a high degree of customer satisfaction.
• Ability to effectively work in an environment with competing demands, resources, and timelines.

Education Requirements

• Bachelor’s degree or equivalent.
• Background in math, statistics, information technology or computer science preferable.

Additional Company Details

We do not accept any unsolicited resumes from external recruiting agencies or firms.

Sponsorship Details

Sponsorship not Offered for this Role