Junior BI Developer - Parktown at Hollard Insurance

Job Advert Summary
The person will be responsible for development of dashboards and reports to aid business in day-day decisions as well as maintenance of existing reports.

They will be responsible for automating and driving improvement on manual processes. Conduct data reconciliations from off-platform data sources and producing reports and insights from such data.

The person will interact with the business stakeholders and subject matter experts in order to understand their problems and needs and produce business dashboards and analytical solutions.

Key Responsibilities:

• Collaborate with business users and other developers to understand and deliver on business needs with a sense of urgency and importance.
• MS SQL Scripting, designing and implementing or reports and data extracts as per business requirements.
• Maintain and support existing data extracts, reports and processes.
• Assist in conducting root cause analysis and resolve data issues and report issues.
• Ensure high quality BI development work via standards, guidelines, quality assurance reviews and testing.
• Design and implement Extract, Transformation and Load (ETL) processes and scripts.
• Validate data in databases and test solutions developed.
• Create specifications for the reports to be developed in order to support Business decision-making.
• General: When required perform any other duties necessary for the operational effectiveness of the company that is within your ability and scope.
• Customer service: Maintain a high level of service to customers (internal and external) according to service level agreements and within the service standards as set by the company.  Provide timely and professional customer service to stakeholders.  
• Continuous Process Improvement: Ensure full compliance to all processes, policies and procedures. Drive and challenge to do things in a better way which reduces waste.
• Quality control:  Quality standards to be adhered to at all times.
• TCF: Ensure customers are treated fairly.
• Employee Growth: Take responsibility for your own career growth and have regular discussions with the relevant role players.

Required Knowledge and Experience

• Matric/Grade 12.
• Bachelor's degree/Diploma in Information Technology, Informatics, Computer Science, Engineering, Sciences, Data Science or Business Analysis.
• BI Certification (e.g. Microsoft MCITP, Kimball Certification, etc.) would serve as an advantage.
• 3 - 5 years experience in any of the following disciplines: 
• Exposure to any reporting tools such SSRS, Power BI or Crystal Reports.-
• Exposure to database design and data modelling.
• 3- 5 years’ Microsoft SQL experience. MCTS / MCITP preferential (2008+).
• Transcripts of certification to be provided.
• Exposure to SQL Management Studio, T-SQL, SSRS, Power BI, SSIS tools.
• Exposure to database design and/or data modelling
• Exposure to SQL Management Studio, T-SQL, SSRS, Power BI, SSIS tools.
• Exposure to database design and/or data modelling
• Knowledge of MS Office – specifically Word, Excel, Outlook
• Communication skills (Can express him/herself in a clear and concise way)
• Relationship management skills (have the right approach with the right people)
• Customer orientation
• Strong interpersonal skills / team player
• Coordination, scheduling and planning skills
• Detail orientated
• Demonstrate common sense, self-motivation and discipline
• Well-presented / representative of Hollard’s image
• Visibly demonstrate the Hollard Way
• Excellent analytical skills
• Lateral thinker/innovator
• Effective written and oral communication skills
• Self-motivated
• Attention to detail, accuracy and speed
• Learning attitude and orientation
• Collaboration skills
• Excellent analytical skills
• Lateral thinker/innovator
• Effective written and oral communication skills
• Teamwork and co-operation
• Independent & self-motivated
• Continuous improvement

Educational Requirements

• Matric/Grade 12.
• Bachelor's degree/Diploma in Information Technology, Informatics, Computer Science, Engineering, Sciences, Data Science or Business Analysis.
• BI Certification (e.g. Microsoft MCITP, Kimball Certification, etc.) would serve as an advantage.