Data Analyst at African Rainbow Life

Output/Core Tasks:

• Provide infrastructure, tools and frameworks used to deliver end-to-end solutions to business problems.
• Build scalable infrastructure for supporting the delivery of clear business insights from raw data sources; with a focus on collecting, managing, analysing, visualizing data and developing analytical solution.
• Design and develop scalable ETL packages from the business source systems and the development of ETL routines to populate databases from sources and to create aggregates.
• Perform ad-hoc analyses of data stored in African Rainbow Life (ARL) databases and write SQL scripts, stored procedures, functions, and views.
• Proactively analyses and evaluate the ARL databases in order to identify and recommend improvements and optimization. Deploy sophisticated analytics programs, machine learning and statistical methods.
• Liaise and collaborate with the team, providing support to the entire department for its data centric needs. Collaborate with subject matter experts to select the relevant sources of information and translates the business requirements into data mining/science outcomes.

Minimum Requirements:

1. Qualifications & Experience

Industry experience is preferred (2 to 3 years).

• BSc/BA in Computer Science, Engineering, or relevant Microsoft certifications.
• Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS).
• In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework.
• Background in data warehouse design (e.g. dimensional modeling) and data mining.

2. Essential Competencies

• Proven abilities to take initiative and be innovative.
• Analytical mind with a problem-solving aptitude.

3. Desirable competencies

• You should be analytical and an excellent communicator.
• Possess a business acumen and problem-solving attitude.