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 robust 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 up-to-date 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:-
Solid 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)