BI Integration Lead

As a BI Integration Lead at Penumbra, you will play a critical role in determining the company's long term goals. The Business Intelligence – Integration Lead will be an experienced Integration Strategy Architect with deep expertise in designing, assessing, and modernizing enterprise integration landscapes. This role requires strong architectural thinking, the ability to evaluate existing integrations, and the capability to recommend best practices, target-state architecture, and integration strategies aligned with business and IT goals.

What You'll Do

Define and own the enterprise integration strategy, architecture standards, and best practices

Develop and execute the Integration strategy in alignment with business objectives and IT strategy.

Design and govern API-led, event driven, canonical data integration patterns and resilient integration solutions across ERP and surrounding enterprise systems.

Lead integration architecture for ERP platform SAP S/4HANA and other applications like AD, UKG, Salesforce, ServiceNow, MES Systems like Camstar/OpCenter and other business applications.

Leverage Boomi AI for intelligent mapping, transformation and integration acceleration and Identify opportunities for AI-driven design, documentation, monitoring insights, and optimization.

Analyze existing integration landscapes to:

o Identify gaps, risks, redundancies, and performance issues

o Recommend modernization, optimization, and rationalization strategies

Provide architectural guidance on:

o Hybrid integration patterns and solutions during cloud migration phases.

o Design Boomi cloud deployment strategies, ensure high availability and disaster recovery

Establish integration governance including:

o Design principles

o Naming conventions

o Error handling, logging, monitoring, and security standards

Collaborate with business stakeholders, enterprise architects, application teams, infrastructure teams, and vendors to align integration solutions with business requirements

Mentor integration developers and technical teams on architecture standards and best practices

Support the integration roadmap planning, estimation, and technical decision-making

Ensure integrations comply with security, compliance, and data privacy requirements

Advanced experience in the development, construction, testing, and maintenance of data architecture

What You Bring

A Bachelor's degree in Information Technology or related field with 10+ years of experience, or equivalent combination of education and experience

10+ years of experience in enterprise application integration

Strong hands-on and architectural experience with Boomi and at least one other major middleware platform

Proven experience integrating SAP S/4HANA with Salesforce, Web Services, API’s, UKG, MES, and other third-party applications

Strong Expertise in Boomi Atmosphere, Boomi Flows, API Management, Hybrid integration architectures (On Prem, Cloud).

Strong Experience in Azure Data Factory Pipeline preferred.

Expertise in Boomi integrations design, Error handling, Exception Frameworks, and logging.

Strong Knowledge of Atoms, Molecules, Atom clouds and deployment topologies and Proven ability to manage Environment Strategy and reuse the licenses.

Deep understanding of:

o Integration patterns (point-to-point, hub-and-spoke, ESB, API-led, event-driven)

o REST/SOAP APIs, messaging, file-based integrations, and EDI

o API Security Patterns (OAUTH2, API Keys, JWT)

Experience assessing legacy integration environments and defining future-state architectures.

Knowledge of regulatory and audit requirements (SOX, SOC- as applicable).

Ability to translate business requirements into technical integration designs.

Excellent documentation, communication, and stakeholder management skills.

Experience working in large-scale, global enterprise environments.

Medical device, pharmaceutical, biotech, or other regulated industry experience desired

Strong oral, written, and interpersonal communication skills

High degree of accuracy and attention to detail

Proficiency with MS Word, Excel, and PowerPoint

Excellent organizational skills with ability to prioritize assignments while handling various projects simultaneously

Working Conditions

General office environment. Willingness and ability to work on site. Requires some lifting and moving of up to 10 pounds. Must be able to move between buildings and floors. Must be able to remain stationary and use a computer or other standard office equipment, such as a printer or copy machine, for an extensive period of time each day. Must be able to read, prepare emails, and produce documents and spreadsheets. Must be able to move within the office and access file cabinets or supplies, as needed. Must be able to communicate and exchange accurate information with employees at all levels on a daily basis.

Annual Base Salary Range: $153,000 - $210,000/ year

We offer a competitive compensation package plus a benefits and equity program, when applicable.

Individual total compensation will vary based on factors such as qualifications, skill level, competencies, and work location.