Microsoft BI Architect at Ernst & Young Global Limited (EY)

• 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