BI Analyst - Cape Town
Salary Negotiable
Cape Town, Western Cape
Cape Town,
Western Cape
more than 14 days ago
27-08-2019 10:45:08 AM
22-10-2019 10:45:08 AM
An international brand with its head office in Cape Town is looking to expand its team with a BI Analyst, the duties include conceptualizing, defining and delivering new reports, as well as improving existing ones.
Analysis of data from various sources in order to ensure that the business acts proactively on the information at its disposal.
Obtaining, manipulating and analyzing business data to derive experience assumptions.
Trend analysis on historical data and deriving information to drive key business decisions.
Integration of new sources of data into company databases so that it can also be analyzed and included in relevant reports.
Qualification:
Bachelor's degree required; a computer related discipline preferred
Skills & Experience:
Experience with relational databases: SQL, OLAP, MS Office or VBA.
Hands on SQL experience (SQL queries, creation of stored procedures, functions, automation of jobs, etc.).
Ability to build reports in Excel and SSRS /Power BI/ Qlikview /Tableau / Cognos.
High proficiency in Excel (pivot tables, graphs, pull in data from other sources, formulas, functions).
Ability to clean, manage, manipulate and use numerical data.