Data Integration Lead

Job Description :

Microsoft Business Central, Charge bee, Boomi, and MicrosoftFabric. 

We are seeking a Data Integration Engineer to ensure that transactional data flowing from our event hub is correctly ingested, transformed, and validated within our enterprise datamodel built on Microsoft Fabric’s medallion architecture.

This role is critical to enabling downstream financial reporting, revenue forecasting, and the parallel validation process required before IMA can confidently cut over to Business Central for financial operations.  

What You’ll Do• 

Build and maintain data pipelines that ingest events from the Boomi-powered event hub into the Microsoft Fabric Bronze layer, with proper schema validation and error handling.

• Design and implement transformations across the Bronze ? Silver ? Gold medallion layers, ensuring data is cleansed, conformed, and ready for reporting consumption.

• Map conformed dimensions and fact tables per the IMA DataHub technical specification (v1.2), aligning to the enterprise data model’s defined grain and businessrules

.• Coordinate with the Boomi integration team to validate event schemas, resolve data quality issues, and ensure new event types are properly captured as product activation progresses.

• Support identity resolution data flows from Tilores into the enterprise model, ensuring golden record references are maintained across all conformed dimensions. IMA Technology Modernization Program

2• Validate end-to-end data integrity by building reconciliation checks between source systems (Thought Industries, Chargebee, Business Central) and the enterprise data model.

• Document data lineage, transformation logic, and pipeline configurations to support auditability and knowledge transfer. Required Skills & ExperienceCore Technical Skills

• Microsoft Fabric – hands-on experience with lake houses, notebooks, data pipelines, andthe medallion architecture pattern (Bronze/Silver/Gold).