Job Opportunities at Discovery Limited

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
   

Competencies

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
   

Technical Skills:

• T-SQL, SQL                                                         Advanced
• SQL Server BI Stack (SSIS, SSMS)                   Advanced
• MS Excel                                                             Advanced
• MDX                                                                    Advantageous
• DAX                                                                     Advantageous
• Dimensional Modelling                                        Basic
• Data Mining                                                         Basic
   

Competencies:

• 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

Qualification and Skills

• National Diploma in Information Technology or a Bachelor’s degree
• Certification on Microsoft  or other ETL Tools                  
• Kimball related courses (dimensional modelling)  
   

Minimum Required Experience

• Minimum of 4 years’ experience in BI Development in SQL Server Integration Services & Management Studio.
   

go to method of application »

Key purpose

• Discovery is a high-performance organisation which prides itself in attracting the best talent. Our environment is always buzzing with energy as smart, motivated people challenge themselves to find the best way to do things. In addition to being passionate about working in this fast-paced organisation, the successful applicant will be responsible for data extraction, analyses, modelling and BI reporting within the Marketing and Sales Analytics team.

Key outputs

• Source and provide customised data to the business
• Expand the suite of automated analytical/KPI reports used by clients of the Marketing and Sales Analytics team (relating to lead volumes, call centre metrics, campaign performance etc.)
• Be an enabler of performance marketing, i.e. perform analyses, provide insights and build predictive models that will assist with:
  • Client segmentation and ideal client identification
  • Development and implementation of targeted marketing strategies
  • Optimisation of call centre operations
  • Digital marketing optimisation
• Guide business stakeholders in what data to extract
• Improve processes and databases where opportunities arise
• Interpret and disseminate information via reports and publications
   

Competencies

• Strong analytical and statistical modelling/machine learning skills
• Skill in producing BI reports and working with BI software tools
• Above average ability to work with, analyse and report on data
• Ability to source data from both structured and unstructured sources
• Good communication skills and ability to build relationships with key stakeholders
• Ability to work under pressure and in conditions of change
• A team player who can work alone when required and without supervision
• Ability to multi-task and to manage workload
• Organized
• High level of attention to detail
• Resilience, enthusiasm, energy and drive
• Positive, can-do attitude
• Ethical and able to maintain confidentiality and manage boundaries
• Aligned to Discovery values and core purpose
   

Qualification and experience

• Honours degree (or higher) in statistics, actuarial sciences, computer science (or equivalent, relevant qualification) with 1+ years’ work experience OR BSc degree in statistics, actuarial sciences, computer science (or equivalent, relevant qualification) with 2+ years’ work experience
• Knowledge of statistical packages (R, SAS, SPSS, Python etc.)
• Knowledge of BI reporting tools (Power BI)
• Experience in statistical and machine learning modelling techniques
• High level of computer literacy (advanced MS-Excel and SQL)

go to method of application »

Key Purpose

• The core function of the position is to design and deliver state of the art business intelligence and data solutions to support analytics and reporting requirements according to provided specifications, standards, and procedures, using various tools and languages but within the architectural standards and guidelines as established within the Discovery group to obtain optimal systems performance.
• A highly skilled technical business intelligence developer with a desire to work in fast-paced environment, with the ability to consistently deliver exceptional results on demanding timelines.
• Development, maintenance and management of both production and development data warehouse environments.
• Produce complex specifications and implement systems enhancements. Work with the system architect to define the system design and then develop and test the necessary code that will be deployed.

Key outputs:

The successful applicant will be responsible for but not limited to the following job functions:

• Deliver effective technical documents, design, code, and data structures to integrate and prepare data within the warehouse environments to support business requirements for reporting and analytics requirements
• Design and delivery of high-quality automated reports and dashboards to support a variety of business needs
• Develop code and data structures in adherence with Agile principles, code, and configuration management standards
• Develop efficient and effective BI solutions on cloud and on-premise infrastructure
• Work with the requirements, architecture and business teams to deliver business intelligence solutions in line with requirements
• Support existing systems by Investigating, identifying and rectifying problems and identify potential BI improvements and implement appropriate solutions
• Define / Implement / Promote BI best practices
• Efficient time management ensuring delivery within the agreed timeframe as per the project plan and logging of time according to time keeping policy and daily admin on tasks
• Perform Test, debug and quality assure programmed code Ensure that unit testing is conducted successfully accordingly to the functional specification document, user requirements and test pack.
• Attend all technical, user and team meetings as required
• Liaise with stakeholders as required by the project including Development manager, Systems architect, Systems Analysts, Business analysts, to clarify requirements, review designs and obtain required approvals and provide updates
• May lead projects or project steps within a broader project or have accountability for ongoing activities or objectives
   

