Data Engineer

Key Skills

Automation, AWS, Cloud computing, Data management, ETL/ELT technologies, Python Programming, RDBMS, SQL

Job Description

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

At Verisk Analytics we create sophisticated risk models to assist insurers with risk selection and pricing. Our range of models span residential and commercial property perils, motor insurance, travel, pet and health insurance. To feed our models we source diverse datasets covering high resolution weather data, property attributes, business activities and financial data, insurance data and geodemographic data.

Role Purpose

We are looking for a motivated, independent and well organised individual with experience of developing ETL processes using Python, SQL and AWS.

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.

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 for the Analytics team as a repository for all our datasets.
• 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.
• Automation of data processes
• Extraction of data for prospective customers to test models

Qualifications

Skills & Experience

• ESSENTIAL: 3-5 years’ experience in a data management role including experience of developing ETL pipelines using Python/SQL/AWS
• 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
• University degree in information technology or similar

Additional Information

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.