Senior DW/BI Engineer – Wits University – Johannesburg

Main Purpose of the Post:
To provide a world-class BI infrastructure to support the academic project and management decision making by: regularly engaging with stakeholders to market BI and to understand university and academic information requirements; developing a deep level of understanding of the technology and information content across all information areas in the warehouse and being able to solve all technical problems without referring them up the line; providing a hands-on, engineering and leadership role to develop high level, flexible team competencies, materials, and procedural disciplines to perform all tasks necessary to enhance, design, develop, test, implement and populate all components of the data warehouse; assisting in the migration to the cloud; providing a high performance, reliable and stable infrastructure and providing timely, accurate, understandable and relevant operational, management and strategic reporting anywhere, anytime in a format that best suits user requirements.

Key Responsibilities:
· High-performance team and infrastructure and skills pipeline
· Develop, maintain and populate the data warehouse.
· Ensure the currency, quality, and integrity of the data warehouse and provide consistency and synchronization across all areas.
· Ensure comprehensive, relevant, and accurate operational, management, and statutory reports are available.
· Ensure appropriate tools, applications, and analytics are in place to support external, benchmarking, planning, and corporate performance management requirements.
· Provide high-quality training and materials to enable clients to access and understand warehouse information.
Provide access and help-desk support services.
· Setting up and administering and testing backups and disaster recovery procedures.
Designing, analyzing, and maintaining cloud systems and assistance in migrating on-prem systems to the cloud
Keep abreast of the latest developments in the BI and technology space and do innovation and automation.
Implementing DevOps and MLOps.
· Server maintenance, performance, server virtualization, security, and backup/recovery.
· Setting-up, administering, and maintaining BI reporting/analytics infrastructure:
o Software installation, upgrades, configuration, and security.
o Creating repositories/universes, setting up business and related layers, creating hierarchies, aggregation rules and repository variables.
o Setting up multiuser development environment, administering users and groups.
· Setting-up, administering, and maintaining ETL infrastructure:
o Software installation, upgrades, configuration, and security.
o Monitor ETL processes, and system audits. Proactively resolve issues as found. Support the performance of systems

Academic Qualifications:
Masters in Information Engineering / BSc Computer Science/ or equivalent IT qualification
Essential Skills
· 4 years’ experience in data warehousing / business intelligence, data modelling, and star schema design.
· 4 years’ experience with Extraction, Transformation, and Loading (ETL), databases, SQL, and PL/SQL.
· 2 years of experience in installing, upgrading, configuring, and backup/recovery of all components of OBIEE 12c, SAP Business Objects 4.2, MS Power BI, and Oracle Data Integrator 12c.
· 1 year experience in server maintenance, virtualization, backup/recovery, OS, and other related software installation, configuration and security. Expertise in Linux, Windows Server, and Proxmox.
· Direct hands-on experience with OBIEE12c, Oracle BI – Server, RPD, Oracle BI Analysis, Oracle BI Interactive Dashboard, Oracle BI physical layer, Oracle BI Business layer, Oracle BI presentation layer, metadata repositories, report scheduling, application/object security, and WebLogic Server.
Expertise in SAP BO 4.2 administration, information design tool, BI launch Pad, index awareness, aggregate awareness, contexts, derived tables, and optimizing parameters.
Expertise in MS Power BI desktop and MS Power BI Service.
· Expertise in ODI 12c work and master repositories, logical and physical architecture, data sources, context, mapping, packages, procedures, load plans, variables, deploying scenarios, sessions, topologies, knowledge modules, change data capture, metadata, security and web services.
· Knowledge in Python, KNIME, Jenkins, and XML.
· Experience with the agile, waterfall life cycle, and other methodologies.
· Cloud platform experience with OCI, MS Azure, and AWS and involved in the migration of systems from on-premises to the cloud.
· Knowledge of DevOps and MLops.
· Knowledge in Peoplesoft Campus Solutions, PeopleTools, Oracle Financials, and Oracle HR ERP applications.

Understanding of University Academic Structure and systems
Certifications in PL/SQL, OBIEE/Oracle Analytics, SAP Business Objects, MS Power BI, ODI, OCI, MS Azure, AWS, Data Warehouse Design, Peoplesoft Campus Solutions, PeopleTools, Oracle Financials, and Oracle HR.

How To Apply
Please submit a covering letter clearly indicating which post you are applying for, detailed CV with names, addresses, contact numbers and e-mail addresses of 3 referees
External applicants are invited to apply, by registering your profile on the Wits i-recruitment platform located at and submitting your application. or email applications to
Internal employees are invited to apply directly on Oracle by following the path: wits /Self Service application/” Apply for a job” or email applications to