PBT Group has an opportunity for a BI Solution Design Specialist to design the Data Model (Star Schema), ETL’s, Data Marts and Visualisations for the various BI projects in the Business Intelligence (BI) department.

Duties will include but will not be limited to:
- Design the BI solution given the input from the Business Analyst and document the Solution Design using the standard template, bringing business and information technology (IT) together, translating business requirements into a solution design enabling the developer to use the detailed design to ensure effective system development and delivery;
- Focusing on making the end to end technical design clear from the input source systems, the required processing and envisioned dissemination of information to both internal and external parties in order to achieve business goals; and
- Address the technical design of the ETL, data warehouse tables, OLAP cubes, and data delivery mechanism to stakeholders both addressing defined user requirement and performance and efficiency issues

Key deliverables:
1. Provide technical leadership to the project’s resources, which could include Developers, Integration specialists, testers and Business Analysts in delivering a well designed and engineered solution that is integrated with the existing or defined IT architecture and services framework that meets clearly defined technical performance requirements.
2. Engage with the Business Analyst for the BI solution and ensure complete understanding of the business objectives, drivers, functions, structures, detailed workflows and information needs as per the business specifications document.
3. Responsible for the development of technical design documentation, and supporting the implementation, testing, operation of the solution as well as validating of product certifications, and highlighting any non-compliances.
4. Provide continuity of technical understanding across the BI Architecture Blueprint, presales architecture, and the definition of technical design during the various phases of solution definition.
5. Assist Project Manager in defining the delivery approach, provide input to estimates and resource planning required to deliver the proposed solution.
6. Liaise with architecture governance team to observe conformity with agreed enterprise standards and to facilitate the implementation of the solution based on the approved and licensed tools while drafting exemptions where required.
7. Lead the project team in the troubleshooting of technical issues related to the project implementation and promote development of expertise in the delivery team.
8. Any other duties and or deliverables closely related or necessary for the purpose of delivering the Services.

Experience:

Must have:
- A minimum of five years’ experience in designing business intelligence solutions based on the Oracle BI (OBIEE) toolsets, SAS & Power BI
- Must have 5 year working experience with Oracle Data Integrator (ODI), OBIEE, BI Publisher, SAS VA & Power BI
- Must have experience in the Kimball and or Inmon methodologies
- Must be proficient in SQL, Oracle and AIX
- Must be experienced in using SQL Developer for Oracle
- Project exposure (waterfall and/or 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
- Data Modelling using Visio or SAP Power Designer

Advantageous:
- Proficient in at least one other BI toolset (QlikSense, MicroStrategy, BusinessObjects, Tableau, Cognos etc.)
- Essbase experience would be advantageous
- Experience of working in an agile development environment. Disciplined Agile Development (DAD) experience will be an added advantage
- .Net Core Experience
- Windows FTP Site Creation

Competencies:
- Proficiency in English (both verbal and written skills);
- Client Orientation
- Verbal and written communication
- Managing Work/Time management
- Problem solving and analysis
- Contributing to Team Success
- Proven ability to accurately estimate work
- Pays attention to details

Qualifications/ Certification:
- A degree in Computer Science / Information Management or equivalent

Advantageous
- OBIEE Certified
- TOGAF Certification
- Datawarehouse Certification