Consultant, Product Architect

Ohio - Columbus, Three Nationwide Plaza, USFull-time$118k–$222k2026-11-02 → 2026-11-11

Hybrid

Core

Design and architect end-to-end enterprise data integration and data-warehousing solutions, translating business requirements into current-state and target-state architectures.

Role type

Senior IC Product Architect (Data Engineering)

Builds

Enterprise data warehouses, ETL pipelines, and data integration solutions for Fortune 100 analytics.

Domain

Enterprise Data Warehousing & ETL

Required skills

Data modeling (star/snowflake schemas), ETL pipeline design, Informatica PowerExchange, Oracle PL/SQL, Unix shell scripting, AWS cloud infrastructure, Teradata BTEQ, SQL query optimization, Stored procedures, Indexing, Partitioning, Execution-plan analysis

Technologies

Informatica PowerExchange, Oracle, AWS, Teradata, Unix, SQL

Responsibilities

Design logical, physical, and dimensional data models; Develop and support ETL/data integration pipelines; Optimize ETL and database performance via tuning and indexing; Manage Unix environments and support AWS cloud infrastructure; Write Teradata BTEQ scripts for MPP environments.

Seniority

Senior, hands-on IC

About Nationwide

Nationwide is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive culture where everyone feels challenged, appreciated, respected and engaged. Nationwide prohibits discrimination and harassment and affords equal employment opportunities to employees and applicants without regard to any characteristic (or classification) protected by applicable law.