KEY PERFORMANCE AREAS

Understand and Analyse business processes and data

  • Maintain an understanding of all business processes and the source applications that support these processes.
  • Analyse source data to determine: Data Relationships, Data Quality, Data Alignment to business processed and Data Integration across systems
  • Responsible for database table administration covering archiving, indexing and auditing requirements.
  • Work collaboratively with the BI Analyst to support the operational data store and data warehouse
  • Update and document the relevant source system specifications (i.e Extract, Transform & Load (ETL)), data warehouse structures, impact analysis, functional designs, technical specifications, testing plans, system integration and entity relationship models.
  • Responsible for the integration of source system data into the data warehouse
  • Perform detailed data analysis in preparation for designing the BI data models which will store the data.
  • Interrogate the data to pick up trends and steer discussions with relevant stakeholders.

Design back- end BI structures and solutions to support the performance, scalability and usability requirements.

  • Schedule and facilitate Joint Application Design (JAD) sessions with the business analysts as well as technical teams in order to gather the necessary information to design BI solutions.
  • Design processes that are sustainable within a production environment
  • Responsible for the design of third normal forms as well as dimensional database models.
  • Maintain a clear understanding of Table structures in the form of Operational Data Stores (ODSs) and Star Schemas, in order to facilitate re-usability, accuracy and audibility.
  • Design BI structures according to the master data management support requirements
  • Translate business requirements into BI technical solutions.
  • Design processes to perform delta processing and load various slowly changing dimensions.
  • Compile BI functional and technical specifications using the relevant templates and standards as set by management. (i.e. source-to-target mappings)

Implementation of BI Programs

  • Analyse the impact of BI changes or fixes prior to implementation
  • Conduct end user acceptance testing.
  • Deliver clean and credible data to support strategic decision-making, according to the necessary specifications.

Provide the necessary BI Systems Support to the BI team

  • Assist the BI team in analysing, identifying and resolving system problems.
  • Attend and represent the BI team in scope planning and technical project meetings.

REQUIREMENTS

  • 8 years experience in BI systems design and programming of which 5 years must be knowledge of BI systems development lifecycle as well as ETL in SSIS and T-SQL
  • BSC Computer Science/ Software Engineering
  • MCSE: SQL Business Intelligence (Advantageous)
  • MCSE: Data Management and Analytics (Advantageous)
  • CDMP: DAMA (Advantageous)
  • Relational / multidimensional database design skills (Advantageous)
  • Must have a proven track record in designing databases using either the Kimball or Inmon methodology
    (Advantageous)
  • Business intelligence principles, data warehouse and data governance practices. (Advantageous)

only shortlisted candidates will be contacted

Learn more/Apply for this position