Consultant, Data Engineer
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 software development lifecycle, including requirements analysis, design, development, testing, deployment coordination, issue tracking, defect management, sprint planning, release coordination, and post-implementation production support. The Data Engineer designs and optimizes 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. The role also develops Unix shell scripts for automation, job orchestration, file transfer, and environment management, and engineers, schedules, and monitors enterprise data-processing workloads using Control-M and Autosys. Additional duties include production support, root-cause analysis, production moves, and use of C, XML, and related technologies including HTML for structured data handling, file-based interfaces, and ETL support across heterogeneous systems. The position requires either a master's degree in Computer Science or Engineering and three years of experience performing the listed duties, or a bachelor's degree in Computer Science or Engineering and five years of such experience. The role is hybrid in a normal office environment and is exempt from overtime eligibility.
Requirements
- Master’s degree in Computer Science or Engineering and three years of experience performing the listed duties; alternatively, a bachelor’s degree in Computer Science or Engineering and five years of experience performing the listed duties.
- Experience with ETL, data warehousing, and enterprise data-integration workflows.
- Experience with Ab Initio, SQL, PL/SQL, Unix shell scripting, and Teradata, Oracle, and DB2 platforms.
- Experience with data warehousing pipeline and application testing, including Jira and HP Quality Center.
- Experience with physical and logical data modeling, dimensional modeling, schema design, and SQL/PL-SQL processing logic.
- Experience with Control-M and Autosys for enterprise data-processing workloads.
- Experience with C, XML, and related technologies including HTML.
- Ability to support production systems, perform ETL performance tuning and root-cause analysis, and coordinate production moves.
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, and test cases; maintain traceability; support regression testing and migration-readiness checkpoints.
- Contribute across the full SDLC, including requirements analysis, design, development, testing, deployment coordination, issue tracking, defect management, sprint planning, and release coordination.
- Provide 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.
- Perform 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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
