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

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

  • Payments Head

    4 weeks ago

    Johannesburg, South Africa Citi Full time

    The Payments business is a key strength and differentiator for Citi, given the significant depth of the branch network and years of operating experience, many of them exceeding 100+ years. The Payments business intermediates and processes flows generated by Corporates, Banks, Financial Institutions and Governments. The depth of local operations coupled with...

  • SASS Developer

    1 day ago

    Johannesburg, South Africa Adzuna ZA B C2 Full time

    We are seeking a talented SASS Developer with strong experience in cubes development to join our dynamic team. As a SASS Developer, you will play a crucial role in the design, development, and maintenance of our bank's analytics and reporting systems. Your expertise in SASS (Syntactically Awesome Style Sheets) and cubes will contribute to enhancing the...

  • SASS Developer

    1 day ago

    Johannesburg, South Africa Deka Minas Pty Ltd Full time

    We are seeking a talented SASS Developer with strong experience in cubes development to join our dynamic team. As a SASS Developer, you will play a crucial role in the design, development, and maintenance of our bank's analytics and reporting systems. Your expertise in SASS (Syntactically Awesome Style Sheets) and cubes will contribute to enhancing the...

  • SASS Developer

    1 day ago

    Johannesburg, South Africa Deka Minas Pty Ltd Full time

    We are seeking a talented SASS Developer with strong experience in cubes development to join our dynamic team. As a SASS Developer, you will play a crucial role in the design, development, and maintenance of our bank's analytics and reporting systems. Your expertise in SASS (Syntactically Awesome Style Sheets) and cubes will contribute to enhancing the...

  • Senior Specialist: Compensation

    1 month ago

    Johannesburg, South Africa Recruitment Matters Africa Full time

    Our client is looking for a Senior Specialist: In compensation & Benefits to join their team. Implement and maintain effective the company Compensation and Benefits programs and plans in alignment with the overall global and regional the companies HR strategy and corporate company guidelines. Conduct job evaluation, C&B analysis and market benchmarking to...

  • Senior Specialist Compensation and Benefits Ssa

    1 month ago

    Johannesburg, South Africa DHL Full time

    **IT’S NOT JUST AN OPPORTUNITY TO GET ON THE CAREER LADDER.** **IT’S AN OPPORTUNITY TO HELP THE WORLD GET ON TOGETHER** Why do people call us the world’s most international company? Is it because we operate in more countries than any other logistics provider? Is it because we invented cross border shipping over 45 years ago? Or is it, perhaps,...

  • Head of Procurement, Ssa

    1 month ago

    Johannesburg, South Africa Mondelēz International Full time

    **Job Description**: **Are You Ready to Make It Happen at Mondelēz International?** **Join our Mission to Lead the Future of Snacking. Make It Matter.** In this role, you own the procurement agenda in your business unit and are the single point of contact for the business unit’s leadership team, which works to understand the business’ needs and...

  • Manager First Choice Ssa

    1 month ago

    Johannesburg, South Africa DHL Full time

    **IT’S NOT JUST AN OPPORTUNITY TO GET ON THE CAREER LADDER.** **IT’S AN OPPORTUNITY TO HELP THE WORLD GET ON TOGETHER** Why do people call us the world’s most international company? Is it because we operate in more countries than any other logistics provider? Is it because we invented cross border shipping over 45 years ago? Or is it, perhaps,...

  • Visual Merchandising

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

  • Sales Lead

    5 days ago

    Johannesburg, South Africa Salesworx Full time

    Job DescriptionJob Summary:Based in Johannesburg, the Sales Lead will be responsible for identifying, evaluating, and executing strategic business opportunities that drive growth, profitability, and market share with a focus on Peritoneal Dialysis and Acute Therapies. This includes collaboration with cross-functional teams, including sales, marketing,...

  • Sales Manager South Africa and Ssa

    1 month ago

    Johannesburg, South Africa Fempower Personnel Full time

    As a regional sales manager in the electrical industry, your role is crucial in driving sales and achieving revenue targets within your designated region. Your responsibilities typically include: - Sales Strategy and Planning: Develop and implement effective sales strategies, plans, and objectives for your region in alignment with the overall organizational...

  • Regional Business Director SSA: Polymers

    2 weeks 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

    2 weeks 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

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

  • Director - B2B Acceptance Ssa

    1 month ago

    Johannesburg, South Africa Mastercard Full time

    Our Purpose We work to connect and power an inclusive, digital economy that benefits everyone, everywhere by making transactions safe, simple, smart and accessible. Using secure data and networks, partnerships and passion, our innovations and solutions help individuals, financial institutions, governments and businesses realize their greatest potential. Our...

  • Sales Lead

    6 days ago

    Johannesburg, South Africa Salesworx Full time

    Job Summary:Based in Johannesburg, the Sales Lead will be responsible for identifying, evaluating, and executing strategic business opportunities that drive growth, profitability, and market share with a focus on Peritoneal Dialysis and Acute Therapies. This includes collaboration with cross-functional teams, including sales, marketing, medical and...

  • Sales Lead

    6 days ago

    Johannesburg, South Africa Salesworx Full time

    Job DescriptionJob Summary:Based in Johannesburg, the Sales Lead will be responsible for identifying, evaluating, and executing strategic business opportunities that drive growth, profitability, and market share with a focus on Peritoneal Dialysis and Acute Therapies. This includes collaboration with cross-functional teams, including sales, marketing,...