Senior BI Solution Design Specialist

2 weeks ago


Pretoria, South Africa Mediro ICT Full time

**Key deliverables**:

- BI detailed technical solution architecture, BI data modelling
- Participate in the interpretation of business requirements and functional specifications as provided by the business analyst into BI solution designs.
- Design of the Extract Transfer and Load (ETL) solution to get data into a data warehouse or data mart according to design specifications.
- Design of the Data Lineage models
- Identify and understand data anomalies
- Design of the star-schemas and/or cubes for consumption by the BI toolset.
- Assist in establishing accurate project timelines and development methodology
- Be able to take high-level tasks and break them into detailed actions and tasks to be completed
- Provide input to the overall project planning process by assisting in establishing accurate project timelines actions required and realistic timeframes for completion of those tasks and actions
- Participate in workshops with business owners and stakeholders in respect of clarification of detailed requirements and solutions to those requirement
- Deliver allocated project tasks and actions according to agreed quality and timeframes
- Ensure that detailed tasks and actions are allocated and completed to limit and mitigate risk within the allocated projects
- Develop training manuals, training plans and presenting training courses to support new solution implementations.
- Staying abreast of changes to analytical tools and methodologies
- Co-create with Devops Teams
- Participate in Design forums
- Review all report specifications in accordance with business requirements

**Education and experience**:

- A minimum of a Bachelor Degree in Information Technology or equivalent
- TOGAF Certification
- Data Warehouse Certification (Kimball / Inmon)
- Proven knowledge of Microsoft Power BI Report Server and Microsoft Power BI Services
- Knowledge of on premise to cloud migration to Microsoft Power BI Services
- Proven knowledge of designing solution using Oracle ODI
- Minimum 5 years of experience with detailed architecture designs on Oracle, SAS, Microsoft BI product stacks
- Must be proficient in SQL, Oracle and AIX
- Must be experienced in using SQL Developer for Oracle
- Project exposure (waterfall and agile methodologies)
- Must have solid expertise in designing Star schemas
- Must have experience in BI Infrastructure components from Applications, Databases, Operating Systems and Networks
- Formulation and standards for the BI Ecosystem
- Must have hands on experience designing solutions that integrate complex data sources in both real time and ETL based data extraction mechanisms DIMENSIONS
- Experience with facilitating workshops.
- Experience in negotiating for desired outcomes.

