Description:
We are offering you the opportunity to join our Business Intelligence Team as a BI Developer. Location Cape Town
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 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 proceduresRequirements
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 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 teamKnowledge of the following will be advantageous:
Multidimensional design & ...
01 Aug 2022;
from:
gumtree.co.za