Log In
Sign Up
Apply for job
Apply For This Job
BI Developer – Cape Town
A BI Developer job vacancy is currently available in Cape Town, Western Cape, South Africa.
We aim to be Africa’s ambassadors, and now, we are offering you the opportunity to join our Business Intelligence Team as a BI Developer.
As the ideal BI Developer candidate you will take ownership for ensuring the integrity of all information within the data warehouse as well as the accuracy of the processes used to populate the warehouse daily.
You will be responsible for developing and maintaining existing ETL as well as provide operational BI support to the business.
As a BI Developer, your responsibilities will include, but will not be limited to:
- Designing, developing, testing, maintaining and documenting ETL procedures
- Developing SQL scripts for ad-hoc requests and reports
- Assisting in data management and data integrity initiatives
- Understanding system workflows and documenting key data flows
- Aligning Key Performance Indicators, reporting and analytics
- Addressing reporting issues at root cause level
- Refine and automate regular processes / scheduled jobs, track issues, and document changes
- Continuously assess and document data quality
- Manage new permissions requested and report on database access for users and application logins
- Translating business needs into technical specifications
- Improving existing BI tools and procedures
Requirements – BI Developer:
Our ideal BI Developer will possess:
- BA / Bcom / BsC in either Engineering, Info Systems, Computer Science or related field
- 2+ years’ experience with MSSQL & MYSQL
- 1-2 years of experience developing and maintaining ETLs and using Data Integration tools (e.g. 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, google sheets etc.
- Basic understanding of programming languages (Java or Python)
- Experience designing relational and non-relational data structures
- Working experience with more than one database technology
- Strong analytical and troubleshooting skills, including a proficiency for 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 organisational skills to prioritise tasks and relay insights to members of the leadership team
- The ability and eagerness to further develop the required skills through self-learning
- Strong teamwork skills as well as the ability to work independently from team
Knowledge of the following will be advantageous:
- Multidimensional design & modelling based on Kimball best practices
- DWH architectures
- Code versioning
- Technical Documentation
- Experience with Linux run levels and file system
- Experience using Salesforce or NetSuite as a data source is desirable
- Experience using Google suite
Benefits:
You will gain hands-on experience in the web developing space while directly creating an impact:
- Join an award-winning team in an industry-leading company in African travel and help us shape the future of our industry;
- Make an impact – for every 7 people we bring to Africa, we create one permanent job in the tourism industry;
- Earn an attractive remuneration package including a competitive base salary, 3% pension fund and 20 days of paid vacation per year;
- Hybrid work model – Enjoy the flexibility of working on-site and remotely part of the week once you’ve passed your probation;
- When on-site, carry out your craft in gorgeous offices in the heart of Cape Town – the world’s most beautiful city;
- Optional Health Insurance coverage with Essential Med;
- Work under visionary leaders who encourage a family culture, open and direct communication and honest feedback;
- Collaborate with a diverse and talented high-performance team;
- Explore Africa – To share our glorious continent with the crash, we offer each of our staff exclusive access to the company’s online travel portal. With the keys to the kingdom you’ll unlock travel deals for yourself, your family and your friends. You’ll get to take advantage of rebates on activities, transport and accommodation, including our own holiday destinations
Please note that this position is only available to SA citizens & SA permanent residents and preference will be given to previously disadvantaged individuals.
Should you be interested please send a copy of your updated CV.
Search all available job vacancies in South Africa →