SummaryOur Client in the Travel and Tourism industry has an exciting opportunity for a BI Developer to join their 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 daily.
You will be responsible for developing and maintaining existing ETL as well as providing operational BI support to the business.Job DescriptionDesigning, developing, testing, maintaining, and documenting ETL proceduresDeveloping SQL scripts for ad-hoc requests and reportsAssisting in data management and data integrity initiativesUnderstanding system workflows and documenting key data flowsAligning Key Performance Indicators, reporting, and analyticsAddressing reporting issues at the root cause levelRefine and automate regular processes / scheduled jobs, track issues, and document changesContinuously assess and document data qualityManage new permissions requested and report on database access for users and application loginsTranslating business needs into technical specificationsImproving existing BI tools and proceduresKey Roles and ResponsibilitiesBA/Bcom/BSc in either Engineering, Info Systems, Computer Science, or related field2+ years experience with MSSQL & MYSQL1-2 years of experience developing and maintaining ETLs and using Data Integration tools (e.g.
Pentaho, Talend), or scriptsExperience querying data from a data warehouse and loading data into itExperience 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 structuresWorking experience with more than one database technologyStrong analytical and troubleshooting skills, including proficiency in root cause analysisExperience creating technical documentationA collaborative and creative approach to solving business issues while working with partner teamsA self-starter with phenomenal problem solving and diagnostic acumen, and a strong analytical mind-setAcute attention to detail and strong organizational skills to prioritize tasks and relay insights to members of the leadership teamThe ability and eagerness to further develop the required skills through self-learningStrong teamwork skills as well as the ability to work independently from the team Advantageous Skills and KnowledgeMultidimensional design & modeling based on Kimball best practicesDWH architecturesCode versioningTechnical DocumentationExperience with Linux run levels and file systemExperience using Salesforce or NetSuite as a data source is desirableExperience using Google suitePlease note that this position is only available to SA citizens & SA permanent residents and preference will be given to previously disadvantaged individuals.
