SSAS Cubes Developer

Found in: Talent ZA C2 - 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

    Found in: Whatjobs ZA C2 - 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...

  • SSAS Cubes Developer

    Found in: Talent ZA 2A C2 - 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...

  • Data Management Delivery Lead

    6 days ago

    Johannesburg, South Africa People Source Full time

    Experience designing, building and maintaining data processing systems. Database design, data modelling and data warehousing experience. Good understanding of SSIS, SSRS and SSAS. Strong SQL skills. Contribute to the design, build and implementation of mapping and ETL Programming from source systems to the data warehouse. Provide world class services in the...

  • Business Development Lead

    Found in: beBee S ZA - 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...

  • Director HR Operations Ssa

    6 days 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,...

  • Demand Planner Ssa

    6 days ago

    Johannesburg, South Africa Givaudan Full time

    Step into our world of creativity and joy! Demand Planner SSA - Join us and celebrate the beauty of human experience. Create for happier, healthier lives, with love for nature. Together, with kindness and humility, we deliver food innovations, craft inspired fragrances and develop beauty and wellbeing solutions that make people look and feel good. There’s...

  • Visual Merchandising

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

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

  • Jpm Payments

    2 weeks ago

    Johannesburg, South Africa JPMorgan Chase Bank, N.A. Full time

    The SSA FIG Sales role is part of the MEA FIG Sales coverage team looking after Financial Institutions and Non-Bank Financial Institutions based in Johannesburg. Responsibilities include managing existing client relationships, building new business and penetrating new clients and segments through the Payments value proposition and product suite. The team...

  • Senior Financial Officer

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

  • Senior Financial Officer- Digital

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

  • BI Developer

    Found in: Talent ZA 2A C2 - 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

    Found in: Whatjobs ZA C2 - 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...

  • BI Developer

    Found in: Adzuna ZA B C2 - 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 Solutions Architect

    6 days ago

    Johannesburg, South Africa PBT Group Full time

    Analysis and Communication Skills - Data gathering, research and analytical abilities so as to develop insightful conclusions and generate solutions to address user needs. - Conceptualize and design solutions. **Duties**: - The BI SA must understand the entire BI landscape to ensure that solutions are implemented in a sustainable manner. - Interact with...

  • Development and integration Specialist

    Found in: beBee S ZA - 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

    Found in: beBee S ZA - 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

    Found in: beBee jobs ZA - 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

    Found in: Whatjobs ZA C2 - 1 week ago

    Johannesburg, South Africa Recru-it 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...

  • Graduate – Data Analytics Developer

    Found in: Adzuna ZA B C2 - 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...