BI Solution Architect

There are multiple Data Applications existing within customers application landscape (Legacy BI Datawarehouses and a Modern Azure Data Lake residing on Azure Cloud)
Legacy BI/DW Applications manage production data and includes large amounts of data with daily loads of millions of transactions daily with storage and presentation of billions of transactions. The Legacy BI/DW Applications consists of the following components mostly:
. ETL/ELT - SQL Server Integration Services
. DB - SQL Server and Azure Synapse (Azure Data Warehouse)
. Cubes - Azure Analysis Services
. Reference data - SQL Server Master Data Services (MDS)
. SSRS reports
Data Lake is modern data platform on Azure cloud where new Applications/Transformations are delivered. Some of the existing Legacy DW Applications will be consolidated and migrated to new Data Lake. (Azure Data Factory, Databricks, ADLS Gen2, AML, Power BI, Azure Devops etc)