Lead Data Engineer

A client with OpenKyber is seeking a Senior Data Engineer in Cincinnati, OH.

Summary: This role involves building scalable data pipelines, optimizing data movement processes, supporting data warehouse, data lake, and Lakehouse platforms, and enabling enterprise analytics and reporting solutions.

Duties:

• Design, develop, and support scalable IBM DataStage ETL solutions and enterprise data pipelines for mission-critical applications
• Collaborate with business and technology teams to deliver high-quality, performant, and reliable data integration solutions aligned with enterprise architecture standards
• Design, develop, test, deploy, and support complex ETL/ELT solutions using 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

• A Bachelor's degree in Computer Engineering, Computer Science or other related discipline or the equivalent combination of education, training, or work experience
• 8-10 years of engineering experience
• Experience with performance tuning, root cause analysis, production support, and incident management
• The ideal candidate will have extensive experience working with multiple source and target systems including Oracle, DB2, Snowflake, flat files, cloud storage, structured, semi-structured, and unstructured data sources
• Working knowledge of Git, CI/CD pipelines, Agile methodologies, and DevOps practices
• Should possess deep expertise in IBM DataStage, Snowflake, Unix Shell Scripting, PL/SQL
• 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
• Experience integrating data from Oracle, DB2, SQL Server, Snowflake, flat files, XML, JSON, Parquet, and cloud storage platforms using DataStage
• Strong experience with Snowflake including, Streams and Tasks, Dynamic Tables, Internal and External Stages, Secure Views, Data Sharing and Query Performance Optimization
• Experience designing, developing cloud-native data pipelines, and migrating data from on-premises systems to Snowflake
• 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

The pay range is the lowest to highest compensation we reasonably in good faith believe we would pay at posting for this role. We may ultimately pay more or less than this range. Employee pay is based on factors like relevant education, qualifications, certifications, experience, skills, seniority, location, performance, union contract and business needs. This range may be modified in the future.

We offer comprehensive benefits including medical/dental/vision insurance, HSA, FSA, 401(k), and life, disability & ADD insurance to eligible employees. Salaried personnel receive paid time off. Hourly employees are not eligible for paid time off unless required by law. Hourly employees on a Service Contract Act project are eligible for paid sick leave.

Note: Pay is not considered compensation until it is earned, vested and determinable. The amount and availability of any compensation remains in OpenKyber's sole discretion unless and until paid and may be modified in its discretion consistent with the law.

This job is not eligible for bonuses, incentives or commissions. OpenKyber is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.

By clicking ?Apply Today? you agree to receive calls, AI-generated calls, text messages or emails from OpenKyber and its affiliates, and service providers. Note that if you choose to communicate with OpenKyber via text messaging the frequency may vary, and message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You will always have the right to cease communicating via text by using key words such as STOP.

For applications and inquiries, contact:View email address on click.appcast.io