Specialist, Data Engineer Test Lead - ETL, Python, Perl

Specialist, Test Lead – NF Actuarial Datamart

If you’re passionate about being part of a dynamic organization that enables a Fortune 100 company with nearly $70 billion in annual sales to drive innovation and adopt new technologies that deliver business results, then Nationwide’s Technology team could be the place for you! At Nationwide®, “on your side” goes beyond just words. Our customers are at the center of everything we do and we’re looking for associates who are passionate about delivering extraordinary care.

The F Band Specialist, Test Lead for the NF Actuarial Datamart is responsible for leading test planning, test execution, and data validation activities that support delivery of high-quality data and application solutions. This role partners closely with developers, analysts, and business partners to define effective testing scenarios, analyze data issues, manage defects, and respond to walk-up support requests.

This position is a strong fit for someone with a solid testing background who also has an interest in development and automation. The ideal candidate brings hands‑on experience in data‑focused testing, enjoys problem solving, and is comfortable working across both quality assurance and technical solution delivery.

It is our intention to fill this role in Columbus, Ohio on a hybrid basis. The team comes in for collaboration on Mondays and Tuesdays. However, on occasion, applications from internal candidates working remotely who bring critical industry skills and relevant experience may be considered.

• ETL:
  Informatica, Python
• Scripts:
  Perl, Python
• Databases:
  Oracle, SQL Server, Snowflake
• Test Automation:
  Ruby, Python

• Lead testing efforts for NF Actuarial Datamart initiatives, including test planning, scenario development, execution, and validation
• Assist developers in identifying and refining testing scenarios for new development, enhancements, and defect fixes
• Perform detailed data validation to confirm expected results across source, transformation, and target layers
• Write and execute SQL queries to investigate data conditions, validate results, and support root cause analysis
• Analyze data issues and partner with development teams to determine cause, impact, and resolution approach
• Manage defects through the full lifecycle, including documentation, prioritization, retesting, and closure support
• Handle walk‑up requests and provide timely support for testing questions, data concerns, and issue triage
• Support and enhance test automation efforts, including Ruby‑based automation where applicable
• Work with Informatica‑based processes and data movement workflows as part of validation and issue analysis
• Contribute to continuous improvement of testing practices, automation coverage, and overall quality processes
• Collaborate across teams to ensure quality standards are met and releases are production ready

• 5+ years of experience in testing or quality assurance, with 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
• Strong experience with data validation and analysis of upstream and downstream data issues
• 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
• Ability to work directly with developers to clarify requirements, define test scenarios, and improve solution quality
• Strong analytical, organizational, and communication skills

• Experience supporting enterprise data platforms or actuarial data environments
• Experience in ETL, data warehouse, or datamart testing
• Familiarity with release validation, regression testing, and automation‑first quality practices
• Interest in growing from a testing‑focused role into broader technical or development responsibilities

The strongest candidate will have a testing mindset, strong technical curiosity, and a desire to grow…