Consultant, Data Designer

Nationwide

Closes in 6 days Hybrid

Quick summary

Work type
Hybrid
Location
Columbus, OH
Salary
$118,000–$222,000 / yr
Posted
2 days ago
Closes
Jul 4, 2026 (soon)

Market check

Salary context

Competitive pay

How this pay compares to similar roles

Similar $166k
This role $170k
$106k most similar roles pay here $234k

This role pays more than 54% of similar roles. Most pay $127,703–$203,650 — the shaded band above. At the midpoint, this role pays about $170k versus about $166k 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 15 open roles on FindRole.

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

Most-posted roles

View all roles at Nationwide

At a glance

TL;DR · Consultant, Data Designer

As a Data Designer at Nationwide’s Enterprise Data Office in Columbus, Ohio, you will collaborate with business stakeholders and technical teams to design data structures, mappings, and visualizations that support decision-making processes. Your day-to-day responsibilities include analyzing complex data requirements, creating conceptual, logical, and physical data models, and ensuring referential integrity through data quality recommendations. You will work across multiple DBMS platforms like Oracle, SQL Server, Snowflake, and NoSQL, using tools such as Erwin or PowerDesigner to document source-to-target mappings and maintain data governance standards. Fluency in Python, SQL, and Unix is essential, along with experience in Agile methodologies and a background in the insurance or financial domain. This role requires strong collaboration skills and the ability to translate business needs into technical solutions that enhance data usability and readiness for consumption.

What you'll do

  • Evaluates data from multiple sources to provide recommendations and clean it into a consumable format.
  • Designs conceptual, logical, and physical data models for business consumption across various DBMS platforms.
  • Documents source-to-target mappings and ensures alignment with data quality and transformation rules.
  • Uses complex visualization techniques to present findings of data exploration exercises supporting business needs.
  • Proactively consults on data needs and executes changes in methodologies, practices, and tools for analytics.

What we're looking for

  • Demonstrated skill in collaborating with stakeholders to elicit data requirements and design models.
  • Proficiency in translating business needs into conceptual, logical, and physical data model designs using standard tools.
  • Experience in ensuring referential integrity and adhering to data governance practices during model creation.
  • Ability to design data models for various patterns on multiple DBMS platforms and optimize database performance.
  • Strong communication skills with proven experience working in an Agile environment.

More like this

Similar roles

Data Specialist

Caterpillar

Peoria, IL 4 days ago $97,530$146,290
Python R BI Data Visualization Machine Learning AI ETL Cloud Computing Database Design Agile Development GitHub Copilot Kubernetes Docker Prometheus Grafana

Data Solutions Engineer

Citi

Remote (Irving, Texas) 20 days ago $107,120$160,680
Python PySpark Scala AWS Google Cloud Docker Kubernetes Hadoop HDFS MapReduce Hive Pig Impala Kafka Kudu Solr SAS Agile CI/CD
Remote

Data Engineering Specialist

Leidos

68 days ago $87,100$157,450
Python Java SQL Kafka Elasticsearch Kibana Git JIRA Confluence CI/CD Docker Kubernetes AWS Ansible Selenium JUnit ELK_stack Power_BI Tableau DevOps Agile
Hybrid

Data Solutions Data Engineer

HP Inc.

Spring, TX 24 days ago $130,700$205,200
AWS Azure Apache Spark Apache Hadoop Apache Kafka SQL Python Scala Java ETL Data Warehousing Agile Methodology CI/CD Big Data Machine Learning Docker Kubernetes Terraform

Data Engineer

Q2

Cary, North Carolina +1 13 days ago
Python SQL Snowflake Apache Airflow dbt Kafka Terraform Kubernetes Docker Git CI/CD PostgreSQL AWS Glue Pyspark Databricks SageMaker
Hybrid

Data Engineer

Booz Allen Hamilton

Arlington, VA +1 24 days ago $62,000$141,000
Python AWS EMR Redshift SageMaker Databricks SQL Data Warehouse Apache Spark NVIDIA CUDA Terraform CloudFormation Git Atlassian Linux Windows SQL GraphQL CI/CD Prometheus Grafana