Job Description

We aim to be Africa's ambassadors, and now, we are offering you the opportunity to join our Business Intelligence Team as a Data Engineer.As the ideal 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 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 a Data Engineer, 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

REQUIREMENTSOur ideal Data Engineer 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 in order 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

Please note that this position is only available to SA citizens & SA permanent residents and preference will be given to previously disadvantaged individuals.BENEFITSTheres a smorgasbord of added delights. With us, you would:

• 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;
• When on-site (usually 2 days a week), 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 employees exclusive access to the our 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 destinations!

Should you wish to apply for this position, please email your latest CV and motivation to miriam@abcworldwide.com

ABC Worldwide