Data Analyst(N) – Kenya National Hire

Position Title: Data Analyst

Reports To: Data Integrity Supervisor

Division: Immigration & Refugee Program+ (IRP+)

Department: Programs, Compliance

Job Location: Nairobi, Kenya

Grade Level: Grade 6, Specialist, National

Introduction: Church World Service (CWS) is a not-for-profit, faith-based organization transforming communities around the globe through just and sustainable solutions to hunger, poverty, displacement and disaster. CWS does not discriminate on the basis of race, color, religion, sex, national origin, gender identity, genetic information, age, disability or veteran status in employment or in the provision of services.

Primary Purpose:

This position is primarily responsible for ensuring the timely and accurate preparation of standard and ad hoc statistical and operations reports.

Essential Duties:

1. Prepares routine and ad hoc CWS RSC Africa statistical reports as needed for various CWS RSC Africa staff and implementing partners e.g. US Embassy Refugee Coordinator, UNHCR, IOM and the Resettlement Agencies.
2. Prepares and automates regular sectional quality control reports to ensure data accuracy and identify training needs.
3. Prepares reports designed to track CWS RSC Africa operations productivity for an overall improvement in efficiency.
4. Carries out annual inter-departmental process review and recommends improvements in quality control.
5. Updates automated and ad hoc reports in line with START database schema changes and/or Policy and Program changes.
6. Works closely with IT to ensure that reports run in the most current software environment and in publishing QC reports in a user-friendly interface.
7. Continually works on converting as much of the DI reporting portfolio into an automated format on Tableau.
8. Maintains a current understanding and keeps abreast of any updates of START or RSC Africa Standard Operating Procedures.
9. Works closely with RPC staff on issues related to START data fixes and deployed new releases.
10. Works with Administration as needed to assist with their reporting needs.
11. Works closely with Programs staff to ensure that they have adequate reporting tools available to them to enable their departments meet RSC quality standards and adhere to USRAP processing guidelines.
12. Serves as the contact person for all inquiries directed to the Data Integrity Unit while the Data Integrity Supervisor is on leave.
13. Actively works on and resolves all work order tickets raised by Pprograms staff.
14. Other duties as assigned.

Qualifications:

Experience:

• 5 years paid work experience required
• Good understanding (2+ years required) of databases and Tableau (or other business intelligence tools)
• Experience using Microsoft Visual Studio 2016 in the context of SQL Server Reporting Services required.

Skills:

• Advanced knowledge in TRANSACT SQL and Microsoft SQL Server database design, stored procedures, views and functions.
• Advanced computer knowledge, specifically with MS Office (Access, Outlook, Word, PowerPoint). Advanced knowledge in using Tableau Business Analytics software.
• Knowledge of US refugee resettlement and working experience with the START database preferred. Proficiency in using Service now software is a plus.

Education & Certifications:

• Bachelor’s degree or four (4) years of directly related experience in lieu of a Bachelor’s Degree is required.

Abilities:

• • Manage large and diverse workload under pressure with competing priorities. – Maintain the integrity of official records; – Analyze and solve complex problems and make sound decisions; – Work with minimal supervision – Maintain a high performance standard with attention to detail; – Work independently and contribute to overall operations of RSC Africa; – Actively participate in the implementation of the U.S. Refugee Admissions Program (USRAP).

Important Requirements:

• Strong English communication skills, both written and oral.
• Ability to work in a multi-cultural environment required.
• Commitment to diversity, equity, and inclusion and willingness to support CWS’ Platform on Racial Justice as a CWS employee required.

Special Requirements:

• COVID Vaccination is strongly recommended for all successful candidates
• The candidate should be of good health, willing and able to travel extensively in often difficult conditions, and have a high degree of flexibility. Must have proof of Yellow Fever vaccination before traveling for RSC Africa
• This position is based in Nairobi, Kenya.
• This position requires use of laptops at all time, competence in Microsoft office packages is required.
• This position may require travel in sub-Saharan Africa on short notice and under sometimes difficult conditions to meet demands of a dynamic operational program
• Background check which includes references and an educational and criminal check is required before the start of employment for International applicants.
• A valid passport and the ability to maintain a valid passport throughout the entire appointment is required, which includes having enough passport pages for travel.
• Physical: This position requires bending, squatting, crawling, climbing, kneeling, sitting, standing, walking, pushing/pulling, handling objects (manual dexterity), reaching above shoulder level, using fine finger movements and lifting/carrying heavy loads.
• Environmental: Incumbents in this position will be exposed to excessive noise, marked changes in temperature and/or humidity, dust and infectious diseases, harsh weather climates, long work hours, bumpy roads, extended travel, excessive sun exposure, and non-ventilated spaces.
• Full Time
• All employees should be prepared to work from the CWS office within their location of hire. Remote work arrangements may vary depending on location and the governing rulings regarding the COVID-19 pandemic