My experience from Business Intelligence for the last 15 years involves mainly

• Microsoft SQL Suite  - SQL, SSIS, SSRS, SSAS [olap/tabular], PowerBI
  I have designed and maintained a complete data warehouse from scratch including both olap an tabular cubes.
  Back in the days, all reports were built in Reporting Services (called Paginated Reports now a days).
  But PowerBI is really the tools everyone likes to use now.
  
  
• Data Warehousing in SQL/Azure Synapse environments but sources from all possible places
  In my current role as BI-developer I am maintaining and extending an enterprise data wahouse with more than 15 ERPs flowing it's data to the DW in SQL Synapse (formerly SQL Data Warehouse).
  
  
• Data Vault 2.0
  The last project involves modeling all source data into a Data Vault 2.0 which feels like a fresh solution that is close to only inserts to the database.
  
  
• Star schema marts
  Consumers like to pull their data from start schemas which is more or less self described. And a good choice to provide self service within the business.
  
  
• Automation Tools for ETL generation (Bimlflex, Darwin) even though I've created bunch of solutions manually too
  
  
• Azure Data Factory
  ADF is a pretty good engine to move data in the azure envionment and allows for a streight forward CI/CD using DevOps.
  
  
• Logic Apps
  When sending messages between BI-environments in the cloud Logic App is a streigth forward and pretty easy tool to setup APIs in.
  
  
• CI/CD in Devops (release pipelines)
  Development in dev-env, tests in test-env then deploy to production is the only way to run your continous development
  
  
• Currently evaulating Microsoft Fabric using delta-parquet for a replacement of the current Azure Synapse DW

Contact me if need any help of want to discuss opportunities.