SSAS Cubes Developer - Johannesburg, South Africa - PBT Group

Description

PBT Group, a leading provider of Data and Analytics services, seeks a proficient SSAS Cubes Developer with a robust background in Microsoft BI stack technologies. The ideal candidate will play a pivotal role in designing, developing, and maintaining Business Intelligence solutions, particularly focusing on SSAS (OLAP Cubes) along with other components such as SSIS, SSRS, and Power BI.

Duties:

• Design, develop, and maintain multidimensional and tabular models using SQL Server Analysis Services (SSAS), collaborating with stakeholders to translate requirements into efficient cube designs.
• Create and optimize MDX/DAX queries for data retrieval and analysis, implementing security measures for data privacy and integrity within SSAS cubes.
• Perform cube processing, monitoring, and optimization for performance enhancement, troubleshooting and resolving SSAS cube and data model issues.
• Develop and maintain documentation for SSAS cube design, processes, and best practices, staying updated with industry trends and advancements in SSAS technology.
• Utilize the Microsoft BI stack, including MS SQL Server, SSIS, SSRS, and Power BI, to design, develop, and maintain Business Intelligence solutions.
• Implement ETL processes using SSIS to ensure efficient data flow and integrity, and perform data warehouse design, maintenance, and re-architecture as required.
• Lead projects in implementing new BI software tools and systems, analyzing data to drive improvements in key business metrics.
• Implement data structures adhering to best practices, facilitate data conversions, imports, and exports, and enforce data governance.
• Collaborate with software architects to ensure adherence to architectural guidelines and compatibility with other environments.
• Work with cross-functional teams to ensure solutions meet application requirements and performance goals, considering compatibility, usability, reliability, performance, and security aspects.
• Demonstrate initiative by acquiring and implementing new knowledge and skills, contributing to continuous improvement within the team and wider group, and enhancing product and system performance while adhering to industry best practices.

Skills and Experience Required:

• Proven experience as an SSAS Cubes Developer or similar role, with proficiency in SQL Server, SSAS, MDX, DAX, and data modeling techniques.
• Strong understanding of multidimensional and tabular cube design concepts, with the ability to collaborate effectively in a team environment and communicate with stakeholders.
• Experience in cube optimization, performance tuning, and troubleshooting, along with knowledge of data warehousing concepts and ETL processes.
• Familiarity with data visualization tools like Power BI or Tableau is advantageous, demonstrating excellent problem-solving skills and attention to detail.
• 5-6 years of experience in a BI development environment, with proficiency in T-SQL, SSIS, Data Warehousing, SSAS, and Power BI.
• Extensive experience in authoring OLAP cubes, writing MDX in Microsoft Analysis Services, and strong proficiency in SSRS Development.
• Advanced knowledge of T-SQL, including dynamic T-SQL, multi-threading, and performance optimization, along with practical experience with SQL Server Database Engine, MS SSIS ETL software, MS SSAS OLAP software, and MS Visual Studio Data Tools.
• Experience in database design, normalization of data structures, and familiarity with SDLC methodologies.
• Ability to create advanced data models, analyse data patterns, and design meaningful reports and dashboards.
• In-depth understanding of database management systems, online analytical processing, ETL frameworks, Kimball Data Warehouse Lifecycle, and demonstrated experience in creating and maintaining multidimensional cubes using SSAS.

Qualifications/ Certification:

• A degree in Computer Science, Information Systems, Business Administration, Commerce, or equivalent.

* In order to comply with the POPI Act, for future career opportunities, we require your permission to maintain your personal details on our database. By completing and returning this form you give PBT your consent