MSBI Azure Architect

· Expert knowledge of Microsoft Business Intelligence stack including SSIS, SSRS and SSAS/Power BI.

· Experience with SSIS ETL tools including building and optimizing big data pipelines and data sets

· Experience in the building end to end data warehouse and BI projects.

· Experience using CSV, XML, JSON, EDI, or other data schema formats

· Experience in the Azure Data Engineering environment using Databricks, Datalake, Delta Lake, Azure Storage, etc.

· Experience with Spark API and Python

· Ability to write efficient SQL statements and optimization.

Must have -

- MSBI (SSIS, SSRS, SSAS, Power BI)

- TSQL and DAX

- Azure SQL, ADF

Prefer to have

- Spark

- Python