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 3 days ago
Similar jobs that could be interesting for youBased on the Data Engineer - IBM Db2 in Seattle, WA vacancy
- ...Responsibilities Legacy Data Extraction: Design, build, and optimise high-throughput data extraction pipelines from legacy IBM DB2 transactional databases without locking production environments. Cloud Platform Build: Develop production-grade ETL pipelines and data lake...Ibm
Virtue Tech Inc.
Seattle, WA13 hours ago - VirtueTech is seeking a Data Engineer in Washington, United States, to design and build high-throughput data extraction pipelines from legacy IBM DB2 databases. The role involves developing production-grade ETL pipelines on the AWS data platform and collaborating on schema...Ibm
- ...Job Description Launch Your Data Career with Proof, Not Promises-At SynergisticIT... ...paying career in Data Science, Analytics, or Engineering , it's time to stop guessing and start... ...Certification Support - Boost your résumé with IBM Data Science, AWS Data Analytics,...Ibm
SynergisticIT
Bellevue, WA3 days ago - ...Introduction At IBM, work is more than a job - it's a calling: To build. To design. To code. To consult. To think along with clients... ...role and responsibilities We are looking for a Sr. Consultant, Data Engineer to join our growing team of experts. This position will work in...Ibm
IBM Computing
Seattle, WA13 hours ago $95k - $150k
...Junior Data Scientist With Data Engineering Skills We are seeking a motivated Junior Data Scientist with Data Engineering skills to join our tech clients... ...: Google, Apple, Facebook (Meta), Amazon, Microsoft, IBM, Oracle, Cisco, Client, Wells Fargo, Client, PayPal, eBay...IbmWork experience placementInternshipSynergisticIT
Seattle, WA6 days ago- 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
- ...Data Engineer(Local Candidates) Location: Renton WA Bill Rate: 50-60/hr on C2C Duration: 6 Months Job Functions / Responsibilities... ...with RDBMS platforms, such as MS SQL Server, Oracle, DB2, IMS, MySQL, Postgres, SAP HANA, and Teradata. ~ Experience...Local area
ClifyX
Renton, WA1 day ago - IBM Computing in Seattle is seeking a Staff Solution Sales Engineer to drive innovative Data Streaming use-cases and collaborate closely with Account Executives. The role requires expertise in Event-Driven architecture and a customer-focused approach to enable ongoing...Ibm
- IBM Computing in Bellevue, United States, is searching for a Solutions Engineer to partner with Account Executives while driving technical solutions and innovations. This role demands extensive experience in solutions engineering and cloud technologies, as well as exceptional...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- ...improvements. This position manages the installation and maintenance of mechanical systems at Data Centers and operations of specialized cooling systems. Acts as an Engineering resource for the complete H5 portfolio of mission critical facilities. Plans and monitors...Work at officeImmediate start
H5 Data Centers
Seattle, WA15 days ago - ...including FSPs, PRPs, and system diagrams. Develop and maintain DB2 SQL queries for IRS subsystems. Participate in program analysis,... ...with IRS systems, particularly IRS IMFOL development. Proficient in IBM Mainframe, ALC, and JAVA. Bachelor’s degree or 4 years of related...IbmPermanent employment
3M Consultancy
Seattle, WA3 days ago - # Sr. Data EngineerApply**Job#: 3038847****Job Description:****Senior Data Engineer (L6)****Sustainability Data Platform Migration Senior Data Engineer****Overview:**Apex Systems is seeking a Senior Data Engineer to support the migration of a legacy database environment...Hourly payContract work
Apex Systems
Seattle, WA5 days ago $133.33k - $210.73k
...Responsibilities Lead the research, design, and development of data solutions to address analytical, research, and clinical data requirements... ...of data structures. Develop prototypes and pilot new data engineering solutions to determine their viability for adoption and long-...H1bVisa sponsorshipRelocation packageFlexible hoursLife Science Washington
Seattle, WA3 days ago$144.31k - $178.8k
...Description Employer: Amazon Data Services, Inc. Position: Data Engineer II Location: Seattle, WA Multiple Positions Available: Design, develop, implement, test, document, and operate large-scale, high-volume, high-performance data structures for business intelligence...Relocation packageAmazon
Seattle, WA3 days ago- ...We are seeking a Data Engineer (2-4 years) to build and scale data products that support analytics, reporting, operational visibility, and business decision‑making. The ideal candidate is a product‑minded engineer who takes ownership of solutions from design to production...
BrickRed Systems
Bellevue, WA3 days ago $42.75 per hour
...End date). Summer Start Dates May 11th, 2026 May 18th, 2026 May 26th, 2026 June 8th, 2026 June 22nd, 2026 Team Introduction As a data engineer in the Data Platform E‑Commerce team, you will have the opportunity to build, optimize and grow one of the largest data...Hourly paySummer workInternshipLocal areaTik Tok
Seattle, WA3 days ago$68k - $102k
...Responsibilities Lands data from authoritative sources into the team's unified ingestion framework using the patterns specified in the... ...independently and sometimes as specified by the Senior Data Engineer. Builds pipelines in Snowflake (including Iceberg tables) and/or...Full timeTemporary workWork experience placementLocal areaFlexible hoursUST Inc
Bellevue, WA2 days ago- ...Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team. Job Title: Data Engineer Location(s): Seattle, WA Job Description: Are you interested in working with the latest technology in the cloud computing space?...Flexible hours
Ampcus
Seattle, WA4 days ago $106.9k - $176.5k
...wherever you want it to go. Join EY and help to build a better working world. We are seeking a highly skilled Senior Consultant Data Engineer with expertise in cloud data engineering, specifically Databricks. The ideal candidate will have strong client management and communication...Summer holidayFlexible hoursEY
Seattle, WA3 days ago$124.9k - $228.9k
...meet you. About The Role This role sits within the Technology Operations group in Engineering at The Trade Desk and focuses on building reliable, scalable, and well‑governed enterprise data solutions. As a Senior Software Engineer – Data Engineer, you will be an end‑to‑...Full timeTemporary workWork experience placementLocal areaWorldwideThe Trade Desk
Bellevue, WA4 days ago- ...Mandatory Skills: Cribl and Vector Lead the architecture, design, and implementation of scalable, modular, and reusable data flow pipelines using Cribl, Apache NiFi, Vector, and other open-source platforms, ensuring consistent ingestion strategies across a complex, multi...
TechDigital Group
Bellevue, WA4 days ago $225k - $300k
...connects enterprise supply chain systems—ERP, WMS, TMS—into a single data layer, then uses AI to detect problems, evaluate trade‑offs,... ...that operate at scale. At the core of this system is Data Engineering. This role sets direction for and owns the evolution of the transformation...Auger Services Inc
Bellevue, WA2 days ago- ...systems Model warehouses that answer owner-level questions fast Hand clients documented pipelines they can run without us What you bring 4+ years building production data pipelines Experience with at least one warehouse (BigQuery, Snowflake, Postgres) #J-18808-Ljbffr...
AutomateNexus LLC
Seattle, WA3 days ago $132.1k - $178.8k
...and so much more, you can decide where a career with Prime Video takes you! We are seeking a highly skilled and technically adept Data Engineer to join our PVA Data Engineering team. In this role, you will design, build, and maintain scalable, fault-tolerant data...WorldwideFlexible hoursAmazon
Seattle, WA1 day ago$135.05k
...Office, subject to WaFd Bank guidelines. Are you passionate about data? At WaFd Bank's Enterprise Data Department , we're on a mission... ...to submit a cover letter with their resume. As a Senior Data Engineer, you will have a leading role in designing, building, and maintaining...Work at officeWaFd Bank
Seattle, WA2 days ago$320k - $405k
...Our team is a quickly growing group of committed researchers, engineers, policy experts, and business leaders working together to build... ...Role As an Analytics Engineer, you will be an early member of the Data Science & Analytics team building the foundation to scale...Visa sponsorshipAnthropic
Seattle, WA5 days ago$65 - $73 per hour
...Job Title: Data Engineer III Job Description This role focuses on building robust data pipelines, backend services, and analytics components that support compliance automation for a global satellite communications service. You will work within established architectural...Contract workTemporary workInternshipWork at officeWorldwideActalent
Bellevue, WA5 days ago- ...INTEGRITYOne Partners Data Engineer (Analytics) Location: 100% Onsite Full-Time (Monday to Friday) in Washington, D.C. The Role You’ll be at the forefront of delivering data and software solutions that directly impact our clients’ law enforcement mission. You’ll work with...Full timeMonday to Friday
PROVATOHR INC
Seattle, WA4 days ago $153.5k - $207.7k
...Overview 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 and transformations...Rocket Homes Real Estate LLC
Seattle, WA4 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 cloud data engineer Seattle, WA
- principal data engineer Seattle, WA
- finance data engineer Seattle, WA
- aws data engineer Seattle, WA
- data engineer Seattle, WA
- sr data engineer Seattle, WA
- software data engineer Seattle, WA
- junior data engineer remote Seattle, WA
- remote data engineer Seattle, WA
- data engineer contract Seattle, WA