Between 5 - 7 Years



  • Pretoria, Gauteng, South Africa Professional Sourcing Full time

    Job Overview:Senior BI Solution Specialist (Financial Services)**Location: Pretoria, GautengPosition Overview:An exceptional financial services concern requires the services of a Senior BI Solution Specialist.The main purpose of this position is to develop and maintain detailed technical designs and ensure alignment of implementation and maintenance thereof...


  • Pretoria, Gauteng, South Africa Mediro ICT Full time

    Key deliverables: BI detailed technical solution architecture, BI data modelling Participate in the interpretation of business requirements and functional specifications as provided by the business analyst into BI solution designs. Design of the Extract Transfer and Load (ETL) solution to get data into a data warehouse or data mart according to design...


  • Pretoria, South Africa South African Reserve Bank Full time

    -The main purpose of this position is to develop and maintain detailed technical designs and ensure alignment of the implementation and maintenance thereof with respect to all business intelligence (BI) solutions across the South African Reserve Bank (SARB). -Detailed Description - Develop detailed technical domain-specific BI technology and solution...


  • Pretoria, Gauteng, South Africa Kamo Placement Full time

    Gauteng, Tshwane (Pretoria) Annually Cost To Company (Market related, Negotiable)To develop and maintain detailed technical designs and ensure alignment of implementation and maintenance thereof with respect to all Business Intelligence (BI) solutions across the company To develop detailed technical domain specific BI technology and solution standards in...

  • BI Specialist

    3 weeks ago


    Pretoria, Gauteng, South Africa SET IT Recruitment Full time

    Exciting Job Opportunity for a Senior BI Specialist in Pretoria**Closing Date**: 29 May 2023

  • Senior BI Analyst

    3 weeks ago


    Pretoria, Gauteng, South Africa Kontak Recruitment SA Full time

    Gauteng, GautengSenior BI Analyst (JB3103)Salary: R to R Annually CTCDuration: PermanentVacancy Close Date: 25 May 2023A well-established company that is a leading Tourism retail service provider that offers a wide range of innovative solutions to businesses looking to enhance their retail operations. With a focus on personalised service and cutting-edge...

  • Senior BI Analyst

    4 weeks ago


    Pretoria, South Africa Moyo Talent Solutions Full time

    **We are Recruiting: Senior BI Analyst** The BI Analyst is responsible for turning data into information, information into insight, and insight into business decisions. Responsibilities include conducting full life-cycle activities for business intelligence, from requirement analysis and design of key business metrics to reporting...

  • Senior BI Analyst

    3 weeks ago


    Pretoria, Gauteng, South Africa Moyo Talent Solutions Full time

    We are Recruiting: Senior BI AnalystThe BI Analyst is responsible for turning data into information, information into insight, and insight into business decisions.Responsibilities include conducting full life-cycle activities for business intelligence, from requirement analysis and design of key business metrics to reporting...

  • Senior Bi Analyst

    3 weeks ago


    Pretoria, Gauteng, South Africa Moyoafrica Full time

    WELCOME TO MOYO Senior BI Analyst We are looking for an experienced Senior BI Analyst at our Moyo teamPrimary Duties and Responsibilities:The BI Analyst is responsible for turning data into information, information into insight and insight into business decisions. Responsibilities include conducting full life-cycle activities to include requirements analysis...

  • Solution Specialist

    3 weeks ago


    Pretoria, Gauteng, South Africa Nambiti Technologies Full time

    Gauteng, Tshwane (Pretoria)- market relatedWe are recruiting for a Solution Specialist for a 3 years contractRequirements: Must have 9 or more years of experience in implementing Business Analytics and Business Intelligence (BI) Solutions Must have IT or relevant qualification NQF Level 6 or HigherClosing date 23 Janaury 202- For more information please...


  • Pretoria, South Africa Tipp Focus Full time

    **Background** The Business Intelligence & Analytics Centre of Excellence (BI & A CoE) requires the services of a Senior BI Technical Architect to assist with detailed technical architecture and BI solution design deliverables for Business Intelligence Projects within the Business and Systems Technology Department. The Senior BI Technical Architect will be...

  • BI Analyst

    3 weeks ago


    Pretoria, South Africa JSRH Solutions Full time

    We Are Hiring: Mid - Senior BI Analyst Cape Town or Centurion l Hybrid (90% Remote) We are looking for passionate BI Analysts who turns data into information, information into insight, and insight into business decisions. This includes, requirements analysis and design, database development and reporting capabilities, and continuously monitoring performance...

  • BI Analyst

    2 weeks ago


    Pretoria, South Africa JSRH Solutions Full time

    We Are Hiring: Mid - Senior BI Analyst Cape Town l Centurion l Hybrid (80% Remote) Salary Negotiable We are looking for passionate BI Analysts who turns data into information, information into insight, and insight into business decisions. This includes, requirements analysis and design, database development and reporting capabilities, and continuously...


  • Pretoria, South Africa Planet10 Full time

    We are looking for a Senior Manager Enterprise Architecture, DevOps BI to oversee the overall Enterprise Architecture, manage and coordinate various DevOps teams, and manage the design and implementation of bespoke mainframe/ERP systems, digital channels, other software development, and the Enterprise Data Warehouse. At least a three-year Bachelor’s...

  • Senior BI Analyst

    2 weeks ago


    Pretoria, South Africa Snaphunt Full time

    The OfferWork alongside & learn from best in class talentFlexible working optionsGreat work environmentThe JobYou will be responsible for : The BI Analyst is responsible for turning data into information, information into insight, and insight into business decisions.Responsibilities include conducting full life-cycle activities for business intelligence,...


  • Pretoria, Gauteng, South Africa Tipp Focus Full time

    BackgroundThe Business Intelligence & Analytics Centre of Excellence (BI & A CoE) requires the services of a Senior BI Technical Architect to assist with detailed technical architecture and BI solution design deliverables for Business Intelligence Projects within the Business and Systems Technology Department.The Senior BI Technical Architect will be...


  • Pretoria, South Africa Planet10 Full time

    We are looking for a Senior Manager Enterprise Architecture, DevOps BI to oversee the overall Enterprise Architecture, manage and coordinate various DevOps teams, and manage the design and implementation of bespoke mainframe/ERP systems, digital channels, other software development, and the Enterprise Data Warehouse.At least a three-year Bachelor’s...

  • BI Specialist

    4 weeks ago


    Pretoria, South Africa Communicate Recruitment Full time

    We are looking for a BI Specialist to join my client teams based in Pretoria. The type of financial modelling involved will be infrastructure-type projects that may well use limited recourse debt finance, the core discipline is the project preparation and raising of funding for such projects, together with developing and implementing energy and...

  • BI Specialist

    2 weeks ago


    Pretoria, South Africa Communicate Recruitment Full time

    We are looking for a BI Specialist to join my client teams based in Pretoria. The type of financial modelling involved will be infrastructure-type projects that may well use limited recourse debt finance, the core discipline is the project preparation and raising of funding for such projects, together with developing and implementing energy and...

  • BI Analyst

    3 weeks ago


    Pretoria, Gauteng, South Africa JSRH Solutions Full time

    We Are Hiring: Mid - Senior BI AnalystCape Town l Centurion l Hybrid (80% Remote)Salary NegotiableWe are looking for passionate BI Analysts who turns data into information, information into insight, and insight into business decisions. This includes, requirements analysis and design, database development and reporting capabilities, and continuously...