Consultant, Product Architect (P&C Data)

Nationwide•Columbus, OH

4d•$118,000 - $222,000•Hybrid

About The Position

This role will work a hybrid schedule coming into the Columbus, Ohio, Des Moines, Iowa, or Scottsdale, Arizona office 2 days per week. Remote internal associates may also be considered. Product Architect – Personal Lines Data (Databricks Focus) About the Role We are seeking a Product Architect to join the Personal Lines Architecture team, with a focused mandate on data architecture and data platforms supporting Nationwide’s Personal Lines portfolio. In this role, you will define and evolve the data ecosystem that powers our auto, property, powersports, and umbrella products—from pricing and underwriting through sales, servicing, and advanced analytics. You will be responsible for the technical integrity, performance, and strategic direction of our shared data assets, with a strong emphasis on modern data lakehouse architectures leveraging Databricks. This is a high-impact role operating at the intersection of business strategy and technology execution, partnering across Personal Lines, P&C Data Platforms, and Enterprise Data & Analytics to ensure data is trusted, governed, and broadly consumable.

Requirements

Strong product and data architecture experience, including: Data modeling (analytical vs. operational), Integration patterns and pipelines, Data lineage and governance
Hands-on experience with Databricks, Snowflake, and modern data lakehouse/OLAP architectures
Proficiency with Python and SQL
Experience with AWS/Cloud based services, data integration, data security and data privacy
Experience with integration tools such as Informatica PowerCenter
Familiarity with APIs and services (Apigee, Spring Boot)
Knowledge of event streaming technologies (e.g., Kafka)
Exposure to AI and developer productivity tools (e.g., GitHub Copilot, Glean, Claude, Cortex)
Familiarity with data and analytics tools such as Alation, Anomalo, Manta, Dataiku, Power BI, Tableau
Excellent communication skills with the ability to simplify complex architectures
Demonstrated success delivering in fast-paced, agile environments
Ability to influence stakeholders, drive alignment, and lead through change
Experience developing roadmaps and balancing short-term delivery with long-term strategy
Undergraduate studies in computer science, management information systems, or a related field is preferred.
Eight to ten years of experience in a Technology domain.
Shown skill in multiple architectural domains and various technologies.
Awareness of emerging technologies.
Experience with cloud technologies is preferred.
Good communication and facilitation skills.
Ability to make decisions and recommendations on technology strategies while considering various options and business needs.
Aptitude to influence, build relationships, negotiate and set priorities needed.
Strong executive presence.

Nice To Haves

Experience with Property & Casualty insurance, particularly Personal Lines
Exposure to Guidewire (PolicyCenter, PricingCenter) or similar policy administration and rating platforms

Responsibilities

Own Personal Lines Data Architecture: Define and evolve data architecture, source-of-truth definitions, and data flows across modern data lakehouse platforms and legacy environments
Establish scalable data pipelines, integration patterns, and consumption models for reporting, analytics, and operational use cases
Ensure high standards for data quality, performance, security, and governance
Lead Personal Lines Data Platform Strategy & Evolution: Develop and drive strategic data roadmaps, including: Expansion of data lakehouse (Databricks-based) capabilities, Rationalization and retirement of legacy data platforms
Identify and mitigate technology risks, ensuring long-term sustainability and scalability
Drive Cross-Functional Alignment: Partner with Actuarial, Pricing, Underwriting, Product, and Analytics teams to align data capabilities with business outcomes
Enable seamless cross-domain integration with Enterprise Data & Analytics and shared services
Translate complex technical concepts into clear, actionable insights for business and technology leaders
Champion Modern Data Practices: Lead adoption of cloud data platforms, event streaming, and real-time data patterns
Promote best practices in data governance, lineage, security, and observability
Influence continuous improvement through thought leadership and innovation
Develop and maintain systems architecture for a product domain, business function or the technology portfolio.
Ensuring that the product meets functional and non-functional requirements.
Key contributor on strategies, blueprints and roadmaps for a given product/application/technology area focused on technical directions like Cloud First.
Ensure product/application roadmaps are aligned with solution and enterprise roadmaps with the correct guard rails.
Responsible for applying secure software and systems engineering practices throughout the delivery lifecycle to ensure our data and technology solutions are protected from threats and vulnerabilities.
Identifies technology risk, technical currency and technical debt related to applications when planning for new solutions, technology upgrades and maintenance of product/application platforms.
Crafts moderate to sophisticated build patterns, accelerators, building codes standard and carrying out compliance with architecture standards.
Drives technical quality by conducting or participating in architecture, design and code reviews, capacity planning, modeling and testing.
Runs the vitality of technical talent in area of responsibility and provides feedback, suggestions to other people leaders on technical talent.
Assists in mentoring lines involved in a product/application development when unfamiliar, new technologies or techniques are introduced.
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