Primary Purpose

This position is primarily responsible for ensuring the timely and accurate preparation of standard and ad hoc statistical and operations reports for United States Refugee Admission Program (USRAP). Under the guidance of the Data Analytics & Visualization Supervisor the Data Analyst assists CWS RSC (Resettlement Support Center) Africa in “telling the story” of resettlement processing in sub-Saharan Africa through data visualization that allows staff and stakeholders to understand the meaning behind the data.

Key Relationships

• Internal to CWS
• Other team members in Admin, Ops & program units External
• Bureau of Population Refugees and Migration (BPRM) Program Officer
• International Organization for Migration (IOM)
• Refugee Processing Center (RPC)
• Other NGOs
• Resettlement Agencies

Working Environment

Office environment, Periodic travel to the field as may be required.

Responsibilities or duties

Data Management and Program Administration (45%)

• 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, IOM and the Resettlement Agencies.
• Works with the START and Case Quality team to prepare and automate regular sectional quality control reports to ensure data accuracy and identify training needs.
• Prepare reports designed to track CWS RSC Africa operations’ productivity for an overall improvement in efficiency.
• Works closely with IT to ensure that reports run in the most current software environment and in publishing QC reports in a user-friendly.

Compliance (30%)

• Updates automated and ad hoc reports in line with START database schema changes and/or Policy and Program changes.
• Maintains a current understanding and keeps abreast of any updates of START or RSC Africa Standard Operating Procedures.
• In coordination with the START and Case Quality team performs quality checks of cases to ensure that cases are up to RSC and RPC standards and adhere to processing guidelines.
• Works closely with Programs staff to ensure that they have adequate reporting tools available to them to enable their departments to meet RSC quality standards and adhere to USRAP processing guidelines.

Representation/Engagement (20%)

• Works closely with RPC staff on issues related to START data fixes and deployed new releases.
• Works with other programs teams when to assist with their reporting needs, as needed.
• Serves as the contact person for all inquiries directed to the team while the Data Analytics & Visualization Supervisor is on leave.
• Actively works on and resolves all work order tickets raised by Programs staff.

Additional Responsibilities (5%)

Performs any other duties assigned to improve the operations of CWS Africa.

Qualifications

• A minimum of 5 years’ relevant paid work experience required
• Good understanding (2+ years required) of databases and Tableau (or other business intelligence tools like Power BI)
• 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

Education & Certifications

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.

Remain alert and responsive to any child safeguarding and PSEAH (Prevention of Sexual, Exploitation, Abuse and Harassment) risks, acquire relevant knowledge and skills which will enable you to promote strong safeguarding PSEAH practices, understand the child safeguarding and PSEAH Policies and procedures, and conduct yourself in a manner consistent with the Child Safeguarding and PSEAH Policies

Special Requirements

This position is based in Nairobi, Kenya.

This position requires use of laptops at all time, competence in Microsoft office packages is required.

Background check which includes references and an educational and criminal check is required before the start of employment

• 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, IOM and the Resettlement Agencies.
• Works with the START and Case Quality team to prepare and automate regular sectional quality control reports to ensure data accuracy and identify training needs.
• Prepare reports designed to track CWS RSC Africa operations’ productivity for an overall improvement in efficiency.
• Works closely with IT to ensure that reports run in the most current software environment and in publishing QC reports in a user-friendly.
• Updates automated and ad hoc reports in line with START database schema changes and/or Policy and Program changes.
• Maintains a current understanding and keeps abreast of any updates of START or RSC Africa Standard Operating Procedures.
• In coordination with the START and Case Quality team performs quality checks of cases to ensure that cases are up to RSC and RPC standards and adhere to processing guidelines.
• Works closely with Programs staff to ensure that they have adequate reporting tools available to them to enable their departments to meet RSC quality standards and adhere to USRAP processing guidelines.
• Works closely with RPC staff on issues related to START data fixes and deployed new releases.
• Works with other programs teams when to assist with their reporting needs, as needed.
• Serves as the contact person for all inquiries directed to the team while the Data Analytics & Visualization Supervisor is on leave.
• Actively works on and resolves all work order tickets raised by Programs staff.
• Performs any other duties assigned to improve the operations of CWS Africa.

• 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

• A minimum of 5 years’ relevant paid work experience required
• Good understanding (2+ years required) of databases and Tableau (or other business intelligence tools like Power BI)
• Experience using Microsoft Visual Studio 2016 in the context of SQL Server Reporting Services required.
• 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).
• 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.
• Remain alert and responsive to any child safeguarding and PSEAH (Prevention of Sexual, Exploitation, Abuse and Harassment) risks, acquire relevant knowledge and skills which will enable you to promote strong safeguarding PSEAH practices, understand the child safeguarding and PSEAH Policies and procedures, and conduct yourself in a manner consistent with the Child Safeguarding and PSEAH Policies