Business Intelligence Analyst - Cape Town Verfied

R 60000 per month Cape Town, Western Cape Cape Town, Western Cape more than 14 days ago 27-08-2019 10:40:30 AM
22-10-2019 10:40:30 AM
A leading Mobile Service Provider (WASP) is looking for a Business Intelligence Analyst. Your primary responsibilities will include overseeing reporting /data structure to various Business Units.
Use data to optimize processes and manage risk.
Mine company data bases in order to determine relationships which are relevant to the business.
Manage the tracking process of current and new products.
Change the manner in which employees at all levels make use of data. Provide education and direction on the use of reports, new techniques and the manner in which data is collected.
Aggregate data from multiple sources, including databases and data warehouses, to deliver accurate and useful data from IT applications.
Facilitate the translation of business needs into analytics/reporting requirements through high level engagement and interfacing with internal users.

Qualification:
Business technology degree (B.Com, Information management qualification)

Skills & Experience:
3-4 years solid experience within a BICC, exposure to big data and statistical analysis with exposure to report writing and user interaction.
Experienced in managing/creating datamarts.
Expertise in the Microsoft BI solution offerings including SQL Server 2012/2008 R2 stack (SSRS, SSAS, SSIS), PowerView, PowerPivot, SharePoint, Excel.
Experience in identifying, analyzing and translating business requirements and rules into intuitive analytical solutions, business scorecards and management dashboards.
Understanding of Business Intelligence solutions: operational and analytical, strong knowledge of relational and multi-dimensional database architectures.
In-depth understanding of the Ralph Kimball and Bill Inmon datawarehouse schools of thought.
Advanced Excel / Spreadsheet experience.
Analytical experience especially around data manipulation and data mining.
Report writing experience.
Knowledge in the technical aspects of business intelligence, including data modelling, ETL, metadata/data management and OLAP tools.
5+ years working experience in the field of data warehousing, business intelligence and business analysis

Exposure to mainstream BI tools, such as Cognos, QlickView, Tableau or similar.
Advanced Excel, OLAP and presentation skills.
Familiar with a semantic layer and designing frameworks for reporting and analysis.
Cube development using SSAS or other such as Oracle workspace manager.
ETL familiarity (SSIS).
Data warehousing conceptual and practical knowledge.
Advanced knowledge of SSAS, SSIS and SSRS.
Exposure to MS powerquery and PowerBI (advantageous).
Advanced SQL and SQL server skills (SQL2012-2014).