SSAS Cubes Developer

2 weeks ago

Johannesburg, South Africa Adzuna ZA B C2 Full time

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

  • SSAS Cubes Developer

    3 weeks ago

    Johannesburg, South Africa PBT Group Full time

    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...

  • SSAS Cubes Developer

    3 weeks ago

    Johannesburg, South Africa PBT Group Full time

    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...

  • SSAS Cubes Developer

    1 week ago

    Johannesburg, South Africa PBT Group Full time

    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...

  • Business Development Lead

    2 weeks ago

    Gauteng, Johannesburg, South Africa Baxter International Inc. Full time

    Baxter International Inc.’s job vacancy, Career and Recruitment Job title : Business Development Lead – SADC & SSA jobs in Gauteng Job Location : Gauteng, Johannesburg Deadline : May 22, 2024 Quick Recommended Links Jobs by Location Job by industries Key Responsibilities: Develop and execute business development strategies to achieve company growth...

  • Visual Merchandising

    3 days ago

    Johannesburg, South Africa The Estée Lauder Companies Full time

    **About The Estée Lauder Companies Inc.** The Estée Lauder Companies Inc. is one of the world’s leading manufacturers, marketers, and sellers of quality skin care, makeup, fragrance, and hair care products. The company’s products are sold in approximately 150 countries and territories under brand names including: Estée Lauder, Aramis, Clinique, Lab...

  • Marketing Manager, Ssa

    4 days ago

    Johannesburg, South Africa Trend Micro Full time

    When you join Trend, you become part of a unique and diverse global family and you get to work towards a world safe for exchanging digital information. Employee at Trend Micro When you join Trend, you become part of a unique global and diverse family. Here, thousands of “Trenders” spread across 65 countries are passionate about doing the right thing to...

  • Senior Financial Officer- Digital

    5 days ago

    Johannesburg, South Africa Six Sense Full time

    Gauteng, JHB - Central A well-established business is seeking a Senior financial Officer - digital. To gather, analyse, produce, maintain, develop and report reliable financial and non-financial management information to support the requirements of the RBB digital business as well as the 4 Cubed reporting tool. **Essential Qualifications** - CASA with...

  • Senior Financial Officer

    6 days ago

    Johannesburg, South Africa Unique Personnel Full time

    **Job Number** - 68484 **Job Type** - Permanent **Job Title** - Senior financial Officer **Computer Skills** - Microsoft **Industry** - Finance, Insurance & Bus Services **City** - Johannesburg **Province** - Gauteng - Gather, analyse, produce, maintain, develop and report reliable financial and non-financial management - information to support the...

  • Regional Business Director SSA: Polymers

    22 hours ago

    Johannesburg, South Africa Brenntag Full time

    Our team in Pomona, Johannesburg currently has an opening for a  Regional Business Director SSA: Polymers & Rubber Thesuccessful candidate will be accountable to drive top line growth by managingcustomer relationships and sales execution in the Sub-Saharan Africa Region. YOUR ROLE & RESPONSIBILITIES Ensure sales targets are met by...

  • Regional Business Director SSA: Beauty

    21 hours ago

    Johannesburg, South Africa Brenntag Full time

    Our team in Pomona, Johannesburg  currently has an opening for a Regional Business Director SSA: Beauty & Care Thesuccessful candidate will be accountable to drive top line growth by managingcustomer relationships and sales execution in the Sub-Saharan Africa Region. YOUR ROLE & RESPONSIBILITIES Ensure sales targets are met by...

  • BI Developer

    2 weeks ago

    Johannesburg, South Africa Adzuna ZA B C2 Full time

    We are seeking a talented and motivated BI Developer to join our dynamic team. As a BI Developer, you will play a key role in the design, development, and maintenance of our business intelligence solutions. If you have a passion for data, analytics, and business intelligence, along with strong technical skills, we encourage you to apply.What you’ll...

  • BI Developer

    3 weeks ago

    Johannesburg, South Africa IOCO Full time

    We are seeking a talented and motivated BI Developer to join our dynamic team. As a BI Developer, you will play a key role in the design, development, and maintenance of our business intelligence solutions. If you have a passion for data, analytics, and business intelligence, along with strong technical skills, we encourage you to apply.What you’ll...

  • BI Developer

    1 week ago

    Johannesburg, South Africa IOCO Full time

    We are seeking a talented and motivated BI Developer to join our dynamic team. As a BI Developer, you will play a key role in the design, development, and maintenance of our business intelligence solutions. If you have a passion for data, analytics, and business intelligence, along with strong technical skills, we encourage you to apply. What you’ll...

  • Development and integration Specialist

    3 weeks ago

    Gauteng, Johannesburg, South Africa Sanlam Group Full time

    Sanlam Group’s job vacancy, Career and Recruitment Job title : Development and integration Specialist jobs in Gauteng Job Location : Gauteng, Johannesburg Deadline : April 19, 2024 Quick Recommended Links Jobs by Location Job by industries What will you do? A Technical resource with extensive Design & Development experience in the .Net software stack,...

  • SAP BW Developer

    3 weeks ago

    Johannesburg, South Africa SabenzaIT Full time

    🌟 Join Our Team as a Senior SAP BW/4HANA Developer! 🌟 Are you an accomplished SAP BW/4HANA Developer with a proven track record of successful end-to-end implementations? We're seeking a talented individual to play a pivotal role in driving our SAP initiatives forward. If you're passionate about leveraging cutting-edge technology to streamline business...

  • SAP BW Developer

    2 weeks ago

    Johannesburg, Gauteng, South Africa SabenzaIT Full time

    Join Our Team as a Senior SAP BW/4HANA Developer Are you an accomplished SAP BW/4HANA Developer with a proven track record of successful end-to-end implementations? We're seeking a talented individual to play a pivotal role in driving our SAP initiatives forward. If you're passionate about leveraging cutting-edge technology to streamline business processes...

  • Graduate – Data Analytics Developer

    2 weeks ago

    Johannesburg, South Africa Adzuna ZA B C2 Full time

    Activities will include:Designing and building multidimensional OLAP cubes.Development of business rules using the native TM1 rules engine.Creation of ETL processes to import and extract data from various sources.Develop user interfaces for capturing and reviewing data.Design and deploy reports including data tables, graphs and others offering analytical...

  • Junior To Intermediate Power BI Developer

    2 weeks ago

    Johannesburg, South Africa Adzuna ZA B C2 Full time

    ESSENTIAL DUTIES AND RESPONSIBILITIES:Power BI development and administration.Microsoft Tabular modellingDeveloping visual reports, dashboards, and KPI scorecards using Power BI desktop.Ability to tell stories using Power BI visualisa?onsConnec?ng to data sources, impor?ng data, and transforming data for Business Intelligence.Excellent in analytical thinking...

  • Junior To Intermediate Power BI Developer

    3 weeks ago

    Johannesburg, South Africa EQ Plus Full time

    ESSENTIAL DUTIES AND RESPONSIBILITIES:Power BI development and administration.Microsoft Tabular modellingDeveloping visual reports, dashboards, and KPI scorecards using Power BI desktop.Ability to tell stories using Power BI visualisa?onsConnec?ng to data sources, impor?ng data, and transforming data for Business Intelligence.Excellent in analytical thinking...

  • Junior To Intermediate Power BI Developer

    1 week ago

    Johannesburg, South Africa EQ Plus Full time

    ESSENTIAL DUTIES AND RESPONSIBILITIES: Power BI development and administration. Microsoft Tabular modelling Developing visual reports, dashboards, and KPI scorecards using Power BI desktop. Ability to tell stories using Power BI visualisa?ons Connec?ng to data sources, impor?ng data, and transforming data for Business Intelligence. Excellent in analytical...