Description:
Summary
Our 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 Description
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 the 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 proceduresKey Roles and Responsibilities
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 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 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 Strong teamwork skills as well as the ability to work independently from the team
Advantageous Skills and Knowledge
Multidimensional design & modeling based on Kimball best practice...
09 May 2022;
from:
gumtree.co.za