Data Engineer – IBM Db2Seattle, Washington, United StatesAbout the JobJob Title: Data Engineer – IBM Db2Number of Resources - 2Experience: 4-6 yearsDuration – 6 MonthsLocation- Seattle, WAType of working model- HybridStart date- Mar 15, 2026Job SummaryWe 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 ResponsibilitiesDesign, build, and maintain data pipelines and transformations in IBM Db2Develop and optimize SQL-based data models for analytics and BI consumptionCreate, refactor, and optimize Db2 Table Functions (Inline and Compiled)Migrate and modernize legacy logic by replacing stored procedures with table functionsEnsure data pipelines are Metabase-friendly, scalable, and performantImplement robust error handling, testing, and monitoring for Db2 workloadsCollaborate with BI, Data Engineering, and AI teams to support reporting and advanced analytics needsPerform performance tuning using explain plans, indexing strategies, and query optimizationEnsure best practices around deterministic logic, stability, and maintainabilityRequired Technical SkillsStrong experience with IBM Db2 (LUW / Server)Solid understanding of Db2 SQL fundamentalsAdvanced DB2 SQL tuning for complex analytical queries: MQTs, Joins on large fact tables, Window functions and analytical SQL, Stored procedures and UDFsData Transformation & Business Logic using: DB2 stored procedures, CTEs, Recursive queries and analytical functionsExperience integrating Db2 with Metabase or other BI toolsOptimized DB2 views and aggregates for BI toolsExperience working with cloud-based data warehouse environments using Db2Strong understanding Stored Procedures & Table FunctionsHands-on experience with Db2 Table Functions, including Inline SQL Table Functions and Compiled SQL Table FunctionsRefactoring & Modernization in DB2Experience replacing stored procedures with table functionsHandling multi-value parameters in DB2Implementing robust error handling using: SIGNAL SQLSTATE, Default return sets, NULL-safe logicEnsuring deterministic, stable behavior and avoiding non-deterministic SQLPerformance tuning of Db2 SQL and table functionsUnit testing Db2 table functions for: Parameter edge cases, Empty result sets, NULL handling, Large input volumesNice to HaveExposure to AI/ML data preparation pipelinesRefactoring DB2 logic into ELT or cloud-native pipelinesExperience working in large-scale analytics or enterprise data platformsKnowledge of data governance, data quality, and best practicesOr refer someone