Senior Data Engineer - ETL & Snowflake Pipelines (Remote)

LEVI, RAY & SHOUP, INC; Cincinnati (OH); Hybrid; USD 83,000 - 96,000; Full time

Job summary

Codeworks, an LRS company, is seeking a Senior DataStage ETL Developer to design and build enterprise ETL/ELT solutions powering analytics. The role offers a hybrid work arrangement with Cincinnati, OH, or remote options in the Eastern Time Zone, and requires strong DataStage and SQL/PLSQL expertise.

Responsibilities include developing scalable pipelines, integrating diverse data sources, and enabling data migration to Snowflake, with attention to automation, CI/CD, and production support.

Qualifications

• 6+ years of experience designing and developing enterprise data integration solutions.
• Strong hands-on experience with IBM DataStage 11.7 or later, including Parallel Jobs, Sequencers, Parameter Sets, Job Administration, Monitoring, and Performance Tuning.
• Advanced SQL and PL/SQL development experience.

Responsibilities

• Design, develop, test, deploy, and support enterprise ETL/ELT solutions using IBM DataStage.
• Build and maintain scalable data pipelines supporting data warehouse, data lake, and lakehouse architectures.
• Collaborate with business and technical stakeholders to understand requirements and deliver reliable data integration solutions.
• Develop reusable ETL frameworks, parameterized jobs, and metadata-driven solutions.
• Integrate data from Oracle, DB2, SQL Server, Snowflake, flat files, XML, JSON, Parquet, and cloud storage platforms.
• Implement data extraction, transformation, validation, cleansing, reconciliation, and loading processes.
• Design and develop cloud-native data pipelines and support migration of on-premises data to Snowflake.
• Create and maintain Unix/Linux shell scripts for automation, scheduling, monitoring, and operational support.
• Optimize ETL processes, Snowflake workloads, and data movement performance.
• Perform root cause analysis, troubleshooting, production support, and incident resolution.
• Support Agile development practices, source control, and CI/CD processes.

Skills

IBM DataStage

SQL

PL/SQL

Oracle DB

DB2

ETL pipelines

Shell scripting

Snowflake

Git

CI/CD

Tools

Git

CI/CD pipelines

Snowflake tooling

Job description

Codeworks, an LRS company, is seeking a Senior DataStage ETL Developer to design and build enterprise ETL/ELT solutions powering analytics. The role offers a hybrid work arrangement with Cincinnati, OH, or remote options in the Eastern Time Zone, and requires strong DataStage and SQL/PLSQL expertise.

Responsibilities include developing scalable pipelines, integrating diverse data sources, and enabling data migration to Snowflake, with attention to automation, CI/CD, and production support.