Data Architect - Microsoft Fabric & SAP

Pay Ranges:  $95,000 - $110,000

 

ABOUT THE ORGANIZATION
 

Sun Chemical, a member of the DIC Group, is a leading producer of packaging and graphic solutions, color and display technologies, functional products, electronic materials, and products for the automotive and healthcare industries. Together with DIC, Sun Chemical is continuously working to promote and develop sustainable solutions to exceed customer expectations and better the world around us. With combined annual sales of more than $8.5 billion and 22,000+ employees worldwide, the DIC Group companies support a diverse collection of global customers.
 

Sun Chemical Corporation is a subsidiary of Sun Chemical Group Coöperatief U.A., the Netherlands, and is headquartered in Parsippany, New Jersey, U.S.A. For more information, please visit our website at www.sunchemical.com or connect with us on LinkedIn or Twitter

 

About the Opportunity 

 

Are you ready to lead transformative data architecture initiatives at a global scale?

 

Sun Chemical is seeking an experienced Data Architect II to join our Corporate IT team and drive the modernization of our enterprise data ecosystem. This is a unique opportunity to architect cutting-edge solutions that bridge SAP, Microsoft Fabric, and Power BI, enabling advanced analytics and business intelligence across our organization. 

 

Essential Job Functions:  

 

Solution Architecture & Design 

• Define high-level architecture that enables seamless integration of SAP and additional data sources into the Microsoft Fabric environment, ensuring robust data flow and interoperability. 

• Design and manage Microsoft Fabric workspaces, establishing reliable and efficient connectivity across SAP, Azure, and Fabric components to support unified data access and advanced analytics capabilities. 

• Leverage SAP BTP DataSphere and SAP Analytics Cloud (SAC) to create integrated analytics solutions. 

 

Data Integration & Management 

• Implement data integration into Fabric Lakehouse, Warehouse, and Synapse Engineering. 

• Design and build Azure Data Factory pipelines for data ingestion and transformation.  

• Ensure data security and governance at storage and reporting layers. 

• Oversee batch and incremental data loads, tuning performance to meet SLAs 

 

Reporting & Analytics 

• Develop Power BI semantic layers and maintain Power BI reports, including paginated and interactive dashboards. 

• Support the migration of Cognos solutions into Power BI. 

• Support self-service analytics and ad-hoc reporting for business users. 

 

Technical Leadership 

• Provide expertise and guidance on SAP analytics roadmap (S/4HANA Embedded Analytics, SAP Datasphere, SAP Analytics Cloud). 

• Lead pilot projects and migrations (e.g., Cognos to Power BI, SQL D