Boomi Integration Architect � Data Warehouse & MDH

Slipstream IT•Durham, NC

About The Position

We are seeking a Boomi Integration Architect with deep experience in Data Warehouse (DW) implementations , Master Data Hub (MDH) , and Boomi Flow . This role will be responsible for designing and leading scalable, secure, and high-performance integration solutions across enterprise platforms including cloud, SaaS, on-prem, and data platforms. The ideal candidate will bring strong data architecture expertise , hands-on Boomi MDH & Flow experience , and the ability to translate complex business requirements into robust integration and data orchestration solutions.

Requirements

Boomi AtomSphere (Advanced)
Boomi Master Data Hub (MDH)
Boomi Flow
REST/SOAP APIs, JSON, XML
Event-driven and API-led integration patterns
Data modeling and master data concepts
10+ years of Data Warehousing implementation experience
Strong understanding of: Dimensional modeling, Data ingestion patterns, Data quality & governance
Experience integrating DW with operational systems
Cloud platforms: AWS / Azure / GCP (at least one)
Authentication: OAuth 2.0, SAML, API security
Encryption, secure data transfer, compliance best practices

Nice To Haves

Boomi certifications (Professional / Architect / MDH)
Experience with Salesforce, SAP, Oracle, Workday, or similar enterprise systems
Experience in regulated industries (Pharma, Healthcare, Finance)
Exposure to data governance tools and MDM strategies
Event streaming (Kafka, Pub/Sub)
CI/CD for integrations
Data catalog or lineage tools

Responsibilities

Integration & Architecture Design and own end-to-end integration architecture using Boomi AtomSphere
Define integration patterns (API-led, event-driven, batch, real-time)
Architect scalable integrations for Data Warehouses, ERP, CRM, and SaaS platforms
Lead Boomi environment strategy (Atoms, Molecules, Clouds, security, scaling)
Design and implement Boomi Master Data Hub models
Define golden record strategies , survivorship rules, and match rules
Implement MDH publish/subscribe patterns to downstream systems
Manage data governance, versioning, and data quality rules in MDH
Design and implement Boomi Flow applications for: Data onboarding, Approval workflows, Master data stewardship
Integrate Flow with MDH, APIs, and backend systems
Define reusable Flow components and best practices
Lead integration design for DW platforms (Snowflake, Redshift, BigQuery, Azure Synapse, Teradata, etc.)
Design ingestion pipelines (batch & near real-time)
Implement data transformations, validations, and enrichment logic
Ensure data lineage, reconciliation, and auditability
Act as technical lead / architect on integration programs
Provide guidance and reviews for development teams
Define integration standards, best practices, and documentation
Partner with business stakeholders, data architects, and security teams