As a Sr. Data Warehouse Architect, this position will require you to participate in all aspects of the project (i.e. planning, architecture, design, development, and deployment) of data warehouse solutions in a modern cloud data platform. ESSENTIAL DUTIES AND RESPONSIBILITIES Work with business users and stakeholders to define and analyze problems and provide an optimal technical solutions. Translate business requirements to technical specifications. Involved in the design and architecture of the entire data platform solution. Create and maintain the design of data ingestion, orchestration, and semantic layer. Design data pipeline and data refresh process as per business requirements. Present architecture and solutions to the executive-level. Adhere to industry best practices in all phases of the design and architecture of the solution. Architecture, Data Warehouse, and BI bull 10 + years of end-to-end design and architecture of enterprise-level data warehouse solutions. bull At least 3-4 recent project role should be of Architects (Not Program ManagerTechnical ManagerSr Developer) bull Should be familiar with Dimensional modeling (Star Schema, Snow Flake Schema) and data warehouse design methodologies (Normalization, De-Normalization, ETL, ELT, BI, Cubes, Self Serv BI, Semantic Layer, Data Access Layer) bull Experience in handling Real-Time Data Ingestion process, Real-Time DW and ETL. bull Industry best-practices in all phases of design and architecture of the solution Azure Data Experience bull 2 + years of experience with Azure data ingestion preparation, data lake architecture design. bull 2 + years of experience with readiness, provisioning, security, and best practices with Azure data platform. bull 3+ years of experience with design and architecture with big data solutions. bull 2 + years of experience with Azure data platform (Azure data factory, Azure Data Lake, Azure SQL DB, Azure DWSynapse). bull 2 + years of experience with Spark, DataBricks. Microsoft ETL and BI bull 5+ years of experience with MS BI stack (SSISSSRSSSAS). bull 3 + years of experience with Power BI, Azure Analysis Services bull Customer-Facing BI experience. - Experience with working with business stakeholders to understand and present the End-User problem statements and translate them into business requirements. Database bull 8+ years of experience with SQL Server, T-SQL, stored procedure development and database optimization, performance tuning.