Data Architect II designing and implementing data solutions for SAP and Microsoft Fabric integration at Sun Chemical. Leading modernization efforts in enterprise data ecosystems with advanced analytics.
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.
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).
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.
Senior Manager leading a team of database engineers to manage CCC's data platform. Overseeing mission - critical applications and collaborating with cross - functional teams in a hybrid environment.
As a Principal Data Architect at Solstice, lead the design and implementation of data architecture solutions. Ensure data integrity, security, and accessibility to meet strategic organizational goals.
Data Platform Specialist overseeing data workflows and enhancing data quality for Stackgini's AI - driven IT solutions. Collaborating with teams to drive improvements and stakeholder support.
Data Engineer designing data pipelines in Python for a major railway industry client. Collaborate with Data Scientists and ensure code quality with agile methodologies.
Senior Data Engineer responsible for building and optimizing data pipelines for banking analytics initiatives. Collaborating with data teams to ensure data quality and readiness for enterprise use.
Senior Data Engineer developing scalable data solutions on Databricks for analytics and operational workloads. Collaborating with cross - functional teams to modernize the data ecosystem.
Data Engineer focused on analytics and data pipeline development for network optimisation. Collaborating with teams to deliver high - quality data solutions with Python and SQL.
Senior Product Manager defining platform capabilities for Data Cloud in Salesforce. Collaborating with R&D teams while shaping product strategy for Data 360 integration.
Senior Data Engineer at Goodwin enhancing data platforms and fostering data - driven culture across teams. Collaborating with IT and Finance on technology solutions and data governance practices.
Director, Data Platform Design and Strategy at MedImpact leading data platform and AI innovations to enhance healthcare services. Overseeing enterprise projects and managing teams to meet strategic goals.