Labels

NGO JOBS ICT - IT Jobs Accounts Health - Medical Sales Jobs Consultancy Jobs Legal Vacancies Electrical Engineers Finance Human Resources Kakamega Media - Communications Monitoring and Evaluation Agriculture - Livestock KHRC Kenya Human Rights Commission KLB Kenya Literature Bureau Lecturer Marie Stopes Kenya Rural Electrification Authority Safaricom Limited Adeso Administrative Civil Engineers Driver Jobs in Kenya Human Rights Jobs Kajiado Oxfam PACT Plan International RTI International Standard Chartered Bank Aga Khan University Hospital Care International Egerton University Jobs in Kisumu Nairobi City Jobs Naivasha Project Management Save the Children UNIVERSITY OF NAIROBI AFC Agricultural Finance Corporation AVIATION JOBS Auditing Commission for University Education Cooperative Bank of Kenya County Public Service Board GOOGLE Geothermal Development Company IPPF International Planned Parenthood Federation Insurance Jobs Intern KANCO Community Systems Strengthening Manager KBC Kenya Broadcasting Corporation KCB Kenya Commercial Bank KIPPRA Kenya Institute for Public Policy Research and Analysis KPMG Kenya Kabarak University Kenya Airways Kenya Investment Authority Kenya Law Reform Commission Kirinyaga County Logistics - Transportation MSF Medecins Sans Frontieres MSI Management Systems International Mandera County Government Marie Stopes International Marketing Jobs Mechanical Engineering Ministry of Education Science and Technology Mombasa NMG Nation Media Group National Bank of Kenya National Construction Authority PSC Parliamentary Service Commission Pan Africa Christian University Procurement Jobs Protection and Human Rights Research Opportunities Telecom Tharaka Nithi County Government Turkana UN Women UNDP UNICEF WHO World Health Organization WWF World Wide Fund For Nature Wajir World Vision
Powered by Blogger.

Monday, July 27, 2015

M-KOPA Solar Business Intelligence Analyst Job

by Unknown  |  at  7:22 AM

  • Position Title: Business Intelligence AnalystLocation: Nairobi
    Reports To: Head of Data Operations
    Position Start: Immediately
    Company Overview: 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 200,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 US $0.45, 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 May 2015 M-KOPA employs over 650 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 model 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.
    Objective: Primarily responsible for designing, testing and executing one-off and regularly run SQL scripts and query packages to extract data from SQL server databases ready for production of data visualizations.
    Part of this function involves ensuring that data quality, integrity and completeness is maintained or improved and that duplicate entities & errors are identified, removed and/or corrected.
    Key Responsibilities and Accountabilities
  • Actively work on routine and ad hoc data and business projects involving querying from the data warehouse.
  • Liaise with the Head of Business Intelligence (BI) and BI Lead Architect on the construction of data extraction queries, reports and automations to ensure compliance with quality standards and established methods.
  • Take ownership of production and testing of data operations reports using provided data sources and tools (SQL Server, PowerQuery, PowerPivot.)
  • Work closely with the BI developer team to ensure that all ongoing development meets the business user requirements.
  • Work with data owners to verify and obtain approval that any transformed data retains its accuracy.
  • Execute one off data extraction and manipulation jobs as required.
  • Work closely with the database administrator to validate any scripts produced and understand the performance impact on the source databases.
  • Train data operations team members on SQL querying and the use of data extraction and visualization tools.
  • Ensure that any data integrity issues are reported immediately and summarized weekly to management and others authorized to receive this information.
  • Any other tasks as directed by Head of Data Operations.Mandatory Technical Skills
  • Practical experience in Microsoft SQL Server (2008, 2012) and Transact SQL
  • Practical experience in Microsoft Excel 2013 for data visualization
  • Practical experience in Microsoft Excel 2013 for accessing external data sourcesIdeal Technical Skills
  • Experience in database query performance analysis and optimization
  • Experience in Microsoft PowerQuery
  • Experience in Microsoft PowerPivot
  • Experience in writing DAX formulaeQualifications
    A technical qualification in a relevant field and/or relevant professional experience. In depth expertise in Transact SQL, MS Office Pro Plus.
    Work Experience & Skills
  • At least 3 years working with databases, two years of which should have involved T-SQL.
  • Expertise in T-SQL, SQL Server, ETL tools, Data conversion, Data De-duplication, Data Cleansing methodologies
  • Effective at understanding a problem and developing one or many approaches to solving the problem.
  • Ability to concentrate on tasks and finish tasks avoiding distractions
  • Retaining objectivity and proper understanding of a problem when placed under stress
  • Ability to follow, adopt, recommend and promote standards regarding the use of data querying and visualization tools and regularly run SQL jobs.
  • Must take the initiative to ensure that technical knowledge relevant to this role stays current and in line with industry developments.
  • Be aware of key business and team objectives and ensure that these are applied appropriately to all business activities
  • Able to develop effective relationships with BI team, Data Operations, Developers, IT and other business users
  • Able to anticipate and understand customer expectations, and ensure that customer requirements are met and expectations appropriately managed. Able to build solid relationships with team members and internal customers.
  • Effective written and verbal communication skills suited for technical audiences, peers, IT management, data users and consumers.
  • Effective at planning and managing own workload and ability to split time between reactive tasks and planned project work.
  • Effective at contributing towards the objectives of a team, and being able to share knowledge, experience, ideas and information. Aware of the needs, objectives and constraints of those in other disciplines and functions.
  • Effective at solving problems in a measured and creative way. Proactive in relation to identifying and undertaking activities that are of benefit to the business. Effective at balancing long and short term objectives. Responsible for own decisions and actions.
  • Act in a professional manner, and exhibit the required behavior that should provide an example to other employees.
  • Needs to be able to identify tasks outside of own remit and work with peers to ensure an end to end solution is effectively delivered.
  • Must be prepared to meet business goals and respond well to change.Remuneration
    We offer a competitive remuneration package, reflective of the candidate’s experience and skills.
    How to Apply
    To apply, send a current, 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.
    The subject of the email should be EV-DATA-BIA.
    The deadline for applications is August 2, 2015.
    Proudly Powered by Blogger.