Data Architect-SAP +Dimensional Modeling

Spectral Consultants is currently hiring for a Data Architect role for a leading Global Manufacturing & Consumer Goods Industry organization. We are looking for someone with strong Dimensional Data Modeling expertise and experience designing cloud data warehouses on platforms like Snowflake, Amazon Redshift, or Azure Synapse Analytics.The role involves building data models from SAP-based data sources such as SAP S/4HANA, Salesforce, and Workday, along with exposure to Microsoft Power BI.Experience:- 6–9 YearsRole Type:- Individual Contributor (Hands-on Architecture)Role Overview:-This is a hands-on Data Architect role with architectural oversight responsibilities. The selected candidate will design and implement a custom enterprise Data Warehouse built on SAP ECC / SAP S/4 data sources and integrated into modern Cloud Data Warehouse platforms.Key Responsibilities:-Design and implement scalable Data Warehouse architectureBuild dimensional and transactional data modelsExtract and transform SAP ECC / SAP S/4 data into cloud warehouse platformsEnsure optimized, high-performance reporting structuresCollaborate with business teams across Sales, Finance, Controlling & Supply ChainProvide architectural direction to a small team of consultantsMust-Have Skills:-Strong expertise in Data Modeling (Dimensional & Transactional)Experience designing & implementing a custom Data Warehouse using SAP ECC / S/4 dataDeep understanding of SAP tables, columns & relationships (SD, Finance, Controlling, Supply Chain)Hands-on experience with Cloud Data Warehouse platforms (Snowflake / Redshift / Synapse)Experience with BI tools (Power BI / Tableau / Qlik / BOBJ)Good-to-Have:-Experience with SAP BWExposure to AWS / Azure / GCPGenAI exposure (Differentiator)

Apply Now