Competencies

• Strong technical experience and knowledge across multiple disciplines including Data warehouse ETL, design, modelling and methodologies,.
• Microsoft SQL Server technologies 2016 (Integration, Analysis and Reporting Services), Power BI, Visualization and reporting tools
• Oracle PL/SQL
• Prior Experience delivering BI/data structures on a cloud setup AWS
• Advanced SQL development skills, Advanced SSAS and SSIS development / support
• Understanding of dimensional modelling concepts
• Expertise in handling large amounts of data through such capabilities as SQL Server or open source databases and performing tuning across database platforms.
• In addition to querying traditional RDS instances, exposure and knowledge of acquiring data from API calls, xml, streaming events.
• Ability to communicate clearly and to guard all business relationships in a professional way
• Test methodologies.
• Programming logic must be on the highest level possible.
• Insurance Industry experience would be beneficial

Desirable

• Prior experience on Big Data appliances such as Hadoop.
• Hands-on/technical experience with high proficiency on Big Data technology and toolsets
• Python coding, Powershell scripting capability
• Understanding of Docker
   

Personal Attributes and Skills

• Ability to take ownership and accountability working independently, with minimal guidance
• Ability to work under pressure and to multi-task
• Excellent communication skills with the ability to communicate clearly and to guard all business relationships in a professional way
• Ability to work in a dynamic rapidly changing environment - Keep abreast of current technological trends and the application thereof
• Ability to work in a customer servicing environment across teams at all business levels
• Strong problem solving and Analytical skills.
• Able to work in conditions of change, flexible and open to learn new languages and architecture, learn quickly and share knowledge.
• Ability to deal with complexity and migrate between detail and high level requirements
• Work mostly within own team with ability to works across several teams, may act as a resource for colleagues with less experience
• Recognize unique demands of IT of non-conventional working hours
• Ability to deal with complexity and migrate between detail and high level requirements
   

Regulatory Responsibilities

You are required to understand and comply with all relevant rules, regulation and legislation applicable to your role.  This means:

• acting with integrity and due skill, care and diligence at all times.
• ensuring that customers are treated fairly at all times
• ensuring that communications via any medium meet the principle of 'clear, fair and not misleading'
• undertaking relevant internally arranged training on systems, processes and regulatory requirements relevant to your role
• identifying and escalating (through your line manager) risks that impact the business, customers or other third parties
• reporting (through your line manager) any issues and/or system/process failures that may impact on service to customers
• Further details of relevant regulation can be found on the vitality.co.uk intranet.
   

Education and Experience:

Education:

• Matric
• BSc (IT/Computer Science) or any other relevant Computer Science Degree
• Formal Qualification in related competencies
   

Experience:

• Must have a minimum of 5 years Systems Development experience
• Must have a minimum of 5 years Product (Oracle, Microsoft SQL Server) specific experience
• Must have a minimum of 3 years Oracle PL/SQL experience.
• Must have a minimum of 3 years Data Warehousing experience
• Technical Lead experience

go to method of application »

Job Purpose

• The Manager of IT vendor and software asset management performs contract management, performance management, relationship management and risk management with IT vendors. He or she owns and must understand contractual, commercial, and operational working relationships with vendors to ensure that contractual commitments are delivered across IT. They formulate and implement Software Asset Management policies, practices, and tools in order to optimally manage all software assets and licenses of the enterprise. Ensure that the software is always licensed optimally in order minimise legal and financial exposure to the organisation.

Areas of responsibility may include but not limited to

Process

IT Vendor Relationship Management

• Develop and lead the IT vendor management strategy, ensuring that IT vendors are delivering maximum value through their services.
• Classify, rationalize and optimize the vendor portfolio, and concentrate efforts on managing the most strategic vendors.
• Create procedures for contract, performance, relationship and risk management.
• Manage relationships with vendors for cost-effectiveness, build a main vendor repository to ensure effective contract management and vendor relationships.
• Perform overall contract operations oversight for performance management, which includes benchmarking and SLAs.
• Provide an issue escalation path and resolve vendor performance disputes.
• Maintain a calendar of important deliverables that each vendor must deliver to and ensure that these are carried out in time and of acceptable quality.
• Draft and manage on IT Budget together with Finance, Procurement, Executives, and any other relevant stakeholders.
• Receive, review and administer the authorization of IT related invoices, ensuring that IT vendors accounts are settled in-line with established guidelines within agreed timelines.
• Track and report actual spend against the contract and budget, to provide good financial control and summarise commercial performance.
• Ensure that a Contract Database is established, and appropriate tooling is evaluated, selected and implemented to aide in the automation of and maturing of the Vendor Management process.
• Ensure that a service level credit (penalty) process is in place, in conjunction with relevant stakeholders (Service Owner, Legal, Finance, Procurement etc.), as are a mechanism by which penalties are imposed on suppliers if actual supplier performance fails to meet the performance standards set in the service level agreements and contracts.
• Partake in the Release Management process to ensure that all new releases have an agreed service level and related contracts required for the operational success and compliance of the solution.
   

