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/4

HANA, 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)