More jobs:
Data Engineer – IBM Db
Job in
Seattle, King County, Washington, 98127, USA
Listed on 2026-02-21
Listing for:
Inizio Partners
Full Time
position Listed on 2026-02-21
Job specializations:
-
IT/Tech
Data Engineer, Data Analyst
Job Description & How to Apply Below
We are seeking a hands‑on Data Engineer with strong IBM Db2 expertise to design, optimize, and modernize data pipelines supporting enterprise analytics and BI initiatives. This role will focus on advanced Db2 SQL development, table function engineering, performance optimization, and enabling scalable analytical workloads.
The ideal candidate has deep experience in Db2 (LUW/Server), strong SQL tuning capabilities, and proven ability to refactor legacy stored procedures into high-performance, BI-ready data structures.
Key Responsibilities- Design, develop, and maintain scalable data pipelines and transformations in IBM Db2
- Build and optimize SQL‑based data models for analytics and BI consumption
- Develop, refactor, and optimize Db2 Table Functions (Inline & Compiled SQL Table Functions)
- Modernize legacy Db2 logic by replacing stored procedures with optimized table functions
- Implement performance tuning strategies using explain plans, indexing, MQTs, and query optimization
- Ensure BI‑friendly data structures for tools such as Metabase
- Implement robust error handling using SQLSTATE, default return sets, and NULL‑safe logic
- Ensure deterministic, stable, and maintainable SQL development practices
- Unit test table functions for edge cases, large input volumes, and NULL handling
- Collaborate with BI, Data Engineering, and AI teams to support analytics and reporting use cases
- Strong hands‑on experience with IBM Db2 (LUW / Server)
- Advanced Db2 SQL development for analytical workloads
- Window functions & analytics SQL
- Common Table Expressions (CTEs)
- Materialized Query Tables (MQTs)
- Stored Procedures and UDFs
- Experience refactoring stored procedures into table functions
- Handling multi‑value parameters in Db2
- Implementing deterministic and stable SQL logic
- Performance tuning using:
- Explain plans
- Index optimization
- Query rewriting techniques
- Experience integrating Db2 with BI tools (Metabase preferred)
- Optimizing Db2 views and aggregates for reporting workloads
- Supporting analytics and reporting data pipelines
- Unit testing for:
- Empty result sets
- NULL handling
- Exposure to AI/ML data preparation pipelines
- Experience refactoring Db2 logic into ELT or cloud‑native architectures
- Understanding of data governance and data quality best practices
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
Search for further Jobs Here:
×