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