BI Solution Architect

Datacentrix; Johannesburg; On-site; ZAR 900,000 - 1,400,000; Full time

Job summary

Datacentrix, through Managed Talent Solutions, seeks a BI Solution Architect in Johannesburg to design, develop, and implement Power BI solutions aligning with analytics needs. You will gather requirements, model data, create ETL processes, and ensure data accuracy.

The role requires expertise in Azure Data Factory, SSMS/Azure Data Studio, SQL, DAX, and JSON, with experience in tabular modelling and Dynamics 365.

Qualifications

• Matric and degree in IT or business management.
• Experience designing data models for data warehouses or data marts.
• In-depth ETL knowledge with ADF or SSIS.
• Familiarity with Kimbell methodology in BI development.
• Tabular modelling技能.
• Experience with Microsoft Dynamics 365.

Responsibilities

• Extract and transform data using ETL to prepare it for analysis.
• Create and maintain ETL processes for data warehouse loading.
• Architect, design, and develop complex SQL queries from multiple sources.
• Use dimensional modelling to create dimensions and facts for Power BI models.
• Design, develop, and implement robust data models for analytics.
• Leverage DAX for Power BI measures.
• Enforce BI standards and stay updated with Azure/Power Platform releases.
• Monitor BI performance for maximum efficiency and availability.
• Build interactive Power BI reports leveraging tabular models.
• Manage online Power BI service for reports, dashboards and datasets.
• Collaborate with stakeholders to gather business requirements.
• Conduct data profiling to ensure accuracy and consistency.
• Collaborate with IT teams to integrate BI with enterprise systems.
• Conduct end-user training on BI capabilities.
• Understand key business processes for BI development.
• Evaluate new technologies to improve BI architecture and performance.
• Create business efficiency through Power Apps, Power Automate, and Power BI.

Skills

Tabular modelling

DAX language

Power BI

Azure Data Factory

SQL

JSON

ETL processes

Data modelling

Education

Matric

Degree in Information Technology or Business Management

Tools

Power BI

SSMS/Azure Data Studio

Microsoft Dynamics 365

SQL

JSON

Azure Data Factory

Job description

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:

• Azure Data Factory
• Power BI
• SSMS / Azure Data Studio
• 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:

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

Responsibilities:

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