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 Years

Role 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 architecture - Build dimensional and transactional data models - Extract and transform SAP ECC / SAP S/4 data into cloud warehouse platforms - Ensure optimized, high-performance reporting structures - Collaborate with business teams across Sales, Finance, Controlling & Supply Chain - Provide architectural direction to a small team of consultants

Must-Have Skills:-

- Strong expertise in Data Modeling (Dimensional & Transactional) - Experience designing & implementing a custom Data Warehouse using SAP ECC / S/4 data - Deep 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 BW - Exposure to AWS / Azure / GCP - GenAI exposure (Differentiator)