200+ applicants

Company

Original Job Post

Berkley Environmental (a Berkley Company) · 1 week ago

Data Analyst

Jersey City, NJ

Full-time

Onsite

Senior Level

$69K/yr - $138K/yr

5+ years exp

Wonder how qualified you are to the job?

ConsultingInsurance

Insider Connection @Berkley Environmental (a Berkley Company)

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

Responsibilities

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.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

P&C insurance industry experienceInformation technology backgroundFinancial backgroundSQLMicrosoft SQL ServerDatabase ConceptsJoinsSub-QueriesAggregate FunctionsTemporary TablesCommon Table ExpressionsExcelVBAMath backgroundStatistics backgroundComputer science backgroundAnalyticalCritical thinkingProblem solvingProject managementOrganizationPlanningCollaborationCustomer satisfaction

Required

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.

Bachelor’s degree or equivalent.

Background in math, statistics, information technology or computer science preferable.

Benefits

Health

Dental

Vision

Life

Disability

Wellness

Paid Time Off

401(k)

Profit-Sharing plans

Company

Berkley Environmental (a Berkley Company)

Berkley Environmental facilities have earned their reputation as innovative problem solvers with the skill to recognize the reality of the market while maintaining underwriting discipline and consistency throughout the underwriting cycle.

Founded in 2004

Jersey City, New Jersey, USA

201-500 employees