Consultant, Product Architect (P&C Data)

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 .

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

Requirements

• Core Architecture & Data Expertise
• 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
• Integration & Engineering Skills
• Experience with integration tools such as Informatica PowerCenter
• Familiarity with APIs and services ( Apigee, Spring Boot )
• Knowledge of event streaming technologies (e.g., Kafka)
• Modern Data & AI Ecosystem Awareness
• 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
• Domain & Industry Experience (Preferred)
• Experience with Property & Casualty insurance , particularly Personal Lines
• Exposure to Guidewire (PolicyCenter, PricingCenter) or similar policy administration and rating platforms
• Leadership & Execution
• 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
• What Makes This Role Unique
• High Impact: Personal Lines is the largest and most data-rich portfolio in P&C-your work will directly influence pricing, underwriting, and customer experience for millions of policies
• Transformation in Motion: A major pricing modernization (PricingCenter) and data foundation redesign are underway, creating a rare opportunity to shape the future state
• Strategic Visibility: You'll contribute to critical initiatives aligned with growth and experience priorities, including Monarch Sales, Monarch Analytics, and Protector programs
• Innovation

Benefits

Additional Information

If you're passionate about being part of a dynamic organization that enables a Fortune 100 company with nearly $70 billion in annual sales to drive innovation and adopt new technologies that deliver business results, then Nationwide's Technology team could be the place for you! At Nationwide®, "on your side" goes beyond just words. Our customers are at the center of everything we do and we're looking for associates who are passionate about delivering extraordinary care. 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)

Your Match

How well this role fits your profile.

Company Intel

What employees say

Worked at Nationwide? Share your experience