Product Architect
Nationwide Mutual Insurance Company
Columbus, OHJobSeen todaySeen in employer's feed today
Most applications go out cold — see where you stand first. No sign-up to start.
Watch jobs like this. New roles like this one near Columbus, OH, by email.
Don't just apply. Show up ready.
Olive works from this exact posting.
At a glance
Olive lists jobs from US employers, including remote roles you can work from the United States.
Requirements
Credentials this posting asks for.
Job overview
The Product Architect designs end-to-end enterprise data integration and data-warehousing solutions, translating business requirements into current- and target-state architectures and ETL patterns for enterprise analytics. The role develops and supports data pipelines, models, and database environments, and optimizes performance across Informatica, Oracle, Teradata, Unix, and AWS-based cloud environments.
Skills & qualifications
Skills
Qualifications
Full job description
Product Architect needed to design and architect end-to-end enterprise data integration and data-warehousing solutions by translating business requirements into current-state and target-state architectures, ETL patterns for enterprise analytics. Leverage data-modelling to design, review, and refine logical, physical, and dimensional data models for the Datawarehouse, using star and snowflake schemas to enable efficient aggregations, consistent business hierarchies, and scalable reporting. Design, develop, and support ETL and data integration pipelines using Informatica PowerExchange, and Oracle PL/SQL to extract, transform, validate, and load data across source, staging, warehouse, and data mart environments. Develop shell scripts to manage Unix environments, now those skills enable to support AWS based cloud environments to improve infrastructure creation and efficiency. Optimize ETL and database performance by tuning Informatica mappings through partitioning and pushdown optimization, SQL queries and stored procedures through execution-plan analysis, indexing, and partitioning, Teradata BTEQ scripts in MPP (massively parallel processing) environments through statistics collection, spool-space optimization, and workload distribution to improve throughput, scalability, and resource utilization. Master's degree in Computer Science or Information Technology and 3 years of experience performing the duties listed above.
How this job compares
Set against the 1,516 open Data Architect jobs on Olive Jobs, counted October 30, 2026.
- Pay
- This postingNot listed
- Ohio median$123–235K/yr44 salary ranges
- US median$70–86/hr22 hourly ranges
- Openings
- Olive Jobs lists 75 open Data Architect jobs in Ohio and 1,516 across the US. 14% of them nationwide are listed as remote or flexible.
- Experience
- This posting asks for at least 3 years of experience — less than three in four Data Architect postings that state a minimum ask for (median 8 years, across 1,368 postings).
- Education
- This posting asks for a master's degree; 7 of the 1,516 open Data Architect jobs (under 1%) ask for a master's degree or higher.
Counted across the open, public US postings on Olive Jobs on October 30, 2026. Pay medians are the middle values of the low ends and of the high ends of postings that list both ends of a range in the same cadence (a yearly salary or an hourly rate); a range's midpoint is halfway between its ends. Pay and experience figures resting on fewer than 20 postings are left out.
You've read the whole posting — now see how you match it.
