Data Architect - Microsoft Fabric & SAP

Sun Chemical Corporation; Cincinnati (OH); On-site; USD 95,000 - 110,000; Full time

Benefits offered by this job

Medical benefits

401(k) with match

Paid time off

Job summary

Sun Chemical Corporation is seeking a Data Architect II to lead modernization of our data ecosystem. You will architect SAP integration with Microsoft Fabric, manage data platforms, and develop Power BI reports to enable enterprise analytics. Collaboration with Accenture and stakeholders across business lines is essential.

The role requires 5 years IT experience, 2+ years with Fabric, and strong data governance skills. Bachelor’s degree expected; on-site work in corporate IT environment.

Qualifications

• Bachelor's degree in Computer Science or related field.
• 5 years progressive IT experience with 2+ years using Microsoft Fabric.
• Experience architecting SAP, Fabric, and Power BI solutions.

Responsibilities

• Define architecture for SAP integration into Microsoft Fabric.
• Design and manage Fabric workspaces for analytics.
• Develop Power BI semantic layers and dashboards.
• Lead pilot projects and migrations with stakeholders.

Skills

Data architecture

Leadership

Stakeholder comms

SQL / PySpark

Education

Bachelor's degree in Computer Science

Tools

SAP (ECC/S/4HANA)

Microsoft Fabric

Power BI

Azure Data Factory

Azure Synapse

Job description

Pay Ranges

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 Cooperatief 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.

Data Integration & Management

• 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.

Reporting & Analytics

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

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 DW to Fabric One Lake).

• Collaborate with stakeholders across all business levels and our Accenture partners.

Education & Qualifications

• Bachelor's degree in Computer Science or a related field required.

Technical Experience

• 5 years of progressive IT experience, with at least 2 years hands-on with Microsoft Fabric (Workspace, Lakehouse, Warehouse, and Data Engineering).
• Proven expertise architecting solutions with SAP (ECC and S/4HANA), Microsoft Fabric, and Power BI, including understanding of SAP data structures and their integration within enterprise analytics platforms.
• Strong proficiency in Azure Data Factory, Synapse, and cloud data services.
• Expert-level skills in data modeling, ETL processes, and semantic layer design.
• Advanced programming in SQL (T-SQL/Spark SQL), Python, and PySpark.
• Hands-on experience with Power BI (Desktop and Service), DAX, Power Query, and performance tuning.
• Hands-on experience with Azure Log Analytics, Microsoft Purview, and CI/CD pipelines via Azure DevOps.
• Solid understanding of data governance, security, and compliance within enterprise environments.

Skills & Competencies

• Ability to translate complex technical concepts for non-technical business stakeholders and lead cross-functional teams effectively.
• Advanced project management skills, including requirements gathering, technical specification writing, effort estimation, resource planning, and risk management to ensure successful project delivery.
• Strong communication and facilitation skills, with experience coordinating and leading meetings with senior business stakeholders.
• Highly organized with the ability to manage multiple concurrent projects while maintaining clear and consistent communication with all stakeholders on progress and priorities.

Benefits

We offer a range of market-competitive total rewards that include merit increases, paid holidays, Paid Time Off, medical, dental, vision, short and long term disability benefits, 401(k) + match and life insurance. Eligibility of benefit timing may vary.

Equal Employment Opportunity

It is Sun's policy that applicants for employment are recruited, selected, and hired on the basis of individual merit and ability with respect to the position being filled. Sun prohibits discrimination on the basis of race, color, religion, creed, national origin, age, gender, sexual orientation, gender identity, marital or veteran status, disability, or any other status protected by applicable law.

Employment agencies are an important component of our talent acquisition strategy, and we value the partnerships we have built with our preferred vendors. We will not accept unsolicited resumes from employment agencies for any employment opportunity. All resumes submitted by search firms to any employee at Sun Chemical or directly to hiring managers in any form without a signed contract on file, and search engagement for that position, will be deemed unsolicited in nature, and no fee will be paid in the event the candidate is hired as a result of the referral or through other means. Additionally, any resume submitted without a contract in place will be considered property of Sun Chemical and no fees will be paid to the agency if the candidate is hired.

Note: The base pay range listed is a good-faith estimate of what Sun Chemical may offer to new hires for this position. Actual compensation may vary based on a variety of factors, including KSAs, relevant experience, education, certifications, and alignment with the minimum job qualifications. Additional considerations may include prevailing wages in the work location and internal equity within Sun Chemical. #ID23