BI Solution Architect - Edenvale at Barron

Job Overview:

• We are seeking a highly skilled and experienced BI Solution Architect to join our organization. As a BI Solution Architect, you will be responsible for 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. The ideal candidate should have expertise in SQL, ETL processes, and be familiar with the Kimbell methodology to effectively deliver scalable and reliable BI solutions.

JOB OBJECTIVES

SQL 

• 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

Power BI

• 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 leverages the tabular models slicing and dicing capabilities
• Administer and manage the online Power BI data service for Power BI reports, dashboards and datasets

ERP and Business

• 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

Microsoft Azure

• 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 t

JOB REQUIREMENTS
Experience

• 3-5 years as a BI solution architect or similar
• 3-5 years experience in designing and developing data models for a data warehouse or data mart.

Qualification

• NQF 7 in IT / Business Management 

Knowledge

• 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

Skills

• Azure data factory
• PowerBI
• SSMS / Azure data studio
• SQL, DAX, JSON
• Critical Thinking skills
• Problem solving skills
• Numerical reasoning skills
• Proficient in data analysis, data profiling, and data quality management.
• Business Acumen 
• Strong communication and interpersonal skills to effectively collaborate with stakeholders.

Desirable

• Familiarity with cloud-based BI solutions and platforms (Azure Synapse Analytics) is a plus.
• Relevant certifications, such as Microsoft Certified: Azure Data Engineer/ Microsoft Power BI data analyst / Azure Data Fundamentals / Power BI Data Analyst Certification, are an advantage.