OIPA Configuration Sr. Analyst

Summary

Nationwide is an insurance and financial services company seeking an OIPA Configuration Sr. Analyst to support its Finance and Actuarial teams. The role converts business and product requirements into OIPA system behavior, configures and tests rules and calculations, analyzes data and system behavior, and supports product launches, valuation, projection, and reporting workflows.

Responsibilities

• Configure rules, calculations, and system logic within OIPA (80–90% of the role)
• Build test tools and validate product calculations
• Analyze data and system behavior to identify improvements or defects
• Assist in projection/valuation processes and financial/actuarial reporting workflows
• Contribute ideas to improve performance, architecture, and operational processes
• Compiles, categorizes and analyzes data, with direction and oversight
• Assists in building testing tools, analyzing product calculations and product illustrations
• Aids in building, maintaining and running actuarial, projection and valuation models
• Completes financial reporting and analysis with direct oversite
• Responsible for pricing and implementation of products with input and oversite
• Assists in valuation/reserving under multiple accounting regimes (statutory, GAAP and tax) for products
• Assists with analysis of reinsurance opportunities and risks for Nationwide Financial business products
• Assists in activities related to a specialized phase of data and analytics which may include data governance, data strategy development, data modeling, data requirements, data manipulation, and/or requirements elicitation when needed
• Assists in the analysis and validation of moderately sophisticated business processes and in the development and implementation of new programs and/or modifications of existing applications when required. May assist in the design, prototyping, coding and other methodologies for new and/or existing applications including development of test plans
• May Perform Other Responsibilities As Assigned

Skills

• Degree in Computer Science, Math, Actuarial Science, or related field
• 3–4+ years in systems, ETL, data, or config‑heavy roles (insurance preferred but not required)
• Familiarity with XML, SQL, VBA/Excel, or similar tools
• Undergraduate degree in actuarial science, mathematics, statistics, CIS or similar background requiring modeling, programming or quantitative analysis
• Basic understanding of Microsoft Office products (including VBA within Access and Excel) programming languages, and likely actuarial models
• Basic level of perspective, customer focus, dealing with ambiguity, drive for results, business perspective and analysis
• Proficient level of problem solving, learning on the fly, and making the best use of system capabilities
• Actuarial exams welcome, but this role does not align with active exam study programs
• May have passed an actuarial exam, LOMA or other industry exams

Qualifications

Must Haves

• Degree in Computer Science, Math, Actuarial Science, or related field
• 3–4+ years in systems, ETL, data, or config‑heavy roles (insurance preferred but not required)
• Familiarity with XML, SQL, VBA/Excel, or similar tools
• Undergraduate degree in actuarial science, mathematics, statistics, CIS or similar background requiring modeling, programming or quantitative analysis
• Basic understanding of Microsoft Office products (including VBA within Access and Excel) programming languages, and likely actuarial models
• Basic level of perspective, customer focus, dealing with ambiguity, drive for results, business perspective and analysis
• Proficient level of problem solving, learning on the fly, and making the best use of system capabilities

Nice to Haves

• Actuarial exams welcome, but this role does not align with active exam study programs
• May have passed an actuarial exam, LOMA or other industry exams

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
• Open to remote for highly qualified candidates
• Supportive, collaborative culture; no burnout mentality
• Strong work-life balance
• Leader invests in role-based strengths and growth opportunities
• You will be trained in company and business operations
• Are encouraged to innovate and learn to master actuarial methodologies