BI Solution ArchitectManaged 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:Azure Data FactoryPower BISSMS / Azure Data StudioSQL, DAX, and JSONYou 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:Matric plus Degree in Information Technology or Business ManagementExperience in designing and developing data models for a data warehouse or data martIn-depth understanding of ETL processes and tools, such as ADF or SSISFamiliarity with Kimbell methodology and its application to BI solution developmentTabular modellingMicrosoft Dynamics 365Responsibilities:Responsible for extracting and transforming data from the system and using ETL processes to prepare data for analysisCreate and maintain ETL processes to ensure efficient data extraction, transformation, and loading into the data warehouseArchitect, design, and develop complex SQL queries to extract data from various data sourcesUsing dimensional modelling, create dimensions and facts for use in Power BI tabular data modelsDesign, develop, and implement robust and scalable data models to support analytical and reporting needsExtensive use of DAX language for Power BI measure creationDefine and enforce best practices and standards for BI solution development and stay up to date with Microsoft Azure and Power Platform releasesMonitor and optimize the performance of the BI solution to ensure maximum efficiency and availabilityDesign and build interactive Power BI reports that leverage the tabular models slicing and dicing capabilitiesAdminister and manage the online Power BI data service for Power BI reports, dashboards, and datasetsCollaborate with key stakeholders to gather and understand business requirements for BI solutionsConduct data analysis and profiling to ensure data accuracy, integrity, and consistencyCollaborate with other IT teams to integrate the BI solution with other enterprise systemsConduct training sessions to educate end-users on the capabilities and functionalities of the BI solutionsUnderstand key business processes on which business intelligence will be builtEvaluate and recommend new technologies, tools, and techniques to improve BI solution architecture and performanceCreate business efficiency through the use of Power Apps, Power Automate, and Power BI
#J-18808-Ljbffr