Data Engineering Consultant — ETL & Warehousing

Nationwide Mutual Insurance Company; Columbus (OH); Hybrid; USD 118,000 - 222,000; Full time

Benefits offered by this job

Medical/dental/vision

Life insurance

Disability coverage

Paid time off

9 holidays

401(k) with company match

Pension plan

Business casual attire

Job summary

Nationwide Mutual Insurance Company is seeking a Data Engineer to design, implement, maintain, and support ETL, data warehousing, and enterprise data‑integration workflows across multiple database platforms and file systems. The role requires expertise with Ab Initio, SQL, PL/SQL, Unix shell scripting, and scheduling tools such as Control-M and Autosys, plus data modeling and testing across the full SDLC.

Master’s or Bachelor’s degree with relevant experience is required, with hybrid working

Qualifications

• Design, implement, maintain, and support ETL, data warehousing, and enterprise data-integration workflows.
• Perform automated and manual testing of data pipelines and analytics workloads.
• Design and optimize physical and logical data models and SQL/PL/SQL processing logic.
• Develop and execute Unix shell scripts for automation and job orchestration.
• Engineer, schedule, monitor, and produce production data processing moves.
• Utilize data and integration tools across heterogeneous source/target systems.

Responsibilities

• Design and implement ETL processes across relational databases and file systems.
• Test pipelines and analytics workloads through Jira and HP Quality Center.
• Develop and optimize data models and SQL/PL\-SQL logic for reporting and performance.
• Create and maintain Unix shell scripts for automation and scheduling with Control-M/Autosys.
• Provide production support, root-cause analysis, and release coordination across SDLC.

Skills

ETL design

Data warehousing

SQL/PL/SQL

Unix shell scripting

Education

Master’s degree in Computer Science or Engineering

Bachelor’s degree in Computer Science or Engineering with 5 years of experience

Tools

Ab Initio

Jira

HP Quality Center

Control-M

Autosys

Teradata

Oracle

DB2

C

XML

HTML

Job description

Nationwide Mutual Insurance Company is seeking a Data Engineer to design, implement, maintain, and support ETL, data warehousing, and enterprise data‑integration workflows across multiple database platforms and file systems. The role requires expertise with Ab Initio, SQL, PL/SQL, Unix shell scripting, and scheduling tools such as Control-M and Autosys, plus data modeling and testing across the full SDLC.

Master’s or Bachelor’s degree with relevant experience is required, with hybrid working