Specialist, Data Engineer Test Lead

Nationwide

Confirmed live yesterday High trust
Hybrid

Quick summary

Work type
Hybrid
Location
Columbus, OH
Salary
$95,500–$177,500 / yr
Posted
3 days ago
Freshness
Confirmed live yesterday

Market check

Salary context

Below market

How this pay compares to similar roles

Similar $176k
This role $136k
$81k most similar roles pay here $229k

This role pays less than 78% of similar roles. Most pay $141,725–$211,200 — the shaded band above. At the midpoint, this role pays about $136k versus about $176k 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 17 open roles on FindRole.

Listed pay typically runs $95,500–$177,500 across 17 roles with salary data.

Most-posted roles

View all roles at Nationwide

At a glance

TL;DR · Specialist, Data Engineer Test Lead

Specialist, Data Engineer Test Lead - ETL, Python, Perl serves as a critical lead within the NF Actuarial Datamart team, overseeing test planning, execution, and data validation to ensure high-quality data solutions. The role involves partnering with developers and analysts to define testing scenarios, manage defects through their full lifecycle, and provide walk-up support for data concerns. Day-to-day tasks include performing detailed data validation across source and target layers, writing SQL queries for root cause analysis, and enhancing test automation efforts. The position requires proficiency in Informatica, Python, Perl, Ruby, Oracle, SQL Server, and Snowflake. This role specifically addresses the complexities of actuarial data environments and ETL processes, focusing on ensuring that large-scale data movements are accurate, reliable, and production-ready while supporting the transition from testing-focused tasks toward broader technical development responsibilities.

What you'll do

  • Lead test planning, scenario development, and execution for NF Actuarial Datamart initiatives.
  • Perform detailed data validation across source, transformation, and target layers to ensure accuracy.
  • Write and execute SQL queries to investigate data conditions and perform root cause analysis.
  • Manage the full defect lifecycle including documentation, prioritization, retesting, and resolution.
  • Support and enhance test automation efforts using Ruby and other scripting languages.
  • Analyze data issues in collaboration with developers to determine impact and resolution paths.
  • Provide walk-up support for testing questions, data concerns, and issue triage.
  • Monitor production data quality to ensure accuracy for key stakeholders and business processes.

What we're looking for

  • 5+ years of experience in testing or quality assurance with an emphasis on data validation and system/integration testing.
  • Experience with Ruby automation or automated testing frameworks.
  • Experience working with Informatica processes in an ETL or data integration environment.
  • Ability to write SQL queries for testing, troubleshooting, and validation purposes.
  • Exposure to Python and interest in expanding development-oriented technical skills.
  • Experience managing defects and supporting issue triage through resolution.
  • Undergraduate studies in computer science, management information systems, business, statistics, math, or a related field (preferred).
  • Work authorization.

More like this

Similar roles

Consultant Data Engineer

Nationwide

Columbus, OH 21 days ago $118,000$222,000
Databricks Delta Lake Python SQL Spark AWS Azure Redshift S3 EC2 CI/CD Git JIRA Jenkins Confluence R UNIX Shell Perl Ruby Robotic Process Automation
5+ yrs exp Hybrid

Senior Data Engineer

Abbott

Madison, WI 41 days ago $78,000$156,000
Snowflake Databricks Spark Python Scala SQL ETL NoSQL Parquet Avro Delta Lake AWS SQS S3 GitLab JIRA Confluence RestAPI Tableau Model Context Protocol Braze
4+ yrs exp

Data Engineer

PNC

Miamisburg, OH +4 42 days ago
MySQL Oracle SQL Oracle Exadata Oracle Data Guard Oracle Golden Gate OLTP Data Architecture Query Tuning Partitioning Indexing High Availability Disaster Recovery Automation Big Data Management Business Intelligence Machine Learning
3+ yrs exp

Lead Data Engineer

Capital One Financial

Richmond, VA 3 days ago $179,400$204,700
Python Spark PySpark AWS Redshift Snowflake Java Scala NoSQL ETL Kafka Hadoop Hive EMR DynamoDB Cassandra Agile
4+ yrs exp

Lead Software Engineer

JPMorgan Chase

Jersey City, NJ 86 days ago
Hybrid Cloud AWS Azure GCP Java Python React CI/CD DevOps Distributed Systems Data Pipelines Analytics Platforms AI-assisted Engineering
5+ yrs exp

Lead Software Engineer, Python & Data

JPMorgan Chase

Jersey City, NJ 71 days ago
Java Python Scala AWS Apache Spark Databricks AI-assisted engineering CI/CD Agile Big Data Cloud Native Data Visualization Business Intelligence System Design Automated Testing
5+ yrs exp