> Markdown version of [/jobs/ext/2851000-data-engineer-ibm-db2](https://www.wearedevelopers.com/jobs/ext/2851000-data-engineer-ibm-db2). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Engineer - IBM Db2 - **Company:** Inizio Partners Corp - **Location:** Seattle, WA, United States - **Experience:** Experienced - **Contract:** Temporary contract - **Skills:** Artificial Intelligence, Business Logic, Unit Testing, Cloud Database, Data Cleansing, Information Engineering, Data Governance, Data Transformation, IBM DB2, DB2 SQL, Performance Tuning, Query Optimization, Standard Sql, SQL Stored Procedures, SQL Databases, Working Model 2D, Enterprise Data Management, Database Optimization, Analytic Functions, Code Restructuring, Data Pipelines - **Published:** September 11, 2026 - **Apply:** https://www.thejobnetwork.com/job/97b236a0-36a2-4962-b600-cf43ee524b45/data-engineer-ibm-db ## About the Role * 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 * Implementing robust error handling using: SIGNAL SQLSTATE, Default return sets, NULL-safe logic * 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 Nice to Have * 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 ## Description 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 ## Related Videos - [Data Fabric in Action - How to enhance a Stock Trading App with ML and Data Virtualization](https://www.wearedevelopers.com/videos/253-data-fabric-in-action-how-to-enhance-a-stock-trading-app-with-ml-and-data-virtualization) - [Are you still programming unit tests or already generating?](https://www.wearedevelopers.com/videos/722-are-you-still-programming-unit-tests-or-already-generating) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [How Unit Testing Saved My Career](https://www.wearedevelopers.com/videos/1642-how-unit-testing-saved-my-career) - [How will artificial intelligence change the future of software testing?](https://www.wearedevelopers.com/videos/85-how-will-artificial-intelligence-change-the-future-of-software-testing) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [7 Cloud Computing Trends Coming in 2025 for Developers](https://www.wearedevelopers.com/magazine/412-7-cloud-computing-trends-coming-in-2025-for-developers) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)