Sun Chemical

Senior Data Architect – Microsoft Fabric, SAP

Sun Chemical

full-time

Posted on:

Location Type: Hybrid

Location: Cincinnati • Ohio • United States

Visit company website

Explore more

✨ AI Apply
Apply

Job Level

Senior

Tech Stack

AzureCloudCognosETLPySparkPythonSparkSQL

About the role

  • 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.
Benefits
  • merit increases
  • paid holidays
  • Paid Time Off
  • medical
  • dental
  • vision
  • short and long term disability benefits
  • 401(k)+match
  • life insurance
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
Microsoft FabricSAP BTP DataSphereSAP Analytics CloudAzure Data FactorySQLPythonPySparkDAXETL processesdata modelling
Soft Skills
leadershipguidancecommunication