Consultant, Business Insights (DDS Claims Reporting)

Consultant, Business Insights

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 role serves as the primary liaison between DDS and assigned Claims business partners, building deep relationships to understand evolving business priorities and align reporting and analytics efforts to strategic objectives. The position manages a portfolio of reporting and dashboard requests, helping ensure solutions support self-service capabilities, reporting standardization, and consistent use of trusted data.

Responsibilities include:

• Partnering with Claims leaders, Data Product Owners, Data Engineers, the Data Visualization Center of Excellence, and Data Governance teams to translate operational priorities into practical data and reporting solutions.
• Facilitating requirements discussions, supporting solution design and validation, coordinating user acceptance testing and stakeholder handoffs, and ensuring business partners remain informed throughout the delivery lifecycle.
• The role primarily supports the Claims organization and leverages CLESS data to deliver reporting, dashboards, and business insights that support operational and strategic decision-making.
• Experience with Claims data and business processes is preferred, with exposure to Property and/or Casualty Claims environments viewed favorably. Success in this role requires a curious mindset, strong consultation, communication, and organizational skills, along with the ability to balance stakeholder needs while delivering meaningful business outcomes.
• Experience with Databricks, Snowflake, Power BI and/or Tableau is preferred, along with familiarity with AI-enabled tools that improve efficiency, accelerate analysis, and enhance delivery effectiveness.

Ideal candidates will be based in Columbus, Des Moines, or Scottsdale, with remote work available within those regions.

Job Description Summary

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 Consultant, Business Insights, you'll 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. Your focus will be to maximize insight gained from internal and external data to ensure that business partners are making decisions in an optimally informed way.

Key Responsibilities:

• 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. Also, 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.

Reporting Relationships: Reports to Director/Associate Vice President and does not have direct reports.

Typical Skills and Experiences:

Education: Undergraduate studies in data or business analytics, computer science, management information, business, mathematics or related field with post-graduate studies preferred

Experience: 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.

Knowledge, Abilities and Skills:

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. Staffing exceptions to the above must be approved by the hiring manager's leader and HR Business Partner.

Values:

Regularly and consistently demonstrates Nationwide Values.

Job Conditions:

Overtime Eligibility: Not Eligible (Exempt)

Working Conditions: Normal office environment. Occasional travel, nonstandard or extended work may be required based on project needs.

Benefits

We have an array of benefits to fit your needs, including: 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, and more.

Nationwide is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive culture where everyone feels challenged, appreciated, respected and engaged. Nationwide prohibits discrimination and harassment and affords equal employment opportunities to employees and applicants without regard to any characteristic (or classification) protected by applicable law.

Smoke-Free Iowa Statement: Nationwide Mutual Insurance Company, its affiliates and subsidiaries comply with the Iowa Smokefree Air Act. Smoking is prohibited in all enclosed areas on or around company premises as well as company issued vehicles. The company offers designated smoking areas in which smoking is permitted at each individual location. The Act prohibits retaliation for reporting complaints or violations. For more information on the Iowa Smokefree Air Act, individuals may contact the Smokefree Air Act Helpline at 888-944-2247.