Actuary Analyst, SQL Database Designer

Company Description

We help the world see new possibilities and inspire change for better tomorrows. Our analytic solutions bridge content, data, and analytics to help business, people, and society become stronger, more resilient, and sustainable.

Job Description

The Data Engineering & Analytics Lab (DEAL) is responsible for the design and implementation of our core statistical data-systems including data ingestion, data integration, data transformation, data analysis, and analytic dataset construction. We’re an innovation group that is charged with visualizing the future of our organization’s operations and leveraging our expertise in data, technology, P&C insurance, and process optimization to provide a first-class analytics environment to our data-collection, data-management, actuarial, and data-analytics colleagues.  

The DEAL team is looking to hire an experienced Actuarial Associate, ideally having a good combination of an analytical/innovative mindset, technical aptitude, line of business experience, and communication skills. For internal candidates, this position is open to grade level 15-17.  

This is a hybrid role that will combine actuarial and data engineering skills and will be expected to manage multiple work-streams supporting a wide array of internal customers. 

The role will have responsibility for managing all aspects of a line of business's data-infrastructure from ingestion to analytic frameworks to content generation.  

Some anticipated work assignments include: 

• Build and maintain robust data engineering process to develop and implement self-serve data 

• Support product implementation on a new and innovative technology platform with product requirements, actuarial calculations, methods, and validation 

• Design, build and launch extremely efficient & reliable data pipelines to move data (both large and small amounts) in/out of our Snowflake Data Lake 

• Assist with product development and implementation including modeling and assumption development 

• Execute data engineering projects ranging from small to large either individually or as part of a project team 

• Perform other tasks on R&D, data governance, system infrastructure, and other cross team functions, on an as-needed basis 

• Adopt an agile framework to schedule work, adjust as needed and continuously improve performance 

• Communicate performance with relevant internal stakeholders 

• Work with data analysts to develop reports and visualizations 

• Assist in scoping and designing analytic data assets 

• Find opportunities to create, automate and scale repeatable analyses or build self-service tools for business users 

You will be part of a culture that embraces learning and innovation, values teamwork, recognizes and rewards achievements and excellence, and provides personal and professional enrichment opportunities. 

Qualifications

• Bachelor’s degree in a quantitative (STEM) discipline with 4+ years of work experience in data\actuarial analysis & data engineering 

• Completion of CAS Exam 5 (Basic Ratemaking), ACAS or higher preferred 

• Minimum 4 years of experience working with property & casualty insurance data, preferably supporting an actuarial/data-science function in one of the following lines of business (Commercial Property, General Liability, Commercial Auto, Personal Auto) 

• Highly proficient with SQL and database concepts 

• Familiarity with rating manuals, loss cost (rate) filings, and statistical data 

• Experience in preparing and conducting extensive business analysis and studies, process assessments, data analysis, and requirement specification  

• Proficiency in Python, object-oriented programming, and data structures 

• Strong technical and project management/process leadership skills 

• Excellent verbal and written communication skills required 

Additional Information

In 2022, Verisk received Great Place to Work® Certification for our outstanding workplace culture for the sixth year in a row and second-time certification in the UK, Spain, and India. We’re also one of the 38 companies on the UK’s Best Workplaces™ list and one of 18 companies on Spain’s Best Workplaces™ list.

For over fifty years and through innovation, interpretation, and professional insight, Verisk has replaced uncertainty with precision to unlock opportunities that deliver significant and demonstrable impact. From our historic roots in risk assessment, we’ve grown to provide analytic insights that help transform industries focused on some of the world’s most critical areas. Today, the insurance industry relies on Veri