Senior Data Engineer

PINNACLE GROUP (Pinnacle Technical Resources); Cincinnati (OH); On-site; USD 76,000 - 96,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

401K

PTO

Job summary

PTR Global is seeking a Senior Data Engineer in Cincinnati to design, develop and support scalable IBM DataStage ETL solutions and data pipelines. You will collaborate with business and technology teams to deliver high-quality data integration that aligns with enterprise architecture standards.

The role requires deep DataStage, Snowflake, Unix shell scripting, and PL/SQL expertise, plus 8–10 years of engineering experience and a CS-related degree.

Qualifications

• 8-10 years of engineering experience (minimum 6 years required).
• IBM DataStage expertise 11.7+ with parallel jobs, sequencers, parameter sets.
• Advanced SQL/PLSQL in Oracle and DB2 environments.
• Snowflake experience including Streams/Tasks, stages, secure views.
• Unix/Linux Shell scripting for automation, batch scheduling, and ops support.
• Strong ETL/ELT, Data Warehousing, and Data Lake/Lakehouse knowledge.
• Git, CI/CD, Agile/DevOps practices knowledge.
• Bachelor’s degree in computer engineering, computer science, or related field.

Responsibilities

• Design, develop, test, deploy, and support complex ETL/ELT solutions with DataStage.
• Create reusable ETL frameworks and metadata-driven workflows.
• Translate business requirements into scalable data integration designs.
• Implement data extraction, transformation, validation, cleansing, loading processes.
• Integrate data from Oracle, DB2, SQL Server, Snowflake, flat files, and cloud storage.
• Design cloud-native pipelines and migrate on-prem data to Snowflake.
• Optimize data movement for data warehouses, data lakes, and lakehouses.
• Provide production support, incident management, and performance tuning.

Skills

IBM DataStage 11.7+

SQL & PL/SQL

Snowflake

Unix/Linux Shell Scripting

ETL/ELT design

Data Warehousing / Lakehouse

Git / CI/CD / DevOps

Batch processing / CDC

Education

Bachelor's degree in Computer Science / Engineering or related field

Tools

IBM DataStage

Snowflake tooling

Oracle / DB2 / SQL Server

Git

Job description

Senior Data Engineer
IT | Software Design/Developer Cincinnati , Ohio Contract Aug 6, 2026

Position: ETL Datastage Developer
Location: Cincinnati, Ohio
Duration: Contract
Job ID: 178780

Job Overview:

We are seeking a highly skilled and experienced Senior Data Engineer to design, develop, and support scalable IBM DataStage ETL solutions and enterprise data pipelines for mission-critical applications. The ideal candidate will collaborate with business and technology teams to deliver high-quality, performant, and reliable data integration solutions aligned with enterprise architecture standards. This role requires extensive experience working with multiple source and target systems, including Oracle, DB2, Snowflake, flat files, cloud storage, and structured, semi-structured, and unstructured data sources. The candidate should possess deep expertise in IBM DataStage, Snowflake, Unix Shell Scripting, and PL/SQL.

Responsibilities:

• Design, develop, test, deploy, and support complex ETL/ELT solutions using IBM DataStage and enterprise data pipelines.
• Develop reusable ETL frameworks using IBM DataStage, parameterized jobs, metadata-driven solutions, and automated data processing workflows.
• Analyze business and technical requirements and translate them into scalable ETL designs and data integration solutions.
• Implement data extraction, transformation, validation, cleansing, reconciliation, and loading processes using DataStage.
• Integrate data from Oracle, DB2, SQL Server, Snowflake, flat files, XML, JSON, Parquet, and cloud storage platforms using DataStage.
• Design and develop cloud-native data pipelines and migrate data from on-premises systems to Snowflake.
• Optimize data movement processes and support data warehouse, data lake, and Lakehouse platforms.
• Enable enterprise analytics and reporting solutions.
• Perform performance tuning, root cause analysis, production support, and incident management.
• Collaborate with stakeholders to understand business needs and deliver solutions independently after training.

Qualifications:

• Strong hands-on experience with IBM DataStage 11.7 or above, including Parallel Jobs, Sequencers, Parameter Sets, Job Monitoring, Administration, and Performance Tuning.
• Advanced SQL and PL/SQL development skills with strong experience in Oracle and DB2 environments.
• Strong experience with Snowflake, including Streams and Tasks, Dynamic Tables, Internal and External Stages, Secure Views, Data Sharing, and Query Performance Optimization.
• Strong Unix/Linux Shell Scripting skills for process automation, file handling, batch scheduling, operational support, and production troubleshooting.
• Experience creating high-performance batch, incremental, and CDC-based data pipelines for large-volume data processing.
• Strong understanding of ETL/ELT architecture, Data Warehousing, Dimensional Modeling, Data Lakes, and Data Lakehouse architectures.
• Working knowledge of Git, CI/CD pipelines, Agile methodologies, and DevOps practices.
• 8-10 years of engineering experience (minimum 6 years required).
• Bachelor's degree in computer engineering, computer science, or a related discipline.

Preferred Qualifications:

• CI/CD experience.
• Performance optimization in Snowflake.
• Previous payments industry experience.

Interview Process:

• Two rounds, panel style interviews.
• Interviews expected to start next week for qualified candidates.

About PTR Global:

PTR Global is a leading provider of information technology and workforce solutions. PTR Global has become one of the largest providers in its industry, with over 5000 professionals providing services across the U.S. and Canada. For more information visit www.ptrglobal.com

Pay Range: $55- $70/hour

The specific compensation for this position will be determined by several factors, including the scope, complexity, and location of the role, as well as the cost of labor in the market; the skills, education, training, credentials, and experience of the candidate; and other conditions of employment. Our full-time consultants have access to benefits, including medical, dental, vision, and 401K contributions, as well as PTO, sick leave, and other benefits mandated by applicable state or localities where you reside or work.

During the hiring process, we may use artificial intelligence (AI) tools to assist in evaluating information related to your application. These tools may help analyze job-related qualifications or assist recruiters in reviewing applications and interview responses. AI-generated information is one factor considered in our hiring process. Final employment decisions are made by qualified hiring personnel and are not based solely on AI-generated recommendations.