Data Engineer - IBM Db2
Inizio Partners
Data Engineer – IBM Db2
Seattle, Washington, United States
About the Job
Job Title: Data Engineer – IBM Db2
- Number of Resources - 2
- Experience: 4-6 years
- Duration – 6 Months
- Location- Seattle, WA
- Type of working model- Hybrid
- Start date- Mar 15, 2026
Job Summary
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
- 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
Or refer someone
Vacancy posted 2 days ago
Similar jobs that could be interesting for youBased on the Data Engineer - IBM Db2 in Seattle, WA vacancy
- IBM Computing is seeking a Sr. Consultant, Analytics Engineering in Bellevue, WA. This role focuses on transforming raw data into well-modeled assets that power decision-making and AI/ML use cases. The ideal candidate will have over 5 years of experience in analytics engineering...Ibm
- IBM Computing seeks a Sr. Consultant, Analytics Engineering in Seattle, WA. This role is vital for transforming raw data into reliable analytics assets. Candidates should have extensive experience in data modeling and analytics engineering, with a strong command of SQL...Ibm
$87.15k - $100.01k
...the advancement and optimization of our data ecosystem, focusing on data movement, integration... .... ~8+ years of experience in data engineering or closely related roles. ~3-5 years... ...experience with data visualization tools such as IBM Cognos, Power BI, Tableau, and...IbmWork at officeLocal areaFirst Fed
Seattle, WA14 hours ago$120k - $140k
Qualifications Awareness of IBM Data Stage ETL/ELT data integration tool to understand existing code. Develop, Test, Deploy, Optimize, and monitor large-scale data processing workloads in Azure Data Bricks ETL. Ensure and lead the efforts to review Legacy Data Stage...IbmRemote work- Introduction At IBM, work is more than a job - it's a calling: To build. To design. To code... ...looking for a Sr. Consultant, Analytics Engineering to join our growing team of experts. This position sits at the intersection of data engineering and analytics, focused on...Ibm
- Introduction At IBM Software, we transform client challenges into solutions. Building... ...that changes the world. With Confluent, data doesn’t sit still. We put information in... ...enormous potential, we are looking for software engineers, at various levels, to grow our Traffic...IbmWork experience placement
- We’re looking for a rare kind of engineer — someone who doesn’t wait to be told what to do, figures... ...’ll own end‑to‑end delivery across modern data platforms and full stack applications,... ...orchestration Working knowledge of DB2 and experience handling legacy database environments...Weekend work
- IBM Computing in Seattle is seeking Software Engineers to join our Traffic team, responsible for managing the networking fabric of Confluent Cloud. This role emphasizes building and managing network data planes, ensuring system performance, security, and cost optimizations...Ibm
$88k - $120k
...you ready to make an impact? West Monroe is seeking a talented Data Engineer to join our Data Engineering & Analytics team. In this role,... ...ETL tools (Azure Data Factory, AWS Glue, Informatica, Talend, IBM DataStage, etc.), and/or database platforms (Snowflake, Redshift...IbmWork at officeLocal areaImmediate startFlexible hours2 days per week$134k - $173.4k
...operational excellence. Team Description: This role is on the Data Platform Engineer Team. We are responsible for providing day-to-day management... ...activities. Technical Skills * Data Platforms * SAP HANA, Snowflake, DB2, SAP BW * AWS Service knowledge like S3, Lambda * Data...Work experience placementWork at officeThe Walt Disney Company
Seattle, WA2 days ago- ...and Google and Private Cloud leaders like IBM, Dell, HPE, RedHat. The formation of... ...of integrated cloud capabilities across data, edge, integrated infrastructure and applications... ...influence cross‑functional teams across engineering, sales, industry, and ecosystem partners....IbmWork experience placementLive inWork at officeLocal area
- ...Key Responsibilities Develop, maintain, and enhance applications on AS400 (IBM i) platform Write and optimize programs using RPG (RPG III/IV, RPGLE, Free Format RPG) Design, query, and manage DB2 databases Provide L2/L3 production support, troubleshooting and resolving...Ibm
- ...A leading social media platform is seeking a Senior/Staff Big Data Storage and Computing Engineer to join their Recommendation Data Ecosystem team in Seattle. This role is pivotal in enhancing the data ecosystem and contributing to innovative data-driven improvements....
Tik Tok
Seattle, WA2 days ago - ...About the job Senior Sterling OMS Developer/Lead IBM Sterling OMS Developer Location: Seattle, WA Type: Onsite | Contract... ...OMS database schema and write optimized SQL queries (Oracle/DB2). ~ Integrate OMS with external systems such as ERP, WMS (e.g....IbmContract work
Simarn Solutions
Seattle, WA14 hours ago - ...Job Title: Data Engineer . Role: Start Date: August End Date: 7/31/26 Location : Seattle, WA preferred, or last option remote west coast Bill Rate: $55/Hr on C2C Client Name : CoForge / Alaska Airlines SUBMIT ONLY GENUINE...For contractorsImmediate startRemote work
Concord IT Systems
Seattle, WA3 days ago $90k - $120k
...time Description Shannon & Wilson is a leading geotechnical engineering firm dedicated to delivering innovative solutions in... ...our digital transformation journey, we are investing in modern data platforms and analytics capabilities to support better decision...Full timePart timeWork at officeLocal areaVisa sponsorshipWork visaShannon & Wilson
Seattle, WA7 hours ago$153.5k - $207.7k
...Senior Data Engineer As a Senior Data Engineer, you will share ownership of Redfin's Data Platform, owning business critical data integrations and operational excellence. You will work closely with Engineering and Analytics teams to create and support data pipelines...Rocket Companies
Seattle, WA3 days ago$90k - $117k
...projects with our integrated teams, including: New construction – Engineering, fabrication and install of mechanical systems for new projects... ...enjoy working with. We strive to be both. Requirements Data EngineerThis is where you come in. MacDonald-Miller is...Temporary workFor contractorsWork at officeRemote work2 days per week3 days per weekMacDonald-Miller Facility Solutions
Seattle, WA4 days ago$141.9k - $190.3k
...Senior Data Engineer Technology is at the heart of Disney's past, present, and future. Disney Entertainment and ESPN Product & Technology is a global organization of engineers, product developers, designers, technologists, data scientists, and more – all working to...The Walt Disney Studios
Seattle, WA14 hours ago- ...and services that improve everyday life while supporting businesses, communities, and economies worldwide. Position : Data Integrity Engineer Location: Seattle, WA 98101 Duration: 8 Months Job Type: Temporary Assignment Work Type: Onsite Job Description...Temporary workWorldwide
Tekwissen
Seattle, WA7 hours ago $98.81k - $148.22k
...with diligence, patience and pride. That's the Weyerhaeuser way. About the Role Weyerhaeuser's Data & Analytics team is looking for a Data Engineer to build and operate the data platform that powers reporting, analytics, and AI across the enterprise. This...Full timeTemporary workWork at officeWeyerhauser Co
Seattle, WA4 days ago$180k - $260k
...by Forbes. Check out the latest Whatnot updates on our news and engineering blogs and join us as we enable anyone to turn their passion... ...business and bring people together through commerce. Role Data is crucial to Whatnot's mission to bring people together through...Full timeWork at officeLocal areaRemote workWork from homeHome officeWhatnot
Seattle, WA3 days ago- ...Job Summary: The Senior Data Engineer will be responsible for designing, building, and maintaining scalable data pipelines and cloud-based data solutions. This role focuses on developing robust ETL/ELT processes, optimizing Databricks environments, and enabling data...
Prophecy Technologies
Seattle, WA14 hours ago $144.05k - $150k
...Brands, the parent company of Orangetheory, Anytime Fitness, Waxing the City, The Bar Method, and Basecamp Fitness, is seeking a Data Engineer to join its Purpose Brands team. This is a great position for someone who is looking to expand their career, and join a company...Local areaRemote workFlexible hours1 day per weekPurpose Brands LLC
Seattle, WA3 days ago- ...The Allen Institute for AI (AI2) in Seattle is hiring a Senior Data Engineer to build the data infrastructure behind AI research agents. This role involves improving the Semantic Scholar corpus and creating necessary APIs and tooling. The ideal candidate will have strong...
Allen Institute for AI (AI2)
Seattle, WA2 days ago - ...Data Engineer At T-Mobile, we invest in YOU! Our Total Rewards Package ensures that employees get the same big love we give our customers. All team members receive a competitive base salary and compensation package - this is Total Rewards. Employees enjoy multiple wealth...Full timeTemporary workPart timeWork experience placementWork at officeLocal areaFlexible hours3 days per week
T Mobile US
Bellevue, WA7 hours ago - ...Allen Institute for Artificial Intelligence is seeking a Senior Data Engineer to build the data infrastructure behind AI research agents. This role requires strong Python engineering skills, experience with SQL, and a background in machine learning workflows. You will...
Allen Institute for Artificial Intelligence
Seattle, WA2 days ago - ...Details Role: Data Engineer (Synapse) Location: Bellevue, WA Our team is looking to add strong Data Engineers with good SQL and Azure Analytical skills. Development activities: Ability to gather and understand requirements by studying...Full timeLocal areaFlexible hours
Sogeti
Bellevue, WA4 days ago - ...Support identification and implementation of integration, modelling, and orchestration of complex data using relevant coding language(s) Monitor and troubleshoot data engineering-related incidents Support development and maintenance of relevant documentation...
Sparktek
Seattle, WA1 day ago $75 per hour
...We are looking for a Data Engineer to join the Infrastructure Automation team. Our success depends on our world-class network and hardware infrastructure; we're handling massive scale and rapid integration of emergent technologies. Our goal is to become "The Infrastructure...People, Data & Solutions
Seattle, WA3 days ago
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Data Engineer - IBM Db2. Be the first to apply!
Related searches
- senior data center engineer Seattle, WA
- data engineer manager Seattle, WA
- data science developer Seattle, WA
- etl data engineer Seattle, WA
- entry level big data engineer Seattle, WA
- data engineer Seattle, WA
- big data cloud engineer Seattle, WA
- junior big data engineer Seattle, WA
- remote data engineer Seattle, WA
- senior data engineer Seattle, WA