An innovative cash risk management firm in Joburg seeks a forward-thinking BI Developer to join its team. Your core role will be to run with the end to end function of BI development, including but not limited to technical BI specifications, designing and coding new solutions, designing data structures, testing and operational support. You must possess a BSc Degree/Diploma in Computer Science/Software Engineering/IT Software, 6 years’ experience in BI system design and programming, 3 years’ BI Systems Development Lifecycle with strong SQL skills. If you are Certified as a Microsoft BI Specialist, it will prove hugely beneficial.
Analysis and design of solutions –
Schedule and facilitate JAD sessions with the business analysts as well as technical teams in order to gather the necessary information to design BI solutions.
Compile BI functional and technical specifications using templates and standards as set by management.
Align business requirements with best practice BI solutions.
Design back-end BI structures to support the performance, scalability and usability requirements of the solution.
Develop BI programmes –
Responsible for database table administration and ETL process administration.
Table structures in the form of ODS’s and Star Schemas should be well thought out in the design to facilitate re-usability, accuracy and auditability.
Design and develop the ETL processes and database table development in the Microsoft environment.
Work collaboratively with the BI Analyst to support the operational data store and data warehouse.
Perform data analysis with the Analyst to understand the data in relation to the set-out requirements.
Responsible for integration of source system data into the data warehouse.
Responsibility for the ETL (extract, transform & load) process architecture.
Implement BI programmes –
Analyse the impact of BI changes or fixes prior to implementation.
Ensure that end user acceptance testing is appropriately conducted.
Ensure data is clean and credible to support strategic decision-making.
Ensure that all data is delivered according to specification.
Ensure that designed processes are sustainable within a production environment.
Provide BI Systems support –
Provide support and resolve issues within respective SLAs.
Conduct System Administration duties to support the Business Intelligence environment.
Monitor ETL processes in production for failures, performance issues and runaway jobs.
Analyse, identify and resolves system problems.
Document management of system specifications, data warehouse structures, impact analysis, functional designs, technical specifications, testing plans, system integration and entity relationship models.
BSc Degree: Computer Science / Software Engineering / IT Software Diploma.
Preference will be given to candidates that are Microsoft BI Specialist Certified.
6 Years’ experience in BI system design and programming.
3 Years’ experience in BI Systems Development Lifecycle.
Must be an SQL expert.
While we would really like to respond to every application, should you not be contacted for this position within 10 working days please consider your application unsuccessful.
When applying for jobs, ensure that you have the minimum job requirements. Only SA Citizens will be considered for this role. If you are not in the mentioned location of any of the jobs, please note your relocation plans in all applications for jobs and correspondence. Please e-mail a word copy of your CV to email@example.com and mention the reference numbers of the jobs.