Data Engineer

Job content

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

Business Description

Verisk Underwriting is a division of Verisk Analytics. We create sophisticated risk models to assist insurers with risk selection and accurate pricing. Our range of models is broad spanning residential and commercial property perils, motor insurance, travel, pet and health insurance. To feed our risk models we source many diverse datasets covering high resolution weather data, property attributes, business activities and financial data, insurance claims and policies, medical information, aerial imagery and geodemographic data.

Role Purpose

Verisk is an analytics company and data is key to our business. This is a hybrid role with responsibility for the storage and organisation of our data as well as the processing, validation and output of high-quality data.

We are looking for a motivated, independent and well organised individual who enjoys working with data. The data engineer will be responsible for the ETL processes as well as the maintenance and administration of a cloud-based database. They will use our data platform to source, structure and validate our data.

Our competitive advantage is the quality of our data, measured by accuracy, completeness, and consistency. Validation of our data is critical, and the postholder will be responsible for regular data quality reporting and acting to improve data quality. This will include responding to customer queries on data issues and preparing data for internal and external customers.

The role will rely on high levels of automation and a strong attention to detail to making sure that our processes flow smoothly and are effective. The postholder will work with members of the Analytics, IT and Sales teams to ensure that our data is up to date and remains best in class.

Role Responsibilities

• Maintain and extend a PostgreSQL DB which the whole Analytics team can use and is a repository for all our datasets in relation to home, motor, travel, commercial lines etc.
• Assist data scientists with DB queries to aid efficiency of analysts in UK, Ireland and Krakow
• Establish an ETL process for new datasets including full validation and data quality assessment.
• Manage data for strategic projects such as the Verisk Quote Hub.
• Work with subject matter experts to identify how data errors should be corrected and create sophisticated validation checks.
• Take responsibility for the biannual updates of perils models including preparation of client deliverables (This is not remodelling but rerunning existing models on new addresses/property data)
• Automation of data processes
• Extraction of data for prospective customers to test models
  

Qualifications

Skills & Experience

• 3-5 years’ experience in a data management role
• Relational Database Management Systems (RDBMS)  and SQL ,  3+ years
• General, overall knowledge of AWS Cloud services, ideal if also AWS certified
• Data engineering/wrangling and ETL pipeline building, 2+ years
• Python programming and interfacing with RDBMS (e.g  psycopg2) and AWS services (e.g  boto3),  2+ years
• Strong understanding of how to use automation to achieve processing scalability and speed
• Experience working with data, including processes for data validation and quality control
• An understanding of data management fundamentals, including concepts such as data dictionaries, data models, validation, and reporting.
• University degree in information technology or similar
  

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 Verisk to be, and to make the world, more productive, resilient, and sustainable.

Verisk works in collaboration with our customers and at the intersection of people, data, and advanced technologies. Through proprietary platformed analytics, advanced modeling, and interpretation, we deliver immediate and sustained value to our customers and through them, to the individuals and societies they serve, with greater speed, precision, and scale. We’re 9,000 people strong, committed to translating big data into big ideas. We help others see new possibilities and empower certainty into big decisions that impact individuals and societies. And we relentlessly and ethically pursue innovation to help move our customers, and the world, toward better tomorrows.

Everyone at Verisk—from our chief executive officer to our newest employee—is guided by The Verisk Way, to Be Remarkable, Add Value, and Innovate.

• Be Remarkable by doing something better each day in service to our customers and each other
• Add Value by delivering immediate and sustained results that drive positive outcomes
• Innovate by redefining what’s possible, embracing challenges, and pushing boundaries
  

Verisk Businesses

Underwriting Solutions — provides underwriting and rating solutions for auto and property, general liability, and excess and surplus to assess and price risk with speed and precision

Claims Solutions — supports end-to-end claims handling with analytic and automation tools that streamline workflow, improve claims management, and support better customer experiences

Property Estimating Solutions — offers property estimation software and tools for professionals in estimating all phases of building and repair to make day-to-day workflows the most efficient

Extreme Event Solutions — provides risk modeling solutions to help individuals, businesses, and society become more resilient to extreme events.

Specialty Business Solutions — provides an integrated suite of software for full end-to-end management of insurance and reinsurance business, helping companies manage their businesses through efficiency, flexibility, and data governance

Marketing Solutions — delivers data and insights to improve the reach, timing, relevance, and compliance of every consumer engagement

Life Insurance Solutions – offers end-to-end, data insight-driven core capabilities for carriers, distribution, and direct customers across the entire policy lifecycle of life and annuities for both individual and group.

Verisk Maplecroft — provides intelligence on sustainability, resilience, and ESG, helping people, business, and societies become stronger

Verisk Analytics is an equal opportunity employer.

All members of the Verisk Analytics family of companies are equal opportunity employers. We consider all qualified applicants for employment without regard to race, religion, color, national origin, citizenship, sex, gender identity and/or expression, sexual orientation, veteran’s status, age or disability.

http://www.verisk.com/careers.html

Unsolicited resumes sent to Verisk, including unsolicited resumes sent to a Verisk business mailing address, fax machine or email address, or directly to Verisk employees, will be considered Verisk property. Verisk will NOT pay a fee for any placement resulting from the receipt of an unsolicited resume.