Data Engineer – IBM Db

We are looking for a skilled Data Engineer with strong hands-on experience in IBM Db2 to design, build, and optimize data pipelines and analytical solutions. The ideal candidate will have deep expertise in Db2 SQL, table functions, stored procedures
, and performance tuning, with experience supporting BI tools such as Metabase
and enabling analytics and AI use cases.

• Design, build, and maintain data pipelines and transformations in IBM Db2
• Develop and optimize SQL-based data models for analytics and BI consumption
• Create, refactor, and optimize Db2 Table Functions
  (Inline and Compiled)
• Migrate and modernize legacy logic by replacing stored procedures with table functions
• Ensure data pipelines are Metabase-friendly
  , scalable, and performant
• Implement robust error handling, testing, and monitoring for Db2 workloads
• Collaborate with BI, Data Engineering, and AI teams to support reporting and advanced analytics needs
• Perform performance tuning using explain plans, indexing strategies, and query optimization
• Ensure best practices around deterministic logic, stability, and maintainability

• Strong experience with IBM Db2 (LUW / Server)
• Solid understanding of Db2 SQL fundamentals
• Advanced DB2 SQL tuning for complex analytical queries: MQTs, Joins on large fact tables, Window functions and analytical SQL, Stored procedures and UDFs
• Data Transformation & Business Logic using: DB2 stored procedures, CTEs, Recursive queries and analytical functions
• Experience integrating Db2 with Metabase or other BI tools
• Optimized DB2 views and aggregates for BI tools
• Experience working with cloud-based data warehouse environments using Db2
• Strong understanding Stored Procedures & Table Functions
• Hands-on experience with Db2 Table Functions
  , including Inline SQL Table Functions and
  Compiled SQL Table Functions
• Refactoring & Modernization in DB2
• Experience replacing stored procedures with table functions
• Handling multi-value parameters in Db2
• Ensuring deterministic, stable behavior and avoiding non-deterministic SQL
• Performance tuning of Db2 SQL and table functions
• Unit testing Db2 table functions for:
  Parameter edge cases, Empty result sets, NULL handling, Large input volumes

• Exposure to AI/ML data preparation pipelines
• Refactoring DB2 logic into ELT or cloud-native pipelines
• Experience working in large-scale analytics or enterprise data platforms
• Knowledge of data governance, data quality, and best practices