Specialist, Business Insights (P&C Personal Lines Planning & Forecasting)

Nationwide•Columbus, OH

11h•$88,000 - $164,000•Remote

About The Position

If you’re passionate about helping people protect what matters most to them at a Fortune 100 company with nearly $70 billion in annual sales, as well as innovating and simplifying processes and operations to provide the best customer value, then Nationwide’s Property and Casualty team could be the place for you! At Nationwide®, “on your side” goes beyond just words. Our customers and partners are at the center of everything we do and we’re looking for associates who are passionate about delivering extraordinary care. This opening can be filled in a remote/work-from-home (WFH) capacity or in one of our offices. Ideally, work hours will align to Eastern or Central time zones. This Business Insights Specialist will join the Personal Lines Planning & Forecasting team, partnering with Finance, Pricing, State Management, and other stakeholders to develop tools that enable more precise forecasting and planning for the business. We focus on integrating richer data sources into planning processes and driving greater efficiency and accuracy in financial projections. We are a versatile group of individuals, working together to meet the needs of our customers. We value knowledge, analytical aptitude and collaboration. If you thrive in a busy, engaging work environment, we want to know more about you! As a Specialist, Business Insights, you'll extract and manipulate internal and external data through R/SAS/SQL/Python, perform diagnostic and inferential analysis, and communicate actionable insights to business partners. You’ll also work with business partners to determine data and information needs to aid the business with decision making and build statistical and visual solutions using sophisticated business intelligence tools. And you may serve as a lead to others for information and data needs. Your focus will be to maximize the insight gained from internal and external data, ensuring that business partners are making decisions in an optimally informed way.

Requirements

Strong data manipulation skills, especially using SQL
Business acumen and solid understanding of P&C insurance KPIs
Advanced proficiency in Excel – comfort with pivot tables and advanced formulas
Quantitative skills – ability to build projections / perform calculations using queried data, turning raw data into meaningful business tools
Communication & Consultation skills – ability to work with business partners, understand their needs, and identify opportunities
Undergraduate studies in data or business analytics, computer science, management information, business, mathematics or related field with post-graduate studies preferred
Six or more years of related experience with data extraction, data manipulation, data visualization analysis, and problem solving; working with large database.
Professional experience in insurance, financial services, or a related industry preferred.
In-depth knowledge of business policies and procedures, customer service concepts and practices.
In-depth understanding of and working knowledge to build data visualization and business intelligence tools.
Strong communication skills to interact with others.
Ability to understand business processes and the data produced by them.
Understanding of functional and operational measurement needs, analyze data requests and interpret business problems into solutions.
Ability to work under tight time constraints.
Capable of developing distinctive and understandable data visualizations.

Nice To Haves

Experience in financial planning and forecasting
Modeling
Python
Data visualization in Tableau or Power BI

Responsibilities

Functions as the specialist in data extraction from databases, tables, data warehouses and other sources through R/SAS/SQL/Python.
Develops, produces, and maintains inferential, statistical, ad hoc and custom analyses and modeling for functional business areas. May use various data access tools to pull information for reports and solutions.
Builds and maintains relationships and serves as a trusted financial and operational measurement resource to clients, internal risk partners and other stakeholders.
Creates and presents financial and operational results. Ensures that insights are action oriented. May develop new statistical and visual solutions for relevant insights.
Consults with business partners to understand, align and deliver work that supports business objectives and priorities. Leverages statistical inferencing when conducting analysis. Communicates significance in findings when working with business partners.
May build business intelligence applications using statistical, database and/or general programming languages and tools. May assist other associates with preparation of reports and use of information systems, software and related sources of information and may train other users on report preparation and data base access.
Serves as a single point of contact and consultant for business areas for the intake and prioritization of data, reporting, analysis, and advanced statistical work. Leads and serves as a main point of contact for projects.
Monitors, reviews and analyzes the external environment to support the research and analysis done with data extracted from internal sources. Presents and discusses these findings with customers.
May perform other responsibilities as assigned.

Benefits

medical/dental/vision
life insurance
short and long term disability coverage
paid time off with newly hired associates receiving a minimum of 18 days paid time off each full calendar year pro-rated quarterly based on hire date
nine paid holidays
8 hours of Lifetime paid time off
8 hours of Unity Day paid time off
401(k) with company match
company-paid pension plan
business casual attire