Boomi Integration Architect – Data Warehouse & MDH
Role Summary
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.
Key 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)
Master Data Hub (MDH)
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
Boomi Flow
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
Data Warehousing & Analytics
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
Leadership & Governance
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
Required Skills & Qualifications
Core Technical Skills
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
Data & DW Expertise
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 & Security
Cloud platforms: AWS / Azure / GCP (at least one)
Authentication: OAuth 2.0, SAML, API security
Encryption, secure data transfer, compliance best practices
Preferred Qualifications
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
Soft Skills
Strong communication and stakeholder management
Ability to translate business needs into technical designs
Mentoring and leadership mindset
Comfortable working in fast-paced, multi-stakeholder environments
Nice-to-Have
Event streaming (Kafka, Pub/Sub)
CI/CD for integrations
Data catalog or lineage tools