Discoverys core purpose is to make people healthier and to enhance and protect their lives. We seek out and invest in exceptional individuals who understand and support our core purpose, and whose own values align with those of Discovery. Our fast-paced and dynamic environment enables smart, self-driven people to be their best. As global thought leaders, Discovery is passionate about innovating in order to not only achieve financial success, but to ignite positive and meaningful change within our society.
Key Purpose
Construction of complex BI Solutions based on specifications produced by the BI Architects and Systems Analysts. (BI Solutions imply ETL / Analytics / Presentation).
Driving Engagement and building relationships with key stakeholders which include Systems Analysts, BI Architects and QA Manager
Key Outputs
- Develop and maintain SSIS packages
- Create required database structures
- Develop and maintain T-SQL code
- Analyse SQL execution plan to optimise performance
- Version control of developed solutions within a code repository
- Workshop solutions with Systems Analysts and Architect to compile relevant technical specifications
- Contribute to the development of architectural guidelines and standards
- Prototyping, Research and Development of new techniques and solutions
- Peer review of code and solutions developed
- Team engagement champion
- Improving robustness and stability of ETL batches
- Scheduling business processes via ETL tools
- Experience in developing and maintaining an ETL Framework e.g. ETL controller
- Create and maintain Metadata and Code repositories
- Dynamic Sql
- Develop and maintain SSAS models
Knowledge
- Systems Development Life Cycle (SDLC) Advanced level
- Data Security and Protection Policies Intermediate/Advanced
- Data Warehouse principles and practises Intermediate/Advanced
- Kimball Methodology Intermediate/Advanced
- Financial Services industry knowledge Advantageous
- T-SQL, SQL Advanced
- SQL Server BI Stack (SSIS, SSMS) Advanced
- MS Excel Advanced
- MDX Advantageous
- DAX Advantageous
- Dimensional Modelling Basic
- Data Mining Basic
- Creating and Innovating
- Applying Expertise and Technology
- Analysing
- Persuading and Influencing
- Deciding and initiating action
- Adapting and Responding to Change
- Learning and Researching
- Presenting and Communicating Information
- National Diploma in Information Technology or a Bachelors degree
- Certification on Microsoft or other ETL Tools
- Kimball related courses (dimensional modelling)
- Minimum of 4 years experience in BI Development in SQL Server Integration Services & Management Studio.
The Companys approved Employment Equity Plan and Targets will be considered as part of the recruitment process. As an Equal Opportunities employer, we actively encourage and welcome people with various disabilities to apply.
