Consultant, Data Engineer

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

Competitive pay

How this pay compares to similar roles

Similar $169k
This role $170k
$106k $234k
below market most similar roles pay here above market

This role pays more than 56% of similar roles. Most pay $126,800–$211,200 — the blue band above. At the midpoint, this role pays about $170k versus about $169k 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, Data Engineer

The Consultant, Data Engineer joins the Technology team to design, implement, and maintain enterprise data-integration workflows and ETL processes. This role involves managing high-volume data flows across relational databases, file systems, and service interfaces. Key responsibilities include developing metadata-driven transformation logic, performing ETL performance tuning, and designing physical and logical data models to support reporting and dimensional modeling. The candidate will perform automated and manual testing of data warehousing pipelines and application systems throughout the full SDLC. Required technical skills include Ab Initio, SQL, PL/SQL, Unix shell scripting, Teradata, Oracle, DB2, Control-M, Autosys, C, XML, and HTML. The position focuses on solving complex data consistency and large-scale processing problems across heterogeneous source and target systems to support analytics workloads and production support.

What you'll do

  • Design, implement, and maintain ETL, data warehousing, and enterprise data-integration workflows.
  • Develop metadata-driven transformation logic and perform ETL performance tuning for high-volume data flows.
  • Perform automated and manual testing of data warehousing pipelines and analytics workloads using Jira and HP Quality Center.
  • Design and optimize physical and logical data models, including dimensional modeling and schema design.
  • Develop and execute Unix shell scripts for automation, job orchestration, and environment management.
  • Schedule and monitor enterprise data-processing workloads using Control-M and Autosys.
  • Provide post-implementation production support, including root-cause analysis and production moves.
  • Utilize C, XML, and HTML for structured data handling and file-based interfaces across heterogeneous systems.

What we're looking for

  • Master’s degree in Computer Science or Engineering and 3 years of experience performing the listed duties.
  • Bachelor’s degree in Computer Science or Engineering and 5 years of experience performing the listed duties.
  • Experience designing and supporting ETL, data warehousing, and enterprise data-integration workflows.
  • Proficiency in Ab Initio, SQL, PL/SQL, Unix shell scripting, Teradata, Oracle, and DB2 platforms.
  • Experience with mappings, metadata-driven transformation logic, and ETL performance tuning for high-volume data flows.
  • Experience performing automated and manual testing using Jira and HP Quality Center across the full SDLC.
  • Experience designing and optimizing physical and logical data models, including dimensional modeling and schema design.
  • Experience with Control-M and Autosys for job orchestration, scheduling, and monitoring enterprise workloads.

More like this

Similar roles

Data Engineer

Intapp

Charlotte, NC 12 days ago
ETL SQL Excel APIs Data Mapping Data Integration DealCloud CRM QA Agile SaaS Data Migration
3+ yrs exp Hybrid

Consultant, Product Architect

Nationwide

Columbus, OH 1 day ago $118,000–$222,000
Informatica PowerExchange Oracle PL/SQL AWS Teradata SQL Unix ETL data-warehousing BTEQ Snowflake Schema Partitioning Pushdown Optimization
3+ yrs exp Hybrid

Data Engineer

Booz Allen Hamilton

Fort Meade, MD 65 days ago
Data Engineering ETL AWS Azure AI/ML Data Pipelines Data Governance Data Normalization Dashboards Metrics Exploratory Analysis Feature Development IoT Machine Learning
4+ yrs exp

Data Engineer

Brex

San Francisco, CA 21 days ago $120,800–$151,000
SQL Python Snowflake Airflow dbt ETL ELT Data Modeling Data Warehousing Looker Tableau Agentic AI Salesforce
3+ yrs exp Hybrid

Data Engineer

Booz Allen Hamilton

O'Fallon, IL 91 days ago
Python SQL ETL ELT Spark Databricks Hadoop Hive Kafka AWS Microsoft Azure Google Cloud Snowflake AWS Redshift MongoDB Cassandra MySQL Scala C++ Java Linux UNIX Shell scripting Agile

Data Engineer

Booz Allen Hamilton

Chantilly, VA 86 days ago
Python Scala SQL PostgreSQL Kafka AWS RDS Aurora NiFi Kubernetes Helm ArgoCD Grafana Prometheus Elasticsearch ETL Kafka Connect Kafka Streams