Business Intelligence Developer at Mukuru

• This position is responsible 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. They are required to develop and maintain existing ETL as well as provide operational BI support to the business.
• Internal liaison takes place with all internal departments. External liaison is limited.

Duties And Responsibilities (include But Is Not Limited To)

• Develop and maintain existing ETL
• Ensure the existing code base is maintained
• Transform data into the correct format for the warehouse
• Ensure data is loaded into the warehouse accurately
• To take ownership of the data warehouse and integrity of all information loaded into it
• Act as owner of the data warehouse
• Make sure checks are in place to ensure the accuracy of all information
• Ensure all record counts are valid
• Ensure all data is in a useable format
• Adhere to internal SDLC system
• Ensure the quality of code within the BI team
• Review code of team members within the BI team
• Identify errors and provide feedback to relevant parties
• Provide operational support and solve technical issues for BI processes
• Ensure the warehouse runs effectively
• Check for any errors in loading data
• Identify and fix errors immediately
• Resolve problems when new processes are required
• Identify and address technical issues
• To provide general BI support to the business
• Maintain the BI shared inbox
• Provide input into meetings as well as BI planning
• Ensure all tickets are updated
• Write accurate stories for backlog
• Liaise with the business to establish and scope BI requirements
• Meet with stakeholders to establish requirements
• Ensure accurate understanding and make sense of business problem
• Carry out business analysis and scope work correctly
• Establish timeframes and communicate these back to stakeholders
• To manage own professional and self-development

Key Requirements

• Grade 12 or equivalent (Essential)
• Related qualification in software development (Essential)
• 2-4 years working experience within the BI field (Essential)
• Experience writing reports (Essential)
• Knowledge of data warehousing and analytics
• Knowledge of the Mukuru products
• Knowledge of BI tools concepts and architecture
• Knowledge of ETL and data analysis with focus on data integrity
• Knowledge of AWS Redshift, Bash, MySQL

Additional Skills

• Analytic skills
• Computer skills
• Verbal and written communication
• Presentation skill
• Interpersonal skills
• Attention to detail
• SQL skills
• Advanced Excel skills
• Relevant coding language skills