Consultant, Product Architect

Nationwide

Confirmed live today High trust
Hybrid

Quick summary

Work type
Hybrid
Location
Columbus, OH
Salary
$118,000–$222,000 / yr
Employment
Full-time
Posted
1 day ago
Freshness
Confirmed live today

Market check

Salary context

Below market

How this pay compares to similar roles

Similar $216k
This role $170k
$102k $271k
below market most similar roles pay here above market

This role pays less than 79% of similar roles. Most pay $176,950–$254,750 — the blue band above. At the midpoint, this role pays about $170k versus about $216k for comparable roles.

Based on 240 similar postings.

Employer

About Nationwide

Nationwide is a Fortune 100 insurance and financial services company offering auto, home, life, and commercial insurance along with retirement savings, asset management, and banking products. Industry: Insurance & Financial Services

Nationwide currently has 62 open roles on FindRole.

Listed pay typically runs $118,000–$222,000 across 22 roles with salary data.

Most-posted roles

View all roles at Nationwide

At a glance

TL;DR · Consultant, Product Architect

The Consultant, Product Architect joins the Technology team to design and architect end-to-end enterprise data integration and data-warehousing solutions. This role involves translating business requirements into current-state and target-state architectures while developing ETL patterns for enterprise analytics. Key responsibilities include leveraging data-modelling to design logical, physical, and dimensional data models using star and snowflake schemas. The architect will design and support ETL pipelines, develop shell scripts for Unix and AWS cloud environments, and optimize performance through partitioning, pushdown optimization, and execution-plan analysis. Required technical skills include Informatica PowerExchange, Oracle PL/SQL, Teradata BTEQ scripts, and MPP environment management. The position focuses on extracting, transforming, and loading data across source, staging, warehouse, and data mart environments to enable efficient aggregations and scalable reporting.

What you'll do

  • Design end-to-end enterprise data integration and data-warehousing solutions based on business requirements.
  • Create logical, physical, and dimensional data models using star and snowflake schemas.
  • Develop and support ETL pipelines using Informatica PowerExchange and Oracle PL/SQL.
  • Write shell scripts to manage Unix and AWS cloud environments for infrastructure efficiency.
  • Optimize ETL performance through partitioning, pushdown optimization, and SQL query tuning.
  • Manage Teradata BTEQ scripts in MPP environments to improve throughput and scalability.
  • Perform execution-plan analysis and indexing to enhance database performance.

What we're looking for

  • Master’s degree in Computer Science or Information Technology.
  • 3 years of experience performing the duties listed in the job description.
  • Experience designing end-to-end enterprise data integration and data-warehousing solutions.
  • Experience designing logical, physical, and dimensional data models using star and snowflake schemas.
  • Experience developing ETL and data integration pipelines using Informatica PowerExchange and Oracle PL/SQL.
  • Experience developing shell scripts to manage Unix and AWS-based cloud environments.
  • Experience optimizing ETL and database performance through partitioning, pushdown optimization, and execution-plan analysis.
  • Experience with Teradata BTEQ scripts in MPP environments.

More like this

Similar roles

Consultant, Product Architect

Nationwide

Columbus, OH 1 day ago $118,000–$222,000
AWS APIGEE Kafka Java/J2EE JavaScript COBOL DB2 CICS IMS SOAP REST JSON Agile Mainframe Data Flow Reference Architecture
5+ yrs exp Hybrid

Consultant, Product Architect

Nationwide

Columbus, OH 45 days ago
Snowflake Databricks AWS Azure Power BI Tableau Data Warehouse Agentic AI Knowledge Graphs Agile Data Governance Identity and Access Management Cloud Architecture Semantic Modeling
8+ yrs exp Hybrid

Consultant, Product Architect

Nationwide

Remote (Columbus, OH) +2 21 days ago
AWS Kubernetes Java Spring Boot Kafka Informatica Microsoft SQL Server Oracle Apigee REST SOAP Event-Driven Architecture Data Modeling FullStory Celebrus UXCam JDA CTM
8+ yrs exp Remote

Senior Product Architect

Nvidia

Santa Clara, CA 5 days ago $168,000–$258,750
SoC GPU ASIC PCB Design Schematic PCB Layout Signal Integrity DFx Silicon Design Micro-architecture Hardware Optimization Electronic Engineering
6+ yrs exp

Product Architect, AI

Okta Inc

Bellevue, WA +3 27 days ago $226,000–$311,000
Python Node.js TypeScript Go React OAuth 2.0 OpenID Connect MCP Workload Identity API Security Distributed Systems Cloud Security Zero Trust AAuth Model Context Protocol Agentic Commerce Token Exchange

Consultant, Product Manager

Cardinal Health

28 days ago $96,300–$137,600
AI Machine Learning NLP Predictive Modeling Agile Scrum B2B SaaS Data Science Product Discovery Rapid Prototyping User Experience Research RCM Data Reconciliation 837/835 Clinical-Financial Data Scenario Modeling
4+ yrs exp