Software Asset Management

• Establish a software asset management framework and process.  
• Maintain a register of all licensed software that is procured and used across Discovery Bank. 
• Accurately track software deployment and licence usage across the enterprise (end user, server, network, storage, management, application etc.)
• Manage interactions with software vendors and ensure that all obligations are carried out on time and minimise any exposure to the organisation (anniversary dates, license renewal dates and obligations, license audits, true-up engagements etc.)
• Ensure that all licensed software in use in the business is adequately licensed and minimise financial and legal exposure to the business.
• Establish and lead an awareness regime on software license management and acceptable usage policies for software.
• Ensure that all technical teams are aware of their obligation of ensuring that only authorised software is used in the environment and are aware of the probable legal, contractual and financial implications of using unlicensed and unauthorised software.
• Ensure that a Software Asset Management toolset is evaluated, selected, and implemented to aide in the automation and maturing of the Vendor Management process.
• Partake in the Change and Release processes and ensure that changes and releases have considered their impact on software licensing prior to implementation.
   

IT Asset and Configuration Management

• Defining and owning the IT Asset and Configuration Management processes in line with ITIL and industry standard best practices.
• Defining and delivering the IT Asset and Configuration Management strategy including tooling proposition.
• Governing and ensuring compliance to the processes
• Identifying key risks associated to asset and configuration management and supporting the relevant service owner to resolve/mitigate accordingly.
• Stay abreast of trends in asset and configuration management including management, technologies, sourcing, policies, procedures, and other external changes that could have an impact on IT assets.
• Conduct routine audits on CMDB and actual environment to ensure accuracy.
   

Leadership

• Use quality monitoring data management systems to compile and track performance at team and individual level. Provides actionable data to various internal support groups as needed.
• Establish the right organizational structure and provide for staff development.
• Work with internal colleagues to ensure they have the appropriate information and knowledge at hand to be successful in what they do.
• Direct, control, coordinate & optimise resources to meet established objectives & deliver agreed results within the defined functional areas.
• Provide periodic reports on performance against plan & progress on medium-term initiatives & use to realign operating plan and objectives appropriately.
• Use insights & knowledge gained from high level reports to conduct abstract, conceptual & comparative analysis to define functional strategy.
• Proactively identify interconnected problems, develop and model alternative solutions as well as contingency plans to resolve value chain conflicts.
• Continuously identify areas of improvement that will enhance efficiency.
   

GOVERNANCE

• Ensure the consolidation of the risk profile for the area of accountability, manage critical risks and ensure feedback integration.

PEOPLE

• Communicate strategic context that guide best practice, foster an environment of continuous learning and improved employee engagement levels.

FINANCE

• Implement effective financial control, management of costs and corporate governance in area of accountability.

CLIENT

• Define and influence relationships and service level agreements made with internal and external stakeholders.
• Build and maintain relationships with stakeholders to ensure integrated approaches in pursuit of collective goals.
   

Personal Attributes and Skills

• Expert knowledge of IT vendor or supplier relationship management processes, practices, and techniques,
• Expert knowledge of complex software licensing models of major software manufacturers e.g., SAP, Microsoft, BMC, etc.
• Knowledge of Customer Service Techniques,
• Knowledge of ICT Environment,
• Strong knowledge of IT Service Management processes (Incident, Change, Release, Software Asset Management, etc.) as well as experience with Discovery tools
• Ability to engage at all levels of seniority (including Executive Management)
• Decisiveness and Influencing Others
• Effective Business Communication
• Functional Policies and Procedures
• Managerial Budgeting
• Planning, Management and Measurement
• Strategic Planning and Reporting
• Ability to carry out assigned tasks independently with little supervision
• Excellent at performing multiple tasks at the same time without erring
   

Education and Experience

• Relevant Tertiary Qualification
• With at least 8 years’ experience, of which 3 to 4 years at management or supervisory level
• Five years plus experience working with a CMDB and the specific business services that it supports
• Five years or more ITSM tool experience, ServiceNow experience will be advantageous.
• IT Infrastructure Library (ITIL) certification
• Software Asset Management certification
• Proven experience on managing SAM and Contracts in an enterprise environment.