Bi Solution Architect Johannesburg

BI Solution Architect
Managed Talent Solutions, a division within Datacentrix, is looking for a BI Solution Architect for one of their clients based in Johannesburg.

The BI Solution Architect must have experience in:

1. Azure Data Factory
2. Power BI
3. SSMS / Azure Data Studio
4. SQL, DAX, and JSON

You must have proven experience in designing, developing, and implementing Power BI solutions to meet the organization's analytical and reporting needs.

You will collaborate with key stakeholders to gather requirements, design data models, create ETL processes, and ensure data accuracy and efficiency.

Qualifications and Skills Required:

1. Matric plus Degree in Information Technology or Business Management
2. Experience in designing and developing data models for a data warehouse or data mart
3. In-depth understanding of ETL processes and tools, such as ADF or SSIS
4. Familiarity with Kimbell methodology and its application to BI solution development
5. Tabular modelling

Responsibilities:

1. Responsible for extracting and transforming data from the system and using ETL processes to prepare data for analysis
2. Create and maintain ETL processes to ensure efficient data extraction, transformation, and loading into the data warehouse
3. Architect, design, and develop complex SQL queries to extract data from various data sources
4. Using dimensional modelling, create dimensions and facts for use in Power BI tabular data models
5. Design, develop, and implement robust and scalable data models to support analytical and reporting needs
6. Extensive use of DAX language for Power BI measure creation
7. Define and enforce best practices and standards for BI solution development and stay up to date with Microsoft Azure and Power Platform releases
8. Monitor and optimize the performance of the BI solution to ensure maximum efficiency and availability
9. Design and build interactive Power BI reports that leverage the tabular models slicing and dicing capabilities
10. Administer and manage the online Power BI data service for Power BI reports, dashboards, and datasets
11. Collaborate with key stakeholders to gather and understand business requirements for BI solutions
12. Conduct data analysis and profiling to ensure data accuracy, integrity, and consistency
13. Collaborate with other IT teams to integrate the BI solution with other enterprise systems
14. Conduct training sessions to educate end-users on the capabilities and functionalities of the BI solutions
15. Understand key business processes on which business intelligence will be built
16. Evaluate and recommend new technologies, tools, and techniques to improve BI solution architecture and performance
17. Create business efficiency through the use of Power Apps, Power Automate, and Power BI