Business Intelligence Analyst - Head Office, Cape Town


MINIMUM REQUIREMENTS:

  • Relevant 3-year degree (BCom Information Systems, BSc Maths or equivalent)
  • BI Data Delivery
  • Be familiar with data warehouse principles and methodologies
  • Understand business data and information requirements as per technical specifications
  • Deliver data and information to the business in line with business priorities, according to quality standards, within the agreed time constraints and according to departmental coding practice & standards
  • Be involved in the process of populating new data within the Data Warehouse
  • Offer support to information delivery production environment
  • Understand the current production environment and relevant processes
  • Support the Analytics Team in maintaining the production environment, ensuring delivery of current information to the business on time, effectively collected, correctly transformed, audited, accurately published
  • Ensure efficient and effective resolution of production issues
  • Ensure that information is delivered according to user expectations
  • Monitor the database environment to proactively engage in prevention activities and to maintain an environment that is easy to understand, manage and troubleshoot


SPECIAL CONDITIONS:

The successful candidate must be able to:

  • Have exposure to data warehousing experience with a working understanding of dimensional modelling
  • Understand ETL processes (experience of MS-SQL/T-SQL advantageous)
  • Have QlikView experience, an advantage
  • Be committed to quality
  • Have methodical problem solving
  • Have effective stress management
  • Cope with ambiguity and complexity
  • Know structured test methods and processes
  • Be results orientation
  • Work in teams and cooperative
  • Be highly organised
  • Have attention to detail
  • Develop, manage and maintain ETL scripts in the data warehouse
  • Develop, manage and maintain SSRS reports and associated loading scripts
  • Be involved in design of data warehouse
  • Create Qlikview Models
  • Know data integration using SSIS and SSRS for analysis

Special notification:

Purpose of the role:

The role of the BI analyst is to support, enhance and optimise the current data warehouse environment by extracting, transforming and loading data from various external sources using TSQL and other Microsoft tools. Furthermore, it is required to develop and enhance reporting and analytical capabilities/solutions, using native MS SQL reporting tools and other data visualisation tools, delivering projects that service and support the business’ requirements in an agile manner.

Interested parties are invited to send their applications via: weblink or hr@iconsa.co.za.
Successful candidates will be contacted within 2 weeks after the closing date of this position.

CLOSING DATE FOR APPLICATIONS: 03/04/2020

The Company’s approved Employment Equity plan and targets will be considered
as part of the recruitment process aligned to the Group’s Employment Equity strategy.