Consultant, Data Engineer

Nationwide Mutual Insurance•Columbus, OH

4d•Hybrid

About The Position

The Data Engineer designs, implements, maintains, and supports ETL, data warehousing, and enterprise data-integration workflows across relational databases, file systems, and service interfaces. The role uses Ab Initio, SQL, PL/SQL, Unix shell scripting, and Teradata, Oracle, and DB2 platforms, including mappings, metadata-driven transformation logic, and ETL performance tuning for high-volume data flows. The position performs automated and manual testing of data warehousing pipelines, analytics workloads, and application systems. It supports the full SDLC, from requirements analysis and design through development, testing, deployment coordination, production support, and release coordination. The role also designs and optimizes data models and processing logic, automates and schedules workloads, and provides production support and root-cause analysis. The role requires a master's degree in Computer Science or Engineering and three years of experience performing the described duties. A bachelor's degree in Computer Science or Engineering and five years of relevant experience is also accepted. The position is hybrid and overtime-exempt.

Requirements

Master's degree in Computer Science or Engineering and three years of experience performing the described duties; alternatively, a bachelor's degree in Computer Science or Engineering and five years of experience performing those duties.
Experience with ETL, data warehousing, and enterprise data integration.
Experience using Ab Initio, SQL, PL/SQL, Unix shell scripting, and Teradata, Oracle, and DB2 platforms.
Experience with automated and manual testing of data warehousing pipelines, analytics workloads, and application systems.
Experience with Jira and HP Quality Center.
Experience designing and optimizing physical and logical data models and SQL- and PL/SQL-based processing logic.
Experience with Control-M and Autosys for scheduling and monitoring data-processing workloads.
Experience with C and XML; HTML and related technologies are also referenced.

Responsibilities

Design, implement, maintain, and support ETL, data warehousing, and enterprise data-integration workflows across relational databases, file systems, and service interfaces.
Create mappings and metadata-driven transformation logic, and tune ETL performance for high-volume data flows.
Perform automated and manual testing of data warehousing pipelines, analytics workloads, and application systems.
Develop test scripts, test plans, test cases, and traceability; support regression testing and migration-readiness checkpoints.
Contribute across the SDLC, including requirements analysis, design, development, testing, deployment coordination, issue tracking, defect management, sprint planning, release coordination, and post-implementation production support.
Design and optimize physical and logical data models and SQL- and PL/SQL-based processing logic for reporting, query performance, data consistency, dimensional modeling, schema design, and large-scale data processing.
Develop and execute Unix shell scripts for automation, job orchestration, file transfer, and environment management.
Engineer, schedule, and monitor enterprise data-processing workloads using Control-M and Autosys.
Provide production support, ETL performance tuning, root-cause analysis, and production moves.
Use C, XML, and related technologies, including HTML, for structured data handling, file-based interfaces, and ETL support across heterogeneous source and target systems.
Regularly and consistently demonstrate Nationwide Values.

Benefits

Medical, dental, and vision coverage
Life insurance
Short- and long-term disability coverage
Paid time off: newly hired associates receive a minimum of 18 days per full calendar year, prorated quarterly based on hire date
Nine paid holidays
Eight hours of Lifetime paid time off
Eight hours of Unity Day paid time off
401(k) with company match
Company-paid pension plan
Business casual attire