At Rhino Africa - Africa's leading luxury tour operator, we are proud to promote safari & luxury travel destinations across Africa, pioneering a new path for sustainable tourism and leaving our legacy on the continent. We aim to be Africa's ambassadors, and now, we are offering you the opportunity to develop into the Matrix that is Analytics. We are seeking a full-time Intermediate BI Developer to join our Business Intelligence Team.
As the ideal candidate, you will take ownership of ensuring the integrity of all information within the data warehouse as well as the accuracy of the processes used to populate the warehouse on a daily basis. You will be responsible for developing and maintaining existing ETL as well as provide operational BI support to the business.
As an Intermediate BI Developer, your responsibilities will include, but will not be limited to:
- Designing, developing, testing and documenting ETL procedures
- Designing and implementing reporting solutions
- Assisting in data management and data integrity initiatives
- Aligning Key Performance Indicators, reporting and analytics
- Understanding system workflows and documenting key data flows
- Developing SQL scripts for ad-hoc requests and reports
- Addressing reporting issues at root cause level
- Continuously assess and document data quality
- Translating business needs into technical specifications
- Improving existing BI tools and procedures
Requirements
Our ideal BI Developer will possess:
- BA/Bcomm/BSc in either Engineering, Info Systems, Computer Science or related field
- Ideally, more than 2 years of experience with writing complex SQL queries
- 1-2 years of experience developing and maintaining ETLs and using Data Integration tools (e.g. SSIS, Pentaho, Talend), or scripts
- Experience querying data from a data warehouse and loading data into it
- Experience obtaining data from diverse sources including APIs, RDBMSs, flat files, etc.
- Experience designing relational and non-relational data structures
- Working experience with more than one database technology
- Strong analytical and troubleshooting skills, including proficiency in root cause analysis
- Experience creating technical documentation
- A collaborative and creative approach to solving business issues while working with partner teams
- A self-starter with phenomenal problem solving and diagnostic acumen, and a strong analytical mind-set
- Acute attention to detail and strong organizational skills in order to prioritize tasks and relay insights to members of the leadership team
- The ability and eagerness to further develop the required skills through self-learning
Knowledge of the following will be advantageous:
- Multidimensional design & modelling based on Kimball best practices
- DWH architectures
- BI tools (Power BI, Tableau & SSRS)
- Code versioning
- Technical Documentation
- Knowledge of Java or Python
Please note that preference for this position will be given to South African PDI candidates.
This position is available for a minimum duration of 6 months.
Benefits
At Rhino Africa, you'll gain hands-on experience in Analytics while directly creating an impact:
- CAPE TOWN: Carry out your craft in gorgeous offices located in the heart of Cape Town, the world's most beautiful city.
- THE TRACKER PROGRAM: At Rhino Africa you’re not just another lost animal in the wild! We assign each new intern a ‘tracker’ to guide them through the jungle, introduce them to their fellow Rhinos and our unique family culture.
- INDUSTRY EXPERTS AND MENTORS: Work under visionary leaders who encourage open and direct communication and honest feedback.
- Join the BI team of the fastest-growing company in travel and help us shape the future of our industry
- Collaborate with a diverse and talented team for all your digital needs - check out some behind the scenes shots on our RhinoAfrica_Life Instagram page.
- EXPLORE AFRICA: To share our glorious continent with the crash, we offer each of our Rhinos exclusive access to the Roaming Rhinos online travel portal. With the keys to the kingdom you'll unlock travel deals for yourself, your family and your friends. From breathtaking African experiences to getaways at our inspiring locations, you’ll receive up to 90% discount from 80 different partners and suppliers across 7 countries. You'll get to take advantage of rebates on activities, transport and accommodation, including our own Camissa House and Silvan Safari Lodge!
- DATA FLOW AND SYSTEM INTEGRATION: Learn how different operational systems integrate and data flow to our data warehouse and financial system.
- DATA QUALITY: Learn how to do data quality validation between systems and how to work with technical teams to resolve issues.
- ANALYTICS: Learn to combine datasets to provide valuable insights to the business.
- REPORT MIGRATION: Learn how to assess reports and successfully migrate reports from one platform to another.
This job has now closed
You can find more jobs over on our careers page.
See More Jobs