M-KOPA Solar Business Intelligence Developer Job in Nairobi, Kenya

M-KOPA is seeking:Position Title: Business Intelligence Developer
Location: Nairobi, Kenya
Position Start: As soon as possible
Reporting to: Head of Business Intelligence Systems
About M-KOPA Solar: M-KOPA Solar, headquartered in Nairobi, Kenya, is the global leader of "pay-as-you-go" energy for off-grid customers.
Since its commercial launch in October 2012, M-KOPA has connected more than 240,000 homes in Kenya, Tanzania and Uganda to solar power, and is now adding over 500 new homes each day.
The success of M-KOPA (M= mobile, KOPA= to borrow) stems from making solar products affordable to low-income households on a pay-per-use installment plan.
Customers acquire solar systems for a small deposit and then purchase daily usage "credits" for Kshs 40, or less than the price of traditional kerosene lighting.
After one year of payments customers own their solar systems outright and can upgrade to more power.
All revenues are collected in real-time via mobile money systems (such as M-PESA in Kenya) and embedded GSM sensors in each solar system allow M-KOPA to monitor real time performance and regulate usage based upon payments.
This connected design means that M-KOPA is processing vast amounts of data (i.e. over 10,000 mobile payments per day) via the company's proprietary cloud platform, M-KOPAnet.
As of January 2015 M-KOPA employs over 500 full time staff across East Africa and sells through a network of 1,000 direct sales agents. It has also commenced licensing its technology to partners in other markets.
M-KOPA has been recognised for its pioneering business mode and scale, notably winning the 2015 Zayed Future Energy Prize, being selected as the top New Energy Pioneer at the 2014 Bloomberg New Energy Finance awards and earning the 2013 FT/IFC Excellence in Sustainable Finance Award.
Role Profile
Key Accountabilities

Database modelling and design

Developing ETL processes to aggregate data from transactional systems in our central datamart.

Developing reports using tools such as SSRS and Telerik to support business reporting needs

Clear and concise technical documentation

Resolving BI related support ticketsIncumbent Requirements
Education: Bachelor’s degree /relevant credentials in technology, science, engineering, or electronics.
Experience, Knowledge & Skills:

Required: At least 3 years of SQL Server database development

Required: Demonstrable experience in developing SSIS packages

Required: Strong understanding of database design and modelling concepts

Required: Understanding of data warehouse modelling concepts such as dimensional and tabular models

Required: Advanced knowledge of MS Excel and its embedded BI capabilities

Strong experience with deploying database specific technologies and techniques including:1. SQL Server, T-SQL, SSIS, SSRS, SSAS
2. DDL, DML, Stored Procedures, Views, Functions
3. Database Design / Development experience using SQL Server including: DDL/DML, stored procedures, triggers, DTS or SSIS, SQL Agent
Demonstrated experience and solid knowledge in three or more of the following areas: SOX / FFIEC - Compliant Database Development, Security, Architecture, Analysis, Design, Testing,

Documentation, Implementation, Version Control, Change Management

Preferred: Experience working in an Agile environment

Strong analytical and problem solving skills with keen attention to detail

Self-motivated with the ability to prioritize, meet deadlines, and manage own time with changing priorities

A results oriented individual who thrives working in a fast paced environment

Excellent interpersonal skills with a willingness to go the extra mile to assist other team membersRemuneration: Competitive package covering a monthly salary, performance bonus and medical benefits reflective of the candidate’s experience and skills.
How to Apply
To apply, send an updated detailed copy of your CV and a cover letter expressing why you feel you would be an excellent candidate for the role to careers@m-kopa.com with the subject EV-BI Developer-2044
Deadline for applications 5pm on Sunday 1st November, 2015.
Please Note: Due to the large number of applications received by us, we regret that you will not be contacted unless you are short listed for the post and invited for an interview.
Therefore, if you have not heard from M-KOPA within 4 weeks of the date of the deadline your application, you should assume that you have not been successful on this occasion.
This measure has been taken in the interests of efficiency and cost effectiveness and we apologize for any inconvenience this may cause.