Consultant, Underwriting Data Insights, Advanced Analytics and Risk Selection

Nationwide•Columbus, OH

1d•Remote

About The Position

Nationwide's Property and Casualty team is seeking a Consultant, Underwriting Data Insights, Advanced Analytics and Risk Selection. This role is part of a high-impact data insights team driving underwriting and claims excellence across Nationwide’s Commercial, Excess, Surplus, and Specialty lines. The Advanced Analytics and Risk Selection Team delivers intelligent, actionable analytics, along with AI-driven insights and risk selection solutions that power competitive advantage. This is a hands-on technical expert role that thrives on working directly with data to build scalable, intelligent solutions. The role involves querying, synthesizing, and visualizing complex datasets to uncover actionable insights, supporting the design and delivery of advanced analytics, AI, and predictive solutions that drive strategic decision-making and competitive advantage for the CLESS business. The team values knowledge, analytical aptitude, and collaboration, and seeks individuals who thrive in a busy, engaging work environment. The Consultant, Business Insights will extract data to obtain knowledge and insights, manipulate internal and external data through R/SAS/SQL/Python, perform diagnostic and inferential analysis, investigate complex business concerns using data and statistical techniques, apply analysis or visualization techniques, build forecasts and/or projections of possible business futures and benefits, and communicate key findings to business partners. The focus is to maximize insight gained from internal and external data to ensure business partners make optimally informed decisions.

Requirements

Strong technical skills in Databricks, SQL, Python, R, or similar tools.
Proven experience in data wrangling, visualization, and insight generation.
Deep understanding of statistical distributions and methods such as hypothesis testing.
Experience in P&C insurance
Familiarity with predictive modeling techniques and statistical and predictive modeling packages
Experience with database querying, data modeling, and analytic engineering
Ability to work independently and dive deep into complex data problems.
Comfortable translating technical findings into business-relevant insights.
Passionate about building solutions that make a measurable impact.
Strong ability to communicate (written and verbally) complex messages in a business-friendly, consumable manner
Undergraduate studies in data or business analytics, computer science, management information, business, mathematics or related field with post-graduate studies preferred
Typically, eight or more years of experience in data extraction, data manipulation, analysis, and data visualization.
Experience with advanced statistical techniques such as business intelligence.
Detailed experience with data-extraction problem solving; working with large structured and unstructured data sets and databases to build understandable and relevant analyses.
Professional experience in insurance, financial services or a related industry preferred.
In-depth knowledge of business policies and procedures, customer service concepts and practices.
Sophisticated understanding of creating and maintaining ad hoc and standard analysis, including data visualization, predictive modeling and business intelligence tools.
Working knowledge to conduct extraction of data for functional and operational analysis and modeling.
Strong communication skills for interactions with others.
Ability to understand business processes and the data produced by them.
Ability to understand functional and operational measurement needs, analyze data requests and interpret and translate business problems into solutions.
Ability to work under tight time constraints.
Capable of developing distinctive and understandable data visualizations.
Other criteria, including leadership skills, competencies and experiences may take precedence.

Nice To Haves

Post-graduate studies preferred

Responsibilities

Perform hands-on data exploration, feature engineering, and model development.
Build scalable analytic and AI solutions aligned with underwriting and risk selection goals.
Translate raw data into clear, consumable insights and visualizations.
Collaborate across teams to assess business impact and deliver high-value solutions.
Applies substantive business expertise to render insights and forecast/project on extracted data sets to craft, package and communicate actional insights and recommendations to business partners.
Builds and maintains relationships and serves as a trusted business advisor to clients, internal risk partners and other stakeholders.
Cultivates partnerships across the company to ensure methodologies and assumptions align with corporate practices.
Participates in the development of scope, risk/control matrix, project timelines and assignments.
Responsible for effectively synthesizing own project work and the work of team members.
Work may span more than one project or focus area.
Leverages statistical inferencing when conducting analysis.
Communicates significance in findings when working with business partners.
Utilizes appropriate visualization techniques as needed.
Collaborates with leaders to develop strategies for the business unit.
Consults with business to understand, align, and deliver work that supports business objectives and priorities.
Determines appropriate information and data to be shared with customers.
Shares financial and operational analyses with appropriate area of the company as assigned.
Responsible for building business intelligence applications using R/Python/SQL/SAS/Tableau.
Manages special projects and serves as an analytic consultant and contact for team members and associates outside the department.
Serves as a consultant and subject matter expert for business areas during the intake and prioritization of data, reporting, analysis, and advanced analytics work.
Contributes to the continuous improvement of department processes through ongoing initiatives.
May be responsible for preparation of reports and use of information systems, software and related sources of information.
May be responsible for training other users on report preparation and data base access and supporting the research, analysis and presentation of information.
May perform other responsibilities as assigned.