Developer-business systems planning (business intelligence)

Developer-business systems planning (business intelligence)
In keeping with our current business needs, we are looking for a person who meets the criteria indicated below:
Reporting to the Senior Manager Business Systems Planning, the role holder will be in charge of Development and 3rd line support of Safaricom Management Information Systems (Data Ware-house and Business intelligence (BI)) and all reporting and analytics systems. This will include, but not limited to, Churn management tools, Fraud management and Revenue assurance systems, Data Mining Systems, Campaign Management Systems and Dealer Incentive Management systems; Work with other departments within the company to identify requirements and develop solutions (database design, workflows, user/data interfaces) ;Configure and/or customize BI and analytics systems to meet business requirements using various database and software tools; Assist in presentations of system functionality to new users and departments ;Enhance and create user and system documentation as needed.
Key Responsibilities:

• Create test plans, test data sets and perform automated testing to ensure all components of the developed systems meet specifications;
  
• Work directly with the IT support personnel and teams to resolve issues identified and escalated during daily operations;
  
• Perform root cause analysis for recurring incidents;
  
• Formalize test plans and implement troubleshooting procedures;
  
• Upgrading products and applying patches as necessary;
  
• Maintaining and modifying reports/queries on an as-needed basis;
  
• Managing and supporting the security implementation;
  
• Troubleshooting database connectivity issues;
  
• Maintaining, coordinating back up and restoring the ETL and Reports repositories  and other Systems binaries and source codes;
  
• Conduct business user requirements analysis and specification;
  
• Specify computer system requirements for the solution of complex business problems and formulates designs for their solutions;
  
• Perform the necessary technical design and development functionality to ensure that business application systems can be effectively developed and implemented;
  
• Design and development of front-end tier(s), middle tier(s), and /or back-end database tier(s) for business applications. Capturing of business applications information needs and mapping of the same to the software and /or database components;
  
• Performs data modelling to analyse and specify data structures within an application system;
  
• Coding of all ETL and analytics processes used within the BI systems;
  
• Perform the necessary technical design and development functionality to ensure that reporting needs can be effectively developed and implemented;
  
• Research and provide input on design approach, performance and base functionality improvements for various procedures and applications;
  

Role requirements;

• Degree in Computer Science, Statistics or technical related field;
  
• Oracle Certified Developer;
  
• Certification in RDBMS;
  
• 3 years development experience with development tools e.g. Java ;
  
• 3 years development experience with low level programming C++, C.;
  
• 3 years’ experience RDMS preferably Oracle, MS SQL Server;
  
• 3 years’ experience in data warehousing, business analysis, knowledge in Business Systems modeling and data retrieval;
  
• 4GL for programming - Visual Basic/Oracle Application builder;
  
• SAS/SPSS Data Mining experience will be an added advantage;
  
• Systems Analysis and Solutions Architecting;
  
• Programming and Systems Development;
  
• SQL & Oracle database management ;
  
• Data Quality & Cleansing experience;
  
• Advanced Unix scripting and user skills;
  
• Experience in processes and procedures management;
  
• Communication, interpersonal skills and attention to details.
  

If you feel that you are up to the challenge and possess the necessary qualification and experience, please send your resume with your cell phone contact indicating your experience and why you are the most suitable candidate for the role clearly quoting the job title and job reference to the address below by Tuesday 26th August 2014.

The Head of Talent and Resourcing,
Safaricom Limited
Nairobi via E-mail to hr@safaricom.co.ke