This Job Vacancy has Expired!

BI Solution Architect

Gazelle Global Consulting

Posted on Jan 28, 2021 by Gazelle Global Consulting

Stockholm, Sweden
Immediate Start
Annual Salary

BI Solution Architect

  • Legacy BI/DW Competencies (SSIS/SSRS/SSAS/SQLserver DB, MDS, MPP etc)

  • Modern Azure Data Lake Competencies (Azure Data Factory, Databricks, ADLS Gen2, AML etc)


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)

Competencies and Experience: Following are expected competencies and responsibilities:

  • Solution Experience in Azure Data Lake (Azure Data Factory, Databricks, ADLS, AML etc)

  • Solution Experience in SSIS, SSAS (Tabular), SSRS, Power BI, MS SQL Server

  • Ability to analyse existing Legacy BI/DW Components and map/migrate to Azure Data Lake components.

  • Design Batch and Streaming Data Integration from Kafka

  • Design ingestion, curation and data consumption patterns in Data Lake

  • Expand ETL/ELT processes to load more data to DW/DataLake

  • Create integrations to production systems using component development and Azure products to load data to DW/DataLake

  • Expand existing DW/DB solution with more information

  • Expand reference data in MDS (Master Data) to manage more information.

  • Optimize existing solution for better performance

  • Use Azure Synapse and some SQL Server

  • Experience of working with MPP environments is meritorious

Agile: The assignment is performed in a team with agile development methodology according to SCRUM in a SAFe context. The project will work on short frequent deliveries, where the end result is a solution with higher data quality and richer information model, as well as improved performance in both data loads and data recovery.

  • Devops: Experience in Devops way of working, Agile Testing methods & Automation Frameworks

  • Good to have: Microsoft Azure certifications in Azure Data Lake

Reference: 1073600037

Set up alerts to get notified of new vacancies.