Junior / Mid Data Analyst with Excel and SQL

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 support a host of products the US P&C industry relies on.

Purpose of the role:

• Analyze data from US P&C Insurance carriers to identify trends, anomalies, data quality issues, and market dynamics
• Synthesize and summarize key insights from your data analysis into actionable information for internal and external stakeholders
• Develop a robust understanding of the US P&C Insurance markets, policy programs, and pricing models
• Acquire technological skills as your responsibilities expand and new projects are assigned to you
• Assist in the design and development of new data analysis tools to expand the capabilities of your team
• Pursue professional development activities related to: Data Analysis/Science/Governance and P&C Insurance.

• Perform regular data audits to ensure accuracy, completeness, and consistency of insurance data
• Identify and resolve data quality issues, such as missing values, anomalies, inappropriate code patterns etc. 
• Use SQL to write and execute basic queries in Snowflake to retrieve and analyze data 
• Ensure data integrity by implementing data quality standards and best practices 
• Collaborate with data engineers and business analysts and other stakeholders to improve data quality processes
• Generate reports on data quality metrics and present findings to stakeholders/clients 
• Document data quality issues and the steps taken to resolve them
• Utilize Excel for data analysis, reporting, and visualization tasks
• Work with cross-functional teams to understand data requirements and address data quality concerns.

• Fluency in English is required (at least B2 spoken and written)
• Bachelor's degree with a major in Economics, Mathematics, Statistics, or related discipline
• Analytical thinking and attention to details
• Knowledge of Excel (pivot tables, formulas, conditional formatting)
• Familiarity with SQL (we are open for basic level users but as well as for intermediate proficiency)
• Familiarity with any of BI tools such as PowerBI, Tableau, Sigma would be a strong asset 
• Attention to detail to follow elaborate instructions and to spot even little differences in data
• Good presentation and public speaking skills with focus on internal stakeholders
• Willing to work in a hybrid model as a full-time employee in Krakow city-center based office
• Ability to manage competing, high-priority demands and prioritize workloads while managing projects and multiple responsibilities against strict deadlines
• Strong interpersonal/collaboration skills.  

#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