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.
Key Responsibilities
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
Required Technical Skills
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