Microsoft BI Architect

EY; Johannesburg; On-site; ZAR 60 000 - 100 000; Full time

Job summary

An established industry player is seeking a Senior BI Architect to lead the design and development of cutting-edge business intelligence solutions. This role emphasizes leveraging Microsoft Fabric, requiring a deep understanding of data warehousing and ETL processes. The ideal candidate will translate business needs into technical specifications and create effective BI solutions. Responsibilities include deploying BI solutions, maintaining data analytics platforms, and conducting training sessions for end-users. Join a dynamic team where your expertise will drive innovation and enhance decision-making across the organization.

Qualifications

• Proven experience as a BI Architect or similar role.
• Strong understanding of data warehousing and ETL processes.
• Knowledge of cloud platforms, particularly Microsoft Azure.

Responsibilities

• Design and deploy BI solutions using Microsoft Fabric.
• Maintain and support data analytics platforms.
• Conduct training sessions for end-users on BI tools.

Skills

Data Warehousing

ETL Processes

Data Modeling

Power BI

SQL

Microsoft Azure

Analytical Skills

Problem-Solving Skills

Communication Skills

Collaboration Skills

Education

Bachelor's degree in Computer Science

Bachelor's degree in Information Technology

Tools

Azure Synapse Analytics

Azure Data Factory

Azure Databricks

Job description

The Senior BI Architect will play a pivotal role in designing, developing, and managing innovative business intelligence (BI) solutions with a strong emphasis on leveraging Microsoft Fabric. This role requires a deep understanding of data warehousing, ETL (Extract, Transform, Load) processes, data modeling, and the Microsoft Fabric ecosystem. The ideal candidate will translate business needs into technical specifications, create effective BI solutions, and drive the utilization of information management systems.

Key Responsibilities:

Design, develop, and deploy business intelligence solutions using Microsoft Fabric.

Translate business needs into technical specifications.

Design, build, and deploy BI solutions (e.g., reporting tools) with Microsoft Fabric components such as Azure Synapse Analytics, Azure Data Factory, Azure Databricks, and Power BI.

Maintain and support data analytics platforms.

Create tools to store data (e.g., OLAP cubes).

Conduct unit testing and troubleshooting.

Evaluate and improve existing BI systems.

Collaborate with teams to integrate systems.

Develop and execute database queries and conduct analyses.

Ensure the robustness and reliability of the BI solution during development, testing, and maintenance.

Document all aspects of the BI system as a reference for future upgrades and maintenance.

Address any issues or concerns related to the BI solution raised by the users.

Stay updated on the latest trends and technologies in the BI field, particularly within the Microsoft ecosystem.

Conduct training sessions to educate end-users on how to use the BI tools effectively.

Qualifications:

Bachelor's degree in Computer Science, Information Technology, or a related field.

Proven experience as a BI Architect or similar role.

Strong understanding of data warehousing, ETL processes, and data modeling.

Proficiency in BI tools such as Power BI, and experience with Microsoft Fabric components.

Experience with SQL and database management.

Excellent analytical and problem-solving skills.

Strong communication and collaboration skills.

Ability to work independently and as part of a team.

Knowledge of cloud platforms and services, particularly Microsoft Azure.

Preferred Certifications:

Certified Business Intelligence Professional (CBIP)

Microsoft Certified: Data Analyst Associate

Microsoft Certified: Azure Data Engineer Associate

Microsoft Certified: Azure Solutions Architect Expert

The Senior BI Architect will play a pivotal role in designing, developing, and managing innovative business intelligence (BI) solutions with a strong emphasis on leveraging Microsoft Fabric. This role requires a deep understanding of data warehousing, ETL (Extract, Transform, Load) processes, data modeling, and the Microsoft Fabric ecosystem. The ideal candidate will translate business needs into technical specifications, create effective BI solutions, and drive the utilization of information management systems.

Key Responsibilities:

Design, develop, and deploy business intelligence solutions using Microsoft Fabric.

Translate business needs into technical specifications.

Design, build, and deploy BI solutions (e.g., reporting tools) with Microsoft Fabric components such as Azure Synapse Analytics, Azure Data Factory, Azure Databricks, and Power BI.

Maintain and support data analytics platforms.

Create tools to store data (e.g., OLAP cubes).

Conduct unit testing and troubleshooting.

Evaluate and improve existing BI systems.

Collaborate with teams to integrate systems.

Develop and execute database queries and conduct analyses.

Ensure the robustness and reliability of the BI solution during development, testing, and maintenance.

Document all aspects of the BI system as a reference for future upgrades and maintenance.

Address any issues or concerns related to the BI solution raised by the users.

Stay updated on the latest trends and technologies in the BI field, particularly within the Microsoft ecosystem.

Conduct training sessions to educate end-users on how to use the BI tools effectively.

Qualifications:

Bachelor's degree in Computer Science, Information Technology, or a related field.

Proven experience as a BI Architect or similar role.

Strong understanding of data warehousing, ETL processes, and data modeling.

Proficiency in BI tools such as Power BI, and experience with Microsoft Fabric components.

Experience with SQL and database management.

Excellent analytical and problem-solving skills.

Strong communication and collaboration skills.

Ability to work independently and as part of a team.

Knowledge of cloud platforms and services, particularly Microsoft Azure.

Preferred Certifications:

Certified Business Intelligence Professional (CBIP)

Microsoft Certified: Data Analyst Associate

Microsoft Certified: Azure Data Engineer Associate

Microsoft Certified: Azure Solutions Architect Expert