Consultant, Product Architect
Nationwide
Quick summary
Market check
How this pay compares to similar roles
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
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
At a glance
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.
Skills
What you'll do
What we're looking for
More like this
Nationwide
Nationwide
Nationwide
Nvidia
Okta Inc
Cardinal Health