Sr Data Architect - Microsoft Fabric & SAP

Sun Chemical CorporationCincinnati, OH
1d

About The Position

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.

Requirements

  • Bachelor's degree in Computer Science or a related field required.
  • 5 years of progressive IT experience, with a minimum of 2 years of hands-on experience 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 a strong understanding of SAP data structures, business processes, and their integration within enterprise analytics platforms.
  • Strong proficiency in Azure Data Factory, Synapse, and cloud data services.
  • Expert-level skills in data modelling, ETL processes, and semantic layer design.
  • Advanced programming capabilities 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.
  • 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 organised with the ability to manage multiple concurrent projects while maintaining clear and consistent communication with all stakeholders on progress and priorities.

Responsibilities

  • 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.
  • 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
  • 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.
  • 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 OneLake).
  • Collaborate with stakeholders across all business levels and our Accenture partners

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.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service