Data Engineer (Snowflake)

Purpose of the team
 

The Analytical Data Operations (ADO) division of Verisk’s ISO business is the information refinery for our insurance-industry-experience data stores, ensuring that the country’s largest database of P&C policy and claims information can effectively support the analytical engines underlying the pricing of the US P&C insurance market. 

We are a hybrid team of data analysts, data engineers, BI developers, and actuarial-engineers that are responsible for the design and implementation of our core data-systems including data ingestion, data integration, data transformation, data analysis, and BI development. 

We are committed to improving the data & analytics platform that supports a host of products the US P&C industry relies on.   

About The Role

We are seeking a skilled and proactive Data Engineer to join our growing team in Krakow. In this role, you will be instrumental in designing, building, and maintaining the data infrastructure that powers our business intelligence and analytics. You will work within a fast-paced, Agile environment, transforming raw data into a reliable and accessible format, and ensuring our data architecture is robust, scalable, and cost-efficient.

• Design, develop, and implement scalable data pipelines using Python and SQL to ingest, transform, and load data from various sources 
• Create and maintain relational data models and data warehouse schemas 
• Optimize complex SQL queries and data structures to ensure high performance and efficiency 
• Work with cloud data platforms, specifically Snowflake, to develop stored procedures, tasks, and dynamic tables 
• Apply the principles of Medallion Architecture (Bronze, Silver, Gold) to build a structured and reliable data ecosystem 
• Proactively identify and resolve data quality issues, including creating test cases, defining DQ checks, and generating reports on outliers, nulls, duplicates, and schema drift 
• Adhere to and enforce data governance best practices, including naming conventions and join principles 
• Collaborate with cross-functional teams in an Agile environment to deliver data solutions that meet business needs.
• 3-5+ years of experience as a Data Engineer (with at least 1 year of experience in Snowflake) 
• Familiarity with data warehousing concepts, dimensional modeling, and best practices 
• Demonstrated proficiency in Python, including experience writing and manipulating data frames 
• Strong expertise in SQL and an ability to solve technical problems quickly 
• Solid understanding of cloud data architecture and best practices for cloud databases 
• Experience writing stored procedures, tasks, and dynamic tables 
• Experience with advanced SQL such as CTEs, cursors and Window Functions| 
• Familiarity with query cost management and optimization within the Snowflake ecosystem 
• Strong analytical, problem solving, and decision-making skills 
• A strong team-oriented mindset with experience working collaboratively 
• Good English communication skills (written and verbal)

Nice-To-Have:

• Background in the insurance industry (a strong asset) 
• Current SnowPro Core Certification 
• Experience with data transformation tools such as dbt (dbt Core or dbt Cloud) 
• Experience using Jupyter Notebooks for data analysis and prototyping

#Li-Pm1

#Li-Hybrid

For over 50 years, Verisk has been the leading data analytics and technology partner to the global insurance industry by delivering value to our clients through expertise and scale. We empower communities and businesses to make better decisions on risk, faster.

At Verisk, you'll have the chance to use your voice and build a rewarding career that's as unique as you are, with work flexibility and the support, coaching, and training you need to succeed. 

For the eighth consecutive year, Verisk is proudly recognized as a Great Place to Work® for outstanding workplace culture in the US, fourth consecutive year in the UK, Spain, and India, and second consecutive year in Poland.  We value learning, caring and results and make inclusivity and diversity a top priority.  In addition to our Great Place to Work® Certification, we’ve been recognized by The Wall Street Journal as one of the Best-Managed Companies and by Forbes as a World’s Best Employer and Best Employer for Women, testaments to the value we place on workplace culture.

We’re 7,000 people strong.  We relentlessly and ethically pursue innovation. And we are looking for people like you to help us translate big data into big ideas. Join us and create an exceptional experience for yourself and a better tomorrow for future generations.

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. Verisk’s minimum hiring age is 18 except in countries with a higher age limit subject to applicable law.

https://www.verisk.com/company/careers/

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.

Verisk Employee Privacy